How to find similar (but different) names with the same soundex value? I got the output with the same name and same soundex value, but I want the result which has similar name and same soundex value.

Can anyone help me to do this?
You can use a window function for this:

select *
from (
   select name, 
          count(*) over (partition by soundex(name)) as cnt
   from poi
) t
where cnt &gt; 1;