Hey Eric, Check out the zip files at the bottom of the article, you should find it there.

I figured this out, name changes don't require you to re-enter the password.

Nice article, thanks for posting. Good discussion starter as well. 😉

Yep, for the most part that is exactly what I'm dong for the fuzzy matching.

I've found (heavily) indexed #temp tables to help significantly with speed on larger datasets. Calculate your double metaphone and cleaned up variants once, and then do Jaro-Winkler based on...

mike.renwick (2/2/2011)

---

Here's my C# SQL CLR implementation- just deploy to an SQL server.

In my opinion, for anything involving significant string manipulation, a CLR language is vastly superior to SQL server...

Thanks for the script, I like they way you created the tally table on the fly lilke that, I never thought of doing that! Here is what I've...

Thanks for the article Shawn. This is really helpful, I appreciate all the links you've provided as well.

Tough question, thanks for posting. This one should have been worth more than one point.

Edit: I guess it also helps to read the entire article and discussion before asking questions, since doing so makes it abundantly clear I was using the wrong function...

Thank you for the code Anatoliy. I'll play around with this. It seems like a good approach might be blend this with the Jaro Winkler function.

Adam

This is a great article, thank you so much for posting. I am trying to implement a similar solution in my organization, and was doing some testing on your...