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 = 'WR' order by rank asc limit 0,100 Surnames > W > WR > WRA

Surnames > W > WR > WRA

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
WA WC WD WE WH WI WL WN WO WR WS WU WY WZ
WRA WRE WRI WRO WRU WRY WRZ

Full Surname List Starting with WRA(Alphabetical)

WRABEL
WRAGE
WRAGG
WRAGGE
WRAGGS
WRAIGHT
WRAITH
WRANOSKY
WRAPE
WRASE
WRASMAN
WRASPIR
WRASSE
WRATCHFORD
WRATH
WRATHALL
WRATHER
WRATTEN
WRAY
WRAZEN

Top 100 Surnames in the 2010 US Census starting with WRA

SurnameCountRankWiki?
WRAY 15405 2367 yes
WRAGG 591 37646 no
WRAGE 497 43438 no
WRATCHFORD 442 47878 no
WRATHER 356 57234 no
WRAGGE 314 63524 no
WRATTEN 295 66931 no
WRAIGHT 215 86645 no
WRATHALL 189 96368 no
WRAZEN 189 96368 no
WRAITH 174 103181 no
WRAGGS 171 104602 no
WRABEL 159 110825 no
WRASMAN 149 116829 no
WRASSE 139 123796 no
WRASPIR 124 135593 no
WRASE 124 135593 no
WRAPE 117 142108 no
WRANOSKY 108 151532 no
WRATH 106 153769 no