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 = 'AO' order by rank asc limit 0,100 Surnames > A > AO > AOY

Surnames > A > AO > AOY

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
AO AOK AON AOU AOY

Full Surname List Starting with AOY(Alphabetical)

AOYAGI
AOYAMA

Top 100 Surnames in the 2010 US Census starting with AOY

SurnameCountRankWiki?
AOYAMA 359 56836 no
AOYAGI 280 69996 no