Help Required Please + SQL Server 2005 + LIKE Query

Hi Guys

I am in need of some assistance please.

I am using SQL Server 2005 and C#(winforms).

For example if I have a winform with a textbox and search button. If I type in ABCD1234. I won't know what the data is coming into the X Table. So there will be hundreds of description data in the description field in X table.

So in the X Table, there are ABCD1234,ABCD_1234,ABCD/1234,ABCD 1234

But I will only pick this 'ABCD1234' record up, and the rest won't be picked. They are variations of the same description. It needs to pick also ABCD_1234,ABCD/1234,ABCD 1234

If also type in 5678, in another column like code in X Table. It would have 005678,05678,56780. But I will only pick this '5678' record up, and the rest won't be picked. They are variations of the same code.
It needs to pick also 005678,05678,56780

I have tried LIKE, FREETEXT and CONTAINS.

But another idea is a table of alternate descriptions for those that you know about and look those up and search for them all. But how can that be done?

Any ideas guys please? with examples if possible.

Thanks Newbie.....