Fuzzy Lookup
-
Greetings,
I have been trying to find some more info on the fuzzy lookup features of SSIS. I have tested both fuzzy grouping and fuzzy lookup from within BI dev studio, and it works great.
My questions are:
1. Is there a way to call the string similarity function directly from SQL? For example, if I want all rows from table1 where column1 is similar to a search string: SELECT * from table1 WHERE similarityfunction("something", column1) > 0.8
2. If not, what is the best way to do fuzzy lookup of one item programmatically from a VB or C# program? It seems like overkill to create new SSIS packages when I want to look up one item in a table.
Sorry if these are newbie questions, I am a PostgreSQL/MySQL user who recently started developing for MS SQL Server 2005.
-
I am also interested in an answer to this question.
-
"similarityfunction("something", column1) > 0.8"....I think "build your own SQL function" unfortunately will be the standard response.
-
Andrew is correct. Fuzzy logic features are only available in SSIS. If you want similar functionality in T-SQL then request it at the feedback center: http://lab.msdn.microsoft.com/productfeedback/default.aspx
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson -
I see someone else already made this suggestion to Microsoft...
Time for me to learn how to call compiled C functions from SQL.
-
Lars-302224 (3/31/2006)
I see someone else already made this suggestion to Microsoft...
Time for me to learn how to call compiled C functions from SQL. <img src='images/emotions/laugh.gif' height='20' width='20' border='0' title='Laugh' align='absmiddle'>
Look http://www.walnutilsoft.com and Lucene API where you can find how easy to do search "fuzzy"...
Igor.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply