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

Surnames > W > WE > WEW

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
WE WEA WEB WEC WED WEE WEF WEG WEH WEI WEL WEM WEN WEP WER WES WET WEU WEV WEW WEX WEY

Full Surname List Starting with WEW(Alphabetical)

WEWER
WEWERS

Top 100 Surnames in the 2010 US Census starting with WEW

SurnameCountRankWiki?
WEWERS 227 82908 no
WEWER 166 107134 no