SOUNDEX()

SOUNDEX converts an alphanumeric string to a four-character code that is based on how the string sounds when spoken in English.

The first character of the code is the first character of character_expression, converted to upper case.

 

Two srings may be evaluated to see how similar they sound when spoken.

-- SOUNDEX()
SELECT SOUNDEX('FLOYD') AS RESULT
FROM DUAL;

SELECT SOUNDEX('POLITE'), SOUNDEX('PLIGHT')
FROM DU
AL;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top