An optimized Damerau-Levenshtein Distance (DLD) algorithm for "fuzzy" string matching in Transact-SQL 2000-2008
Greatly improve SSIS Fuzzy Grouping performance by using a Conditional Split and Multi Cast.
Roll Your Own Fuzzy Match / Grouping (Jaro Winkler) - T-SQL
Roll Your Own SSIS Fuzzy Matching / Grouping (Jaro - Winkler)
Just wondering... Instead of deleting those "undesirable" characters, could we replace with a character of our choice? Hum.... how about replacing each undesirable character with another one (if defined) otherwise replaced with a common character ('')
From BOL:<Quote>The WHERE and HAVING clauses in a SELECT statement control the rows from the source tables that are used to build the result set. WHERE and HAVING are filters. They specify a series of search conditions, and only those rows that meet the terms of the search conditions are used to build the result […]