SOUNDEX

The SOUNDEX function returns a character string containing the phonetic representation of a text expression. This function lets you compare words that are spelled differently, but sound alike in English.

See:

For a discussion of how the phonetic representation is constructed, see the SOUNDEX function in Oracle Database SQL Language Reference

Return Value

The same data type as text_exp.

Syntax

SOUNDEX(text_exp)

Parameters

text_exp: The expression for which you want a phonetic representation. It can be any of the text data types.