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

Surnames > W > WA > WAA

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
WA WAA WAB WAC WAD WAE WAF WAG WAH WAI WAJ WAK WAL WAM WAN WAP WAQ WAR WAS WAT WAU WAV WAW WAX WAY WAZ

Full Surname List Starting with WAA(Alphabetical)

WAACK
WAAG
WAAGE
WAAGEN
WAAK
WAALEN
WAALKES
WAARA
WAAS
WAASDORP
WAATTI

Top 100 Surnames in the 2010 US Census starting with WAA

SurnameCountRankWiki?
WAAGE 749 31001 no
WAAS 472 45347 no
WAACK 452 47006 no
WAARA 352 57781 no
WAAG 319 62714 no
WAAK 274 71265 no
WAALKES 234 80926 no
WAASDORP 180 100302 no
WAALEN 131 129825 no
WAAGEN 127 133048 no
WAATTI 113 146201 no