DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values : Difference « String Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. String Functions
  3. Difference

DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values

1> -- DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values.
2>
3> -- reducing the result to a scale from 0 to 4, where the value 4 indicates a very close or exact match.
4>
5> SELECT DIFFERENCE('To', 'Two')
6>
7> GO

-----------
          4

(1 rows affected)
1>








Related examples in the same category

1.Using the DIFFERENCE() function to compare Redmond with Renton
2.DIFFERENCE: work out when one string sounds similar to another string
3.SELECT DIFFERENCE ( 'Fleas', 'Fleece')