SOUNDEX
This will be used to find words that sound like other words, exclusively used in where clause.
This function return the values whose pronunciation as some but spell differently.
Syntax: soundex (string)
Ex:
select * from emp where soundex(ename) = soundex('SMIT');output on tool
