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

Surnames > K > KR > KRC

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
KRA KRC KRE KRI KRM KRO KRP KRS KRU KRY KRZ

Full Surname List Starting with KRC(Alphabetical)

KRC
KRCHMAR
KRCIL
KRCMA
KRCMAR

Top 100 Surnames in the 2010 US Census starting with KRC

SurnameCountRankWiki?
KRCMA 138 124548 no
KRCMAR 116 143149 no
KRC 110 149395 no
KRCHMAR 106 153769 no
KRCIL 104 156044 no