Fuzzy Lookup/Matching in SQL Server 2005
One of the new features of SQL Server 2005 is Fuzzy Lookup/Matching. This allows a query to return results that may not be an exact match, but close enough. Many people began to wonder how does this feature work. Microsoft published an article that explains this feature in detail, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2005ftsearch.asp.