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 > YAU

Surnames > Y > YA > YAU

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 YAU(Alphabetical)

YAU
YAUCH
YAUGER
YAUGHN
YAUK
YAUN
YAUNEY
YAURI
YAUSSI
YAUSSY

Top 100 Surnames in the 2010 US Census starting with YAU

SurnameCountRankWiki?
YAU 3033 10565 no
YAUGER 709 32438 no
YAUN 577 38389 no
YAUCH 565 39004 no
YAURI 263 73666 no
YAUGHN 179 100791 no
YAUK 172 104156 no
YAUSSY 154 113791 no
YAUNEY 110 149395 no
YAUSSI 105 154907 no