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 = 'ND' order by rank asc limit 0,100 Surnames > N > ND > NDO

Surnames > N > ND > NDO

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
NA NC ND NE NG NH NI NJ NK NN NO NS NT NU NW NY NZ
NDA NDE NDI NDL NDO NDR NDU

Full Surname List Starting with NDO(Alphabetical)

NDOW
NDOYE

Top 100 Surnames in the 2010 US Census starting with NDO

SurnameCountRankWiki?
NDOYE 313 63698 no
NDOW 109 150452 no