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

Surnames > Y > YA > YAL

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

YALAMANCHI
YALAMANCHILI
YALCH
YALCIN
YALDA
YALDO
YALDOO
YALE
YALEY
YALLUP
YALUNG

Top 100 Surnames in the 2010 US Census starting with YAL

SurnameCountRankWiki?
YALE 2402 12830 no
YALDO 634 35489 no
YALAMANCHILI 547 40082 no
YALDA 492 43811 no
YALCIN 289 68122 no
YALUNG 243 78567 no
YALCH 241 79075 no
YALDOO 155 113155 no
YALLUP 124 135593 no
YALAMANCHI 122 137327 no
YALEY 107 152628 no