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

Surnames > W > WO > WOT

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
WO WOB WOC WOD WOE WOF WOG WOH WOI WOJ WOK WOL WOM WON WOO WOP WOR WOS WOT WOU WOW WOX WOY WOZ

Full Surname List Starting with WOT(Alphabetical)

WOTEN
WOTHE
WOTHERSPOON
WOTIPKA
WOTRING
WOTRUBA
WOTTON

Top 100 Surnames in the 2010 US Census starting with WOT

SurnameCountRankWiki?
WOTRING 1156 22301 no
WOTTON 524 41501 no
WOTEN 339 59603 no
WOTRUBA 196 93513 no
WOTHE 169 105600 no
WOTIPKA 152 115034 no
WOTHERSPOON 145 119508 no