In SQL server SELECT statement, in a WHERE condition, you may not know the exact spelling of searched data. In such cases generally we use wild card (*) which raises more false-positives. This tool comes handy by allowing you to set a spelling tollerance while searching data using in SELECT Statements in SQL Server. Example, if you are searching for "His Name was SuperMan" in column "FirstName" with a spelling mistake tollerance of 20%, the SELECT statement can be SELECT * from MyTable WHERE dbo.DamLevDisCLR(FirstName,"His Name was SuperMan",1)>=80 There are three parameters. 1. Column name to search. 2. Searched Data. 3. "1" for Ignore Case in search. "0" for Case based search while matching the string. |