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

Surnames > K > KM > KMA

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
KMA KME KMI KMO

Full Surname List Starting with KMA(Alphabetical)

KMAK
KMAN

Top 100 Surnames in the 2010 US Census starting with KMA

SurnameCountRankWiki?
KMAK 215 86645 no
KMAN 123 136449 no