Need Help in FULL TEXT SEARCH

Question

Post reply

Need Help in FULL TEXT SEARCH

vineet.bhargava

Valued Member

Points: 50
More actions
October 11, 2011 at 8:32 am

#249853

Hi
I have one table which has millions of records in it , and i have implement Full Text Search Index on Item_nm column of varchar(500) type and i'm using contains with inflectional form to fetch result, Now If i say i search for "Iphone Speaker" and if any of the item_nm contains "Iphone Speakers" Or "Iphone Speaker" it will give me the result. But I want in such a way that i search for "Speakers IPhone" then also it will Give "IPhone Speakers" in Search Result.
Is there any way to Implement this. Please help me
Thaks For your help in advance
Vineet Bhargava

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

isuckatsql SSChampion Points: 10381 More actions · Answer 1

isuckatsql

SSChampion

Points: 10381

October 11, 2011 at 8:36 am

#1392897

Did you try using the 'Thesaurus' feature ?

vineet.bhargava Valued Member Points: 50 More actions · Answer 2

Hi ,

I have not used Thesaurus, any help over this..

Thanks

Vineet Bhargava.

isuckatsql SSChampion Points: 10381 More actions · Answer 3

http://sqlblog.com/blogs/greg_low/archive/2008/08/13/modifying-the-thesaurus-in-full-text-search-in-sql-server-2008.aspx

vineet.bhargava Valued Member Points: 50 More actions · Answer 4

Hi,

I Checked that but the problem is that i have millions of data with me and i dont know on which items users will make the search is there any thing else which i can make it easy without adding keywords in thersaurus.