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 > SPL

Surnames > S > SP > SPL

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 SPL(Alphabetical)

SPLAIN
SPLAINE
SPLAN
SPLANE
SPLAWN
SPLETT
SPLETTER
SPLETZER
SPLICHAL
SPLIETHOF
SPLINTER
SPLITSTONE
SPLITT
SPLITTER
SPLITTGERBER
SPLITTSTOESSER
SPLONSKOWSKI
SPLUNGE

Top 100 Surnames in the 2010 US Census starting with SPL

SurnameCountRankWiki?
SPLAWN 1226 21360 no
SPLINTER 651 34707 no
SPLAIN 469 45569 no
SPLITT 415 50362 no
SPLAINE 377 54637 no
SPLICHAL 365 56073 no
SPLAN 354 57516 no
SPLITTGERBER 261 74141 no
SPLANE 256 75317 no
SPLETZER 207 89403 no
SPLETT 181 99845 no
SPLITTSTOESSER 152 115034 no
SPLITTER 144 120187 no
SPLONSKOWSKI 137 125282 no
SPLUNGE 127 133048 no
SPLIETHOF 125 134712 no
SPLETTER 120 139228 no
SPLITSTONE 119 140157 no