DIFFERENCE: work out when one string sounds similar to another string : Difference « String Functions « SQL Server / T-SQL






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

DIFFERENCE: work out when one string sounds similar to another string

1> -- DIFFERENCE: work out when one string sounds similar to another string.
2>
3> -- '0' means that the two strings aren't even close,
4> -- '4'   means a perfect match
5>
6> DECLARE @s1 varchar(6)
7> DECLARE @s2 varchar(6)
8> SET @s1 = "Dewson"
9> SET @s2 = "Joosun"
10>
11> SELECT DIFFERENCE(@s1,@s2)
12> GO

-----------
          3

(1 rows affected)
1>








Related examples in the same category

1.DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values
2.Using the DIFFERENCE() function to compare Redmond with Renton
3.SELECT DIFFERENCE ( 'Fleas', 'Fleece')