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

234 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
spreading133965(None) 
bespreading1743502bespreading
breading123515462_breading
dispreading1645912dispreading
dreading113712802_dreading
lipreading1444042lipreading
pleading123011442_pleading
prefading16149032_prefading
reading93327212__reading
rereading111212712rereading
respreading1545172respreading
screaking16228242screaking
screaming14217832screaming
screeding1336322screeding
serenading1246102serenading
shredding1544512shredding
spading113114382sp__ading
speaking153212492sp_eaking
speaning113512242sp_eaning
spearing113216102sp_earing
speeding122810932sp_eeding
spending122712432sp_ending
spraying14299882spr_aying
steading103613592s_teading
streaking142010322streaking
streaming12239652streaming
threading14107592threading
treading103515332_treading
uprearing1238372uprearing
abrading1239503abr_ading
appealing1446493appealing
appearing1436893appearing
appeasing1446343appeasing
appending1536283appending
arcading1239763_arcading
asperating1349563asperating
beading113221863__beading
beheading1636163beheading
bereaving1537573bereaving
breaking153914253_breaking
breaming133612513_breaming
breeding123411843_breeding
coheading1636623coheading
coleading1338523coleading
copyreading2052753copyreading
corrading1338203corrading
creaking153414123_creaking
creaming133413143_creaming
creasing113314443_creasing
creating113921953_creating
deleading1237773deleading
dreaming124011063_dreaming
estreating11710363estreating
freaking163611453_freaking
grading103918713_gr_ading
greasing102811393_greasing
heading122919113__heading
impleading1643763impleading
kneading1436373_kneading
leading93419553__leading
lipreadings1551883lipreadings
mispleading1744353mispleading
misreading1448263misreading
nonreading1246883nonreading
operating12313723operating
outreading1239283outreading
outspreading1652713outspreading
parading12313863_parading
peacing124117073_p_eacing
peaking144317693_p_eaking
pealing104123203_p_ealing
pending114119773_p_ending
pervading1636303pervading
phreaking1936473phreaking
pleadings13285543_pleadings
pleasing112611593_pleasing
pleating112916053_pleating
pomading1437423_pomading
prating103424453_pr_ating
praying133717323_pr_aying
preaching172811163_preaching
preacting142412533_preacting
prearming14139223_prearming
prebaking1838063_prebaking
preceding15129363_preceding
precoding15109733_precoding
predating13514653_predating
preeing103817673_pre_eing
preening113115843_preening
prefacing17118743_prefacing
preloading1446583_preloading
preluding1337053_preluding
preparing14311643_preparing
prepaving1787233_prepaving
prepaying1747973_prepaying
prepping12309763_prepping
presaging1339393_presaging
presiding13510903_presiding
pressing112516443_pressing
pretaping1439133_pretaping
prevuing1457253_prevuing
preying133114553_pre_ying
priding113317543_pr_iding
prodding13189343_prodding
readding11411363__readding
readings103512643__readings
readying13410223__readying
reaming103924013__reaming
reaping103621213__reaping
rearing83128783__rearing
reaving113820533__reaving
redding103218513__redding
reding83825563__re_ding
reeding94124133__reeding
rending93924263__rending
repleading1436623repleading
rereadings12124543rereadings
retreading12128483retreading
scending122610583s_cending
scraping133310863scr_aping
screening1247193screening
screwing14288233scre_wing
sealing83528563s__ealing
seaming103222113s__eaming
searing83330923s__earing
seating84130683s__eating
seceding12288563sece_ding
seeding93719483s__eeding
sending94221373s__ending
seriating10916403seriating
serrating10513203serrating
shading123115563s__hading
sheafing15329483s_heafing
shealing123415463s_healing
shearing123915903s_hearing
sheaving154110253s_heaving
shedding14278113s_hedding
shending132511253s_hending
shielding1434553shielding
shrewing15228093shre_wing
shrouding1434753shrouding
sleaving123310983s_leaving
sledding11248503s_ledding
smearing113511753s_mearing
sneaking133211093s_neaking
sneaping11349493s_neaping
snedding11246953s_nedding
spacing123614493sp__acing
spaeing103413543sp__aeing
sparing104823873sp__aring
spaying133014623sp__aying
speakings16345933sp_eakings
spearheading1951863spearheading
speccing15306643sp_eccing
specking17359733sp_ecking
speedings13265403sp_eedings
speedreading1761733speedreading
speeling112713123sp_eeling
speering113116323sp_eering
speiling113612973sp_eiling
speiring113711263sp_eiring
spelling113315233sp_elling
spewing133110453sp_e_wing
sphering142811943sphe_ring
spieling113212523spie_ling
spiering112713353spie_ring
spiraling1237953spiraling
splaying14219303sp_laying
spraddling1542313spraddling
sprain83614863spr_a_in_
spraining1248153spraining
sprains93013593spr_a_ins
sprang95713523spr_a__ng
sprawling15175123sprawling
spread9312533spread___
spreader1137483spread_er
spreaders1236503spreaders
spreads1039763spread__s
sprigging1435893sprigging
spring94526013spr___ing
springing1338743springing
sprinting12310033sprinting
spritzing2135393spritzing
sprouting1236943sprouting
sprucing1336893spr_ucing
spudding1335653sp_udding
squeaking2334213squeaking
squealing1935153squealing
steadings11307083s_teadings
steadying14154503s_teadying
stealing93416603s_tealing
steaming114013213s_teaming
strafing122111193str_afing
stranding1149653stranding
strawing122411623str_awing
straying122912693str_aying
streakings15235303streakings
streamings13185163streamings
streeking14217453streeking
streeling10189483streeling
stressing1038333stressing
strewing12289853stre_wing
striating10914193striating
striding102713603str_iding
strouding1136373strouding
subheading1743793subheading
sueding92613753s_ue_ding
superadding1644393superadding
surceasing1345073surceasing
surfacing1545643surfacing
surnaming1245143surnaming
surtaxing1784143surtaxing
swearing123711443s_wearing
sweating123213023s_weating
threaping15106113threaping
threating131010053threating
trading93517973_tr_ading
treadling1137503_treadling
treating92519613_treating
trending103012833_trending
unleading1138673unleading
untreading1247563untreading
upbearing1435033upbearing
upending12258133up_ending
upgrading1444903upgrading
upheaping1743853upheaping
upheaving1843803upheaving
upleaping1434363upleaping
uploading1334663uploading
uprating11311113upr_ating
upreaching1844113upreaching
upsending1334903upsending
uptearing1236103uptearing
wreaking163010213_wreaking

Search took 7 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 Filter1786911486410.436409841.7
2DLD Change Limit1486412346.36023371.2
3Display Results2342340.1102127.3
 (SQL Overall)1786912346.90625874.7
 
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.