One of the last things I want to be confronted with in a project is using fuzzy logic in stored procedures to check if something already exists in a database.  Let's face it, it's never easy and always an inexact science, at least for me. 

However, there is a silver lining to the dark cloud that is fuzzy logic, SimMetrics.

I'm a big fan of using othe peoples genius to make myself look good.  After all, why reinvent the wheel, when someone smarter has created a better wheel than you ever could.   I'm not diminishing myself, but I know where my strengths reside.

Anyhow, there is a great article written by Tasos Yalanopoulos has a great post that he wrote on setting up SimMetrics on a SQL Server database.  If you follow his instructions, he'll get you to the promised land. Tasos' post is called Beyond SoundEx - Functions for Fuzzy Searching in MS SQL Server and is a great read.

I want to give a shout out to my friend Rich Dudley for pointing me, through his blog, to this post.