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 = 'ID' order by rank asc limit 0,100 Surnames > I > ID > IDD

Surnames > I > ID > IDD

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
IDA IDD IDE IDI IDL IDN IDO IDR IDS IDZ

Full Surname List Starting with IDD(Alphabetical)

IDDEEN
IDDINGS
IDDINS

Top 100 Surnames in the 2010 US Census starting with IDD

SurnameCountRankWiki?
IDDINGS 1091 23333 no
IDDEEN 127 133048 no
IDDINS 114 145220 no