Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “snappers” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

381 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
snappers12351017(None) 
knappers16315641knappers
nappers114214861_nappers
sappers113518901s_appers
slappers123710951slappers
snapper113512071snapper_
snippers12299721snippers
swappers15358081swappers
cappers134419402_cappers
clappers143310832clappers
crappers144011022crappers
flappers15388382flappers
knapper15387152knapper_
lappers113717462_lappers
mappers133313782_mappers
napper103718282_napper_
nappes104515622_nappe_s
nippers113012622_nippers
rappers113618442_rappers
sapper103822352s_apper_
scalpers123710862scalpers
scampers143611032scampers
scarpers124712512scarpers
scaupers12378172scaupers
schnappers1942142schnappers
scrappers1545862scrappers
scuppers1446542scuppers
shapers124016892sha_pers
sharpers133810942sharpers
shippers153012312shippers
shoppers153010762shoppers
sippers113117752s_ippers
skippers16318202skippers
slapper113512472slapper_
slippers123711232slippers
snackers143010222snackers
snapless10287462snapless
snapped124611202snappe_d
snappier1266222snappier_
snarers74216662sna_rers
snarlers8298752snarlers
snipers93311772sn_ipers
snipper113911332snipper_
snippets12225622snippets
snoopers10319842snoopers
soapers93715922soa_pers
stampers124211602stampers
staplers103111202staplers
steppers12289282steppers
stoppers123910592stoppers
strappers1346742strappers
suppers113314702s_uppers
swampers15317472swampers
swapper14359702swapper_
tappers113416542_tappers
trappers123711042trappers
whappers18276742whappers
wrappers15306932wrappers
yappers144012252_yappers
zappers203911632_zappers
adapters1136103adapters
anaphors1346633anaphors
apers76629133__a_pers
appears11308953__appears
appels104312793__appels
aspers86220313__aspers
boppers133911923_boppers
campers134220293_campers
capers105428143_ca_pers
capper124421983_capper_
carpers114521253_carpers
catnappers1682763catnappers
champers173311623champers
chapters154012133chapters
chippers173510883chippers
choppers174110463choppers
clampers143211893clampers
clapper134011863clapper_
claspers124410913claspers
clippers14368843clippers
coappears1542953coappears
coppers133519753_coppers
crapper133913193crapper_
croppers143311483croppers
cruppers14317323cruppers
cuppers133712213_cuppers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713913dia_pers
didappers1543173didappers
dippers123615183_dippers
dognappers1642053dognappers
drapers105313353dra_pers
drippers13327943drippers
droppers13318603droppers
enablers10196913enablers
endpapers1443643endpapers
entrappers1444183entrappers
escapers12337413esca_pers
flapper14359203flapper_
flippers15338003flippers
floppers15337463floppers
frappes14328383frappe_s
gapers94520473_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
gippers123212083_gippers
gnawers11356393gna_wers
grapplers14274303grapplers
graspers11338403graspers
grippers13358133grippers
gunpapers1442423gunpapers
gyppers15235503_gyppers
hampers143616953_hampers
hanapers1346963hanapers
happens14359173_happens
harpers124916203_harpers
heapers123616673hea_pers
hoppers143115143_hoppers
japers154616173_ja_pers
jaspers164310463_jaspers
kidnappers1951823kidnappers
kippers153211433_kippers
knackers13286843knackers
knapped16397103knappe_d
lampers113817333_lampers
lapper104319953_lapper_
lappets11329133_lappets
lapsers93911053_lapsers
leapers93716663lea_pers
lippers113416443_lippers
loppers113014103_loppers
mapper124516093_mapper_
moppers133412463_moppers
nabbers113710463_nabbers
naggers93812653_naggers
nailers73215893_nailers
namers84517333_na_mers
napery11489813_na_pery
napes74828463_na_pe_s
napless93110283_napless
nappas105511613_napp_as
nappe96114993_nappe__
napped114218163_nappe_d
nappier114411173_nappier_
nappies114613403_nappies
natters73718063_natters
nipper103715713_nipper_
onagers838103ona_gers
pampers133615933_pampers
papers105125323_pa_pers
paupers114311073_paupers
peppers103311443_peppers
petnappers1342433petnappers
poppers103414863_poppers
quippers2184813quippers
rapers84327183_ra_pers
rapiers95012873_rapiers
rappees113611453_rappees
rappels11448803_rappels
rapper104621573_rapper_
raspers94415923_raspers
reapers93520453rea_pers
reappears1342853reappears
repapers1258833repapers
rippers114115033_rippers
sabers85224733s_a_bers
sackers133820223s_ackers
saggers94017083s_aggers
sailers73822323s_ailers
sakers104125433s_a_kers
salters73622253s_alters
salvers103916003s_alvers
samplers12299403samplers
sanders84025943s_anders
sandpapers15113713sandpapers
sandpipers1592853sandpipers
sangers84421943s_angers
sapiens9310173s_apiens
sapless93313443s_apless
sapors84118813s_a_pors
sapours93610623s_apours
sapped114422013s_appe_d
sappier113613123s_appier_
saucers93712133s_aucers
saugers83914053s_augers
savers93825923s_a_vers
sawers94620163s_a_wers
sawyers13317533s_awyers
sayers94221593s_a_yers
scalers93817263sca_lers
scalpels12345883scalpels
scalper113912923scalper_
scammers14339773scammers
scamper134613163scamper_
scanners10379703scanners
scapes105122263sca_pe_s
scarers94618513sca_rers
scarfers13408463scarfers
scarper114814823scarper_
scatters103612753scatters
scauper11379453scauper_
scepters1237793scepters
schappes1736043schappe_s
schnapper1842473schnapper_
scoopers124210193scoopers
scrapers125510533scrapers
scrapper1466973scrapper_
scupper1367423scupper_
sealers74323553sea_lers
seamers94719433sea_mers
seaters74028943sea_ters
shaders115915553sha_ders
shakers144015563sha_kers
shammers153710843shammers
shaper114119933sha_per_
shapes115124953sha_pe_s
sharers104720623sha_rers
sharkers154011053sharkers
sharpens13377813sharpens
sharper124312703sharper_
shatters113313913shatters
shavers134115093sha_vers
shippens15316803shippens
shipper143514043shipper_
shnapps1463343shnapp__s
shopper143312633shopper_
shoppes143411403shoppe_s
simpers113014123s_impers
sipper103920993s_ipper_
sippets113310183s_ippets
skankers11316483skankers
skaters113512963ska_ters
skipper15339573skipper_
skippets16284563skippets
slabbers123610123slabbers
slackers143812743slackers
slakers114115753sla_kers
slammers123511223slammers
slanders94014013slanders
slapped123511853slappe_d
slashers113313613slashers
slaters73123733sla_ters
slathers113914783slathers
slavers103716503sla_vers
slayers104513323sla_yers
sleepers103110113sleepers
slipper113712983slipper_
slippery15275863slippery
slopers94213093s_lopers
smackers16318713smackers
smashers13339593smashers
smatters104011713smatters
snacker133112603snacker_
snakes103919603sna_ke_s
snakier112810003snakier_
snappiest1346503snappiest
snappily1544323snappily
snappiness1443833snappiness
snapping13349653snapping
snappish1545243snappish
snappy1366103snapp__y
snaps74719563sna_p__s
snapweed1443453snapweed
snapweeds1542283snapweeds
snarer64620843sna_rer_
snares65329033sna_re_s
snarler73610633snarler_
snashes105214753snashe_s
snatchers14146313snatchers
snathes104816493snathe_s
sneakers12308643sneakers
sneerers8309803sneerers
sneers64016173sn__eers
sneezers17246143sneezers
snickers143010963snickers
sniffers14257123sniffers
snifters11318613snifters
sniggers10317093sniggers
sniper84413643sn_iper_
snipes83917393sn_ipe_s
snipped123510043snippe_d
snippet113310433snippe_t
snippety15263493snippety
snippier1255793snippier_
snookers12398653snookers
snooper93511533snooper_
snoozers17296943snoozers
snorers74313803sn_orers
snorters83410583snorters
snubbers12326673snubbers
snuffers14326923snuffers
soakers114114953soa_kers
soaper84517873soa_per_
soapier93411713soapier_
soapless10278073soapless
soarers74118093soa_rers
spacers113813873spa_cers
spaders104214473spa_ders
spallers102910733spallers
spammers14378693spammers
spankers14369863spankers
spanners103710773spanners
sparers94519613spa_rers
spargers11389733spargers
sparkers144111313sparkers
spatters103914703spatters
spawners13396493spawners
speers85019953s__peers
spiers84421743s__piers
stabbers12268733stabbers
stablers103611153stablers
stackers143413563stackers
staffers14247083staffers
stagers84116673sta_gers
staggers10379843staggers
stainers83212173stainers
stalkers12369853stalkers
stammers123611523stammers
stamper113714403stamper_
standers93514303standers
stapes85028733sta_pe_s
stapler93913633stapler_
staples93617213staple_s
starers74522313sta_rers
starkers123712393starkers
starters83714773starters
starvers11459643starvers
staters73922343sta_ters
stayers103813633sta_yers
steepers103011373steepers
stepper113010853stepper_
steppes113110693steppe_s
stipplers1334453stipplers
stompers123610043stompers
stoopers103711303stoopers
stopers94217373s_topers
stopper113012603stopper_
strapper1258093strapper_
stripers103911593stripers
strippers1355773strippers
stroppers1356713stroppers
stumpers12318313stumpers
sumpters1238023sumpters
supers84622403s__upers
supper104115433s_upper_
swabbers15316743swabbers
swagers114211023swa_gers
swaggers13407223swaggers
swamper14349313swamper_
swapped15429143swappe_d
swarmers1346323swarmers
swashers14389533swashers
swathers144512083swathers
swatters113911793swatters
swayers13398853swa_yers
sweepers13348163sweepers
swoopers13317523swoopers
synapses1344713synapse_s
syphers15317273s_yphers
tampers113516743_tampers
tapers84025813_ta_pers
tapper104419613_tapper_
tappets113610013_tappets
tippers113414353_tippers
toppers113914603_toppers
trampers123210393trampers
trapper113912803trapper_
trippers123210163trippers
uppers102912293__uppers
vampers143111623_vampers
warpers123413583_warpers
whapper17348273whapper_
whippers18329043whippers
whoppers18297533whoppers
wrapper14368333wrapper_
yapper133714513_yapper_
yaupers12337663_yaupers
yawpers15346853_yawpers
zapper193414023_zapper_
zippers203310383_zippers

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911461620.453394461.4
2DLD Change Limit1461623816.90621164.5
3Display Results3813810.1402721.4
 (SQL Overall)1786913817.49923828.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.