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

Surnames > Y > YE > YET

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
YE YEA YEB YEC YED YEE YEF YEG YEH YEI YEK YEL YEM YEN YEO YEP YER YES YET YEU YEV YEW YEZ

Full Surname List Starting with YET(Alphabetical)

YETKA
YETMAN
YETSKO
YETT
YETTAW
YETTE
YETTER
YETTO
YETZER

Top 100 Surnames in the 2010 US Census starting with YET

SurnameCountRankWiki?
YETTER 2903 10959 no
YETMAN 703 32676 no
YETT 400 51941 no
YETZER 230 82044 no
YETTO 223 84136 no
YETSKO 174 103181 no
YETTAW 128 132206 no
YETKA 124 135593 no
YETTE 112 147253 no