If you want all unique "sounds like" pairs, join the table to itself on the sound-like relation, and insert a where condition to eliminate duplicates and identical spellings
proc sql;
select a.name,b.name
from
have as a
inner join
have as b
on a.name =* b.name
where a.name < b.name;
quit;
Of course, the sounds-like relation only allow equality/non-equality. It doesn't all any notion of "distance" between a pair of names.
... View more
