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 = 'AS' order by rank asc limit 0,100 Surnames > A > AS > ASG

Surnames > A > AS > ASG

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
AA AB AC AD AE AF AG AH AI AJ AK AL AM AN AO AP AQ AR AS AT AU AV AW AX AY AZ
ASA ASB ASC ASD ASE ASF ASG ASH ASI ASK ASL ASM ASN ASO ASP ASQ ASR ASS AST ASU ASW ASZ

Full Surname List Starting with ASG(Alphabetical)

ASGARI
ASGEDOM
ASGHAR
ASGHARI

Top 100 Surnames in the 2010 US Census starting with ASG

SurnameCountRankWiki?
ASGHAR 838 28465 no
ASGARI 323 62045 no
ASGEDOM 153 114424 no
ASGHARI 143 120901 no