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

Surnames > W > WH > WHR

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
WHA WHE WHI WHO WHR WHY

Full Surname List Starting with WHR(Alphabetical)

WHREN
WHRITENOUR

Top 100 Surnames in the 2010 US Census starting with WHR

SurnameCountRankWiki?
WHRITENOUR 362 56444 no
WHREN 113 146201 no