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)
 Fulltext or Fuzzy solution advice

Author  Topic 

G81
Starting Member

2 Posts

Posted - 2013-01-30 : 17:09:31
Hi guys,

I have 2 simple tables. both have 1 nvarchar(100) column and a PK ID column with an auto increment seed. What I want to do is return all of 1 table, and only the 2nd table where the value is very similar. (i.e. a spelling mistake, or the addition/absence of specific key words.). I also want to be able to use a thesaurus if possible. I've gone at this problem two way, but am after any advice or input please:

1) SSIS Fuzzy Lookup
It's working quite well, but not great for small words and cant seem to find a way to use a thesaurus file and to include stop words or noise words.

2) Freetext, Contains, and Formsof
Great functionality, but how would it work for my above example? Is it possible to join both tables together in this way, and 2 only return high scoring matches from the 2nd lookup table?

As an example I might have:

MyCompany Danmark in Table1
MyCompany Denmark in Table2

Danmark and Denmark in my thesaurus file

and therefore an exact match. Also If LTD is included in either table for that row, it'll still return as an exact match due to it being in some sort of stop/noise list. Any idea's on how to implement something like this? And am I on the right track?
   

- Advertisement -