The Oracle and PL/SQL SOUNDEX function returns a phonetic representation of a string.
The general format is:
SOUNDEX(char)
This function lets you compare words that are spelled differently, but sound alike in English.
Example 1:
SELECT SOUNDEX('JOHN WILLIAMS') FROM DUAL;
returns:
J457