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

Surnames > Y > YE > YES

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

YES
YESAYAN
YESCAS
YESH
YESKA
YESKE
YESKEY
YESKO
YESMIN
YESS
YESTER

Top 100 Surnames in the 2010 US Census starting with YES

SurnameCountRankWiki?
YESCAS 1061 23817 no
YESKE 570 38754 no
YESKO 242 78821 no
YESAYAN 223 84136 no
YESTER 221 84748 no
YESMIN 209 88685 no
YESH 188 96799 no
YESKEY 128 132206 no
YES 114 145220 no
YESKA 102 158432 no
YESS 100 160975 no