 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / August 2006Using FREETEXTTABLE together with SOUNDEX
There are some conflicting reports about this on the web, but as best as I can tell FREETEXTTABLE includes stemming and thesaurus features but not SoundEx abilities. I would appreciate any help on using FREETEXTTABLE and SoundEx together in a query, particularly in regards to doing searches on people's names where stemming and thesaurus methods are not very usefull. I've seen examples of using FREETEXT and SoundEx together; however, I need the ranking information that FREETEXTTABLE provides. I'm also aware, based on the reports of others on the web, that SoundEx in SQL Server has plenty of problems, but I will have to push out implementing one of the other algorithms as a future enhancement. Any assistance would be greatly appreciated. Thank you, Terry ______________________ Terry Smith Senior Architect Insight Ecosystems http://www.insightecosystems.com I believe Oracle and IBM support Soundex features in the SQL FTS products. SQL Server does not. However the fuzzy grouping function of SSIS does have this functionality. Exactly what are you trying to accomplish? Searches on Smith to match with Smyth, Smith, Smithe, Smythe?  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > There are some conflicting reports about this on the web, but as best as I > can tell FREETEXTTABLE includes stemming and thesaurus features but not [quoted text clipped - 20 lines] > Insight Ecosystems > http://www.insightecosystems.com Hi Hilary, Thanks for your reply. Yes, I'm looking for exactly what you said, "Searches on Smith to match with Smyth, Smith, Smithe, Smythe". I was hoping for an innovative way of perhaps joining a SoundEx query together with FREETEXTTABLE in a single statement. Terry ______________________ Terry Smith Senior Architect Insight Ecosystems http://www.insightecosystems.com > I believe Oracle and IBM support Soundex features in the SQL FTS products. > SQL Server does not. [quoted text clipped - 28 lines] > > Insight Ecosystems > > http://www.insightecosystems.com If you know all possible variations in advance use the thesaurus feature. SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi Hilary, > [quoted text clipped - 52 lines] >> > Insight Ecosystems >> > http://www.insightecosystems.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.