SQL Server Performance

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

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by waqar, Apr 25, 2007.

  1. waqar Member

    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.
  2. Jack Vamvas Member

    SELECT * FROM TBLA WHERE (contains(col1, '"12345abcd"'))

    ___________________________________
    Need an IT job? -http://www.ITjobfeed.com

  3. waqar Member

    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.

Share This Page