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

Surnames > W > WA > WAZ

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

WAZ
WAZELLE
WAZIR
WAZIRI
WAZNY
WAZWAZ

Top 100 Surnames in the 2010 US Census starting with WAZ

SurnameCountRankWiki?
WAZNY 421 49824 no
WAZ 304 65244 no
WAZIRI 207 89403 no
WAZIR 176 102197 no
WAZWAZ 160 110286 no
WAZELLE 129 131379 no