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 = 'SP' order by rank asc limit 0,100 Surnames > S > SP > SPY

Surnames > S > SP > SPY

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
SA SB SC SD SE SF SG SH SI SJ SK SL SM SN SO SP SQ SR ST SU SV SW SY SZ
SPA SPE SPH SPI SPJ SPL SPO SPR SPU SPY

Full Surname List Starting with SPY(Alphabetical)

SPYCHALA
SPYCHALLA
SPYCHALSKI
SPYKE
SPYKER
SPYKERMAN
SPYRES
SPYRKA
SPYROPOULOS

Top 100 Surnames in the 2010 US Census starting with SPY

SurnameCountRankWiki?
SPYCHALSKI 539 40554 no
SPYKER 435 48530 no
SPYROPOULOS 272 71678 no
SPYCHALLA 227 82908 no
SPYCHALA 204 90495 no
SPYRES 165 107669 no
SPYKERMAN 131 129825 no
SPYKE 125 134712 no
SPYRKA 118 141140 no