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

Surnames > K > KS > KSO

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
KSH KSI KSO

Full Surname List Starting with KSO(Alphabetical)

KSOBIECH
KSOR

Top 100 Surnames in the 2010 US Census starting with KSO

SurnameCountRankWiki?
KSOR 497 43438 no
KSOBIECH 125 134712 no