How to find similar (but different) names with the same soundex value?
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;