SQL Server SOUNDEX() Function

Evaluate the similarity of two strings, and return a four-character code:

SELECT SOUNDEX('Juice'), SOUNDEX('Jucy');

Definition and Usage

The SOUNDEX() function returns a four-character code to evaluate the similarity of two expressions.

Note: The SOUNDEX() converts the string to a four-character code based on how the string sounds when spoken.

Tip: Also look at the DIFFERENCE() function.

SOUNDEX( expression)

Parameter	Description
expression	Required. The expression to evaluate. Can be a constant, variable, or column

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Evaluate the similarity of two strings, and return a four-character code:

SELECT SOUNDEX('Juice'), SOUNDEX('Banana');