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 “spamming” 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.

378 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
spamming1531760(None) 
scamming15328541scamming
shamming16289411shamming
slamming133310001slamming
spasming13227201spasming
bamming144611812_bamming
clamming15329372clamming
cramming15339432cramming
damming133812742_damming
dramming14347562dramming
flamming16357152flamming
gamming133112622_gamming
hamming153014092_hamming
jamming19329792_jamming
lamming123014582_lamming
palming123914012_palming
psalming1375472psalming
ramming123115062_ramming
scamping153510192scamping
scramming1634882scramming
scumming15256792scumming
seaming103222112sea_ming
shaming133016742sha_ming
shammying2042952shammying
shimming16278252shimming
skimming17286272skimming
slammings14234122slammings
slimming13288092slimming
slumming13278382slumming
spacing123614492spa_cing
spading113114382spa_ding
spaeing103413542spa_eing
spalling113213462spalling
spanking153911972spanking
spanning113311082spanning
sparging122611132sparging
sparing104823872spa_ring
sparking152812542sparking
sparling112714532sparling
sparring113112222sparring
spatting113111762spatting
spawning14296912spawning
spaying133014622spa_ying
spuming1248522sp_uming
stamping133310962stamping
stemming13408202stemming
stumming13347672stumming
summing122912382s_umming
swamping16307922swamping
swarming1458222swarming
swimming16316322swimming
tramming13279342tramming
whamming19275222whamming
aiming94320843__aiming
alarming1138583alarming
ammine10314493__ammine
ammino1069883__ammino
amping114317573__amping
arming94719803__arming
beaming123618803bea_ming
blaming123515693bla_ming
brimming15196623brimming
bumming143410783_bumming
calming123915973_calming
camping143118973_camping
chammying2243353chammying
champing183610933champing
charming163012033charming
chumming18366203chumming
claiming13279303claiming
clamping154011153clamping
coaming123818323coa_ming
cramping153411853cramping
damning114211633_damning
damping133414003_damping
dimming13339593_dimming
drumming14265783drumming
faming124922973_fa_ming
farming133515083_farming
flaming134216443fla_ming
foaming133612993foa_ming
framing133014793fra_ming
gaming104622043_ga_ming
gauming11319713_gauming
gemming13289153_gemming
glomming14275923glomming
gumming133810193_gumming
harming133717933_harming
hemming15269973_hemming
humming153310673_humming
inarming1138343inarming
jambing19328533_jambing
lambing123412413_lambing
laming94528363_la_ming
lamping123116003_lamping
lemming12269393_lemming
loaming103613733loa_ming
maiming122912723_maiming
mumming114010023_mumming
naming93917893_na_ming
napalming1443173napalming
nimming12358143_nimming
opaquing2042313opaquing
pacing114522753_pa_cing
packing164420723_packing
padding123412513_padding
paging104020403_pa_ging
paiking143814813_paiking
paining103920243_paining
pairing103716733_pairing
paling93530133_pa_ling
palling104024483_palling
palping124112873_palping
panging113319113_panging
panning104019393_panning
panting104025423_panting
parging113318603_parging
paring94236493_pa_ring
parking143423043_parking
parling103823763_parling
parring103222063_parring
parsing103819553_parsing
parting103527383_parting
pashing135120513_pashing
passing104318423_passing
pasting103826553_pasting
patting103722343_patting
pausing103912813_pausing
paving124519743_pa_ving
pawing124519553_pa_wing
pawning134711413_pawning
paying123722163_pa_ying
perming123416093_perming
pharming16248143pharming
pimping143812123_pimping
pluming123412043_pluming
priming123417373_priming
primming15268173primming
psammite1442983psammite
psammon1342543psammon_
psammons1442783psammons
pumping144213553_pumping
ramping123316873_ramping
reaming103924013rea_ming
rearming111413613rearming
rimming123411073_rimming
roaming103215793roa_ming
sabbing123314743s_abbing
sabeing102611863s_abeing
sabring102614843s_abring
sacking144122703s_acking
sacring103115983s_acring
sagging103116103s_agging
sailing83927373s_ailing
saimin8313663s_aimin_
saimins9312113s_aimins
saining83621393s_aining
salaaming1265363salaaming
salting84120793s_alting
salving113913153s_alving
sambaing1337113s_ambaing
sampling13510643s_ampling
sanding93520603s_anding
saning75127643s_a_ning
sapling103217863s_apling
sapping123519313s_apping
sashing114621473s_ashing
sassing84615553s_assing
sating74735453s_a_ting
saucing10311003s_aucing
saving104724513s_a_ving
sawing104323813s_a_wing
saying104325543s_a_ying
scabbing15277193scabbing
scalding12339393scalding
scaling103519373sca_ling
scalping133410453scalping
scammony1743023scammony
scanning113310773scanning
scanting113914763scanting
scaping123715693sca_ping
scarfing14309713scarfing
scaring103421973sca_ring
scarping133312463scarping
scarring112511513scarring
scarting113415263scarting
scathing14269703scathing
scatting113311813scatting
scheming1636633scheming
scrumming1654023scrumming
seagoing1038193seagoing
sealing83528563sea_ling
searing83330923sea_ring
seating84130683sea_ting
seeming103216263s_eeming
shacking184014083shacking
shading123115563sha_ding
shafting15278683shafting
shagging14349053shagging
shaking153317253sha_king
shambling1735593shambling
shammied16265543shammied
shammies15259683shammies
shamoying1844523shamoying
shanking163612283shanking
shaping133116183sha_ping
sharing113723243sha_ring
sharking163912973sharking
sharping143011373sharping
shauling1249393shauling
shaving143414333sha_ving
shawing143514883sha_wing
shawling1558223shawling
shimmying2042533shimmying
siamang1045333sia_mang
skanking12288743skanking
skating123613853ska_ting
skimmings18243263skimmings
skimping17306243skimping
slabbing13287783slabbing
slacking153914133slacking
slagging113711573slagging
slaking123717473sla_king
slaloming1244743slaloming
slanging103413433slanging
slanting94115093slanting
slapping133510833slapping
slashing123713413slashing
slating83724653sla_ting
slatting94014233slatting
slaving113514833sla_ving
slaying113316843sla_ying
sliming102913953s_liming
slumping13359973slumping
smacking173510763smacking
smarting113212453smarting
smashing143310243smashing
snacking153411703snacking
snafuing1235083snafuing
snagging11319373snagging
snailing92912973snailing
snaking123915303sna_king
snapping13349653snapping
snarfing12358663snarfing
snaring83920953sna_ring
snarling92513183snarling
snawing113612483sna_wing
soaking123116613soa_king
soaping103616223soa_ping
soaring83521893soa_ring
spacings13287043spa_cings
spackling18266503spackling
spaeings11276253spa_eings
spammed14348523spamm_ed
spammer133410433spamm_er
spammers14378693spammers
spang84919733spa___ng
spangling1336373spangling
spankings16215003spankings
sparkling16226353sparkling
sparlings12257153sparlings
spartina1037983spartina
spavin114210653spa_vin_
spavins12419323spa_vins
speaking153212493speaking
speaning113512243speaning
spearing113216103spearing
spearmint1365983spearmint
speccing15306643speccing
specking17359733specking
speeding122810933speeding
speeling112713123speeling
speering113116323speering
speiling113612973speiling
speiring113711263speiring
spelling113315233spelling
spending122712433spending
spermine12311433spermine
spewing133110453sp_ewing
sphering142811943sphering
spicing123914533sp_icing
spieling113212523spieling
spiering112713353spiering
spiffing17237083spiffing
spiking144312883sp_iking
spiling102919703sp_iling
spilling113113943spilling
spinning113310813spinning
spiring103918183sp_iring
spirting112913633spirting
spiting103917623sp_iting
spitting113012323spitting
splashing1535703splashing
splatting1235983splatting
splaying14219303splaying
splicing1338963splicing
splining11310773splining
spoiling112911553spoiling
spoking143212223sp_oking
sponging1238823sponging
spoofing14228363spoofing
spooking15269803spooking
spooling113212563spooling
spooning112811443spooning
spooring113111463spooring
sporing104319413sp_oring
sporting112415463sporting
spotting112812093spotting
spousing11198733spousing
spouting113511953spouting
spraining1248153spraining
sprawling15175123sprawling
spraying14299883spraying
spring94526013sp__ring
sprucing1336893sprucing
spudding1335653spudding
spuing94313363sp__uing
spunking15258063spunking
spurning11258663spurning
spurring11339763spurring
spurting113111633spurting
spying123913253sp__ying
stabbing13238763stabbing
stabling112913653stabling
stacking154215083stacking
staffing15247493staffing
stagging113310513stagging
staging93818373sta_ging
staining9413373staining
staking123919803sta_king
staling83925423sta_ling
stalking133512223stalking
stalling95116703stalling
stamina9310793sta_mina
stammering1544523stammering
standing103413633standing
stanging104013653stanging
staning83922243sta_ning
stapling112813153stapling
staring84527053sta_ring
starling93017123starling
starring92312953starring
starting93116173starting
starving122510173starving
stashing123511583stashing
stating83725163sta_ting
staving113915703sta_ving
staying114017323sta_ying
steaming114013213steaming
stimying1437503stimying
stomping13309763stomping
storming11209423storming
strumming1454413strumming
stumping13289083stumping
stymying1733963stymying
swabbing16246453swabbing
swagging14328093swagging
swaging124210633swa_ging
swanking16399963swanking
swanning12338813swanning
swapping16348673swapping
swarding1359003swarding
swashing15369743swashing
swathing15248713swathing
swatting12309593swatting
swaying143610643swa_ying
swimmings17263153swimmings
taming94023433_ta_ming
tamping122815813_tamping
teaming103917593tea_ming
tomming12359243_tomming
tramping132711273tramping
trimming13318653trimming
unarming1138623unarming
unjamming2143043unjamming
upcoming1535173upcoming
vamping152810233_vamping
warming133515083_warming

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.406440125.6
2DLD Change Limit1461623786.53022383.2
3Display Results3783780.1562423.1
 (SQL Overall)1786913787.09225196.1
 
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.