Soundex property of sql server
It returns how string will be pronounced as hexa decimal values
select * from employee where ename='skot'
and here suppose here real name is scott
but if we do like this
select * from employee where soundex(ename)=soundex('skot')
this time it will give results of scott