Soundex – Oracle SQL Function

SOUNDEX returns the phonetic representation of argument1.

It is often used to do searching in a table to find words that sound the same as each other but are spelled differently.

The argument arg1 can be a CHAR, VARCHAR2, NCHAR, NVARCHAR2 data type.

Example:

SELECT FIRST_NAME FROM EMP WHERE SOUNDEX(FIRST_NAME) = SOUNDEX(‘DAN’);

FIRST_NAME
——————-
Diana
Den