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 = 'KO' order by rank asc limit 0,100 Surnames > K > KO > KOY

Surnames > K > KO > KOY

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
KA KE KF KH KI KJ KL KM KN KO KP KR KS KU KV KW KY
KO KOA KOB KOC KOD KOE KOF KOG KOH KOI KOJ KOK KOL KOM KON KOO KOP KOR KOS KOT KOU KOV KOW KOX KOY KOZ

Full Surname List Starting with KOY(Alphabetical)

KOY
KOYA
KOYAMA
KOYANAGI
KOYFMAN
KOYL
KOYLE

Top 100 Surnames in the 2010 US Census starting with KOY

SurnameCountRankWiki?
KOYAMA 795 29626 no
KOY 567 38902 no
KOYLE 469 45569 no
KOYANAGI 323 62045 no
KOYFMAN 277 70645 no
KOYA 253 76029 no
KOYL 164 108199 no