Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Full Text searches

Author  Topic 

Taurkon
Starting Member

26 Posts

Posted - 2007-11-19 : 15:51:17
I have reviewed the documentation on full text searches and don't see any syntax for doing searches on similar data. I think I am probably missing something.

I want to do a search on a phrase or word, and have any similar results returned. For inistance, I'd like any rows returned where there is an attribute that contains text similar to 'gld'. And example of expected results would be;

Golden
Gold
Old
Glad

I'd also like to weight these.

Any help would be appreciated.


   

- Advertisement -