SQL Server Performance Forum – Threads Archive

Using Full-Text index search, How to search this?

Hi, I have table TBLA with Column Col1 VARCHAR(200) (Col1 has Full-Text Index Enabled). I have a few values in Col1 1- 12345abc
2- 12345abcd
3- 12345abcde Now i wanted to return all those records where Col1 is nearly matching to value "12345abcd". Is there anyway to accomplish this? ________________________________________________
Be great in act, as you have been in thought.

SELECT * FROM TBLA WHERE (contains(col1, ‘"12345abcd"’)) ___________________________________
Need an IT job? –http://www.ITjobfeed.com

quote:Originally posted by Jack Vamvas SELECT * FROM TBLA WHERE (contains(col1, ‘"12345abcd"’))

Hi Jack, First thanks for reply, may be i was not clear in my question.
I should have said that i want all 3 above match when i use search values ‘12345abcd’. Is there any percentage match like if word match 80%, something like (weight of match) [B)]? ________________________________________________
Be great in act, as you have been in thought.

]]>