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 = 'YA' order by rank asc limit 0,100 Surnames > Y > YA > YAP

Surnames > Y > YA > YAP

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
YA YB YC YD YE YG YH YI YL YM YN YO YP YR YS YT YU YV YZ
YA YAA YAB YAC YAD YAE YAF YAG YAH YAI YAJ YAK YAL YAM YAN YAO YAP YAQ YAR YAS YAT YAU YAV YAW YAX YAY YAZ

Full Surname List Starting with YAP(Alphabetical)

YAP
YAPLE
YAPO
YAPOR
YAPP

Top 100 Surnames in the 2010 US Census starting with YAP

SurnameCountRankWiki?
YAP 4590 7261 no
YAPLE 811 29198 no
YAPP 542 40371 no
YAPO 131 129825 no
YAPOR 127 133048 no