select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'IP' order by rank asc limit 0,100 Surnames > I > IP > IPS

Surnames > I > IP > IPS

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
IA IB IC ID IE IF IG IH II IJ IK IL IM IN IO IP IQ IR IS IT IU IV IW IX IY IZ
IP IPA IPE IPI IPO IPP IPS

Full Surname List Starting with IPS(Alphabetical)

IPSEN
IPSON

Top 100 Surnames in the 2010 US Census starting with IPS

SurnameCountRankWiki?
IPSEN 601 37125 no
IPSON 383 53913 no