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 = 'CW' order by rank asc limit 0,100 Surnames > C > CW > CWI

Surnames > C > CW > CWI

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
CA CD CE CH CI CL CM CN CO CR CS CU CV CW CY CZ
CWA CWI CWY

Full Surname List Starting with CWI(Alphabetical)

CWIAK
CWIAKALA
CWICK
CWIEK
CWIK
CWIKLA
CWIKLINSKI

Top 100 Surnames in the 2010 US Census starting with CWI

SurnameCountRankWiki?
CWIK 650 34758 no
CWIKLINSKI 462 46138 no
CWIKLA 439 48160 no
CWIEK 198 92719 no
CWIAKALA 138 124548 no
CWICK 114 145220 no
CWIAK 103 157234 no