SOUNDEX

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

Example: select * from emp where lastname SOUNDEX('SMITH');