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.
| Author |
Topic |
|
BackHome355
Starting Member
1 Post |
 Posted - 2014-03-06 : 00:11:29
|
| Hi I am new to SQL server management studio but have some experience doing basic queries and such. I am trying to preform a Levenshtein Distance fuzzy match between 2 tables. I did a bit of searching and found this great site that has everything I need: http://levenshtein.blogspot.com/2011/04/how-it-is-done.htmlI just can not figure out how to preform the search with 2 tables. I can preform the example in the post no problem so the stored procedure works.I have Table1 and Table2 both contain columnA, columnB and columnC. I am trying to compare Table1's columnA, columnB and columnC to Table2's columnA, columnB and columnC and the result would allow me to return some columns from Table2. I also need to return the percentage of the match from the search.If anyone can help me or point me in the right direction I would really really appreciate it, I'm pulling out my hair here. |
|
|
|
|
|
Levenshtein distance in SQL Server 2012