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

295 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
ladening107883(None) 
latening9711501latening
leadening1176731leadening
adenine8311212_adenine
aliening91510902aliening
cadencing1544972cadencing
davening13258882davening
deadening1277582deadening
gardening1236512gardening
gladdening1442692gladdening
hardening1438022hardening
havening15258562havening
labeling11311652labeling
lacewing1435842lacewing
laddering1237592laddering
lading84227122lad__ing
ladling92813392lad_ling
lagering102212312lagering
lamenting1237702lamenting
layering122310352layering
leavening1365972leavening
likening13246902likening
livening12248162livening
loudening1144752loudening
maddening1445112maddening
ravening122611302ravening
saddening1245212saddening
wakening1636332wakening
widening13237842widening
adding93914963_ad_ding
addling10229833_addling
adeeming1254793_adeeming
adenines9310193_adenines
adhering1338883_adhering
adoring9412523_adoring
adorning1087323_adorning
adzing174110013_ad_zing
ageing84213403_age_ing
agenting1039383_agenting
aligning10158533aligning
alining81917043_alining
alleging1038473alleging
altering91917123altering
amending12308913_amending
aneling82719503_aneling
atoning83514873_atoning
avenging1345863_avenging
awakening1743203awakening
aweing103911253_awe_ing
awning105013393_a_wning
badgering1436973badgering
badging123712793bad_ging
baning95127833ba__ning
banning103818233ba_nning
barning104320353ba_rning
battening12268863battening
bedewing1537143bedewing
blackening1944793blackening
blading113615363blad__ing
blazoning2144033blazoning
brazening2185193brazening
broadening1444033broadening
burdening1335543burdening
cabining1338653cabining
caddying16225063caddying
cadging123610973cad_ging
cageling12310853cageling
cameoing1379073cameoing
caning94128633ca__ning
canning103620143ca_nning
capering132414973capering
careening12310023careening
catering112019923catering
caverning1536293caverning
cladding1337143clad_ding
clavering1538373clavering
cozening20188333cozening
cravening1547563cravening
daddling12258233daddling
dadoing1038523dad_oing
damning114211633da_mning
dampening1535463dampening
dandering122511063dandering
darkening1535683darkening
darning93817333da_rning
dawning124111013da_wning
deadenings1393323deadenings
deafening1476273deafening
deaning94020473__deaning
deking125614553__deking
denning93515173__denning
denting94422183__denting
denying123711293__denying
dewing114115703__dewing
diademing1454323diademing
dining84525133__dining
dizening19177163dizening
dovening13238373dovening
dozening19236213dozening
earning83418213ea_rning
evening11310233_evening
faceting1438783faceting
fadein1068843fade_in_
fadeins1168503fade_ins
fadging134210243fad_ging
fading114821113fad__ing
fanning113615073fa_nning
fastening13268603fastening
fattening13287833fattening
fawning14409133fa_wning
fedexing2034493fedexing
flattening14115103flattening
gadding113411453gad_ding
gaeing84617223ga_e_ing
gaining94015663ga_ining
gandering122111293gandering
gaveling133410163gaveling
glaceing1236533glace_ing
gladding1236303glad_ding
greening103112543greening
hading113922943had__ing
haeing104118923ha_e_ing
happening1735593happening
hardenings1544243hardenings
harkening1746923harkening
hastening13259483hastening
havering152211053havering
hoidening1435643hoidening
hoydening1744363hoydening
indenting11911263indenting
indexing1737123indexing
jading154214023jad__ing
keening123713163_keening
laagering1136833laagering
labelling1238103labelling
laboring112110143laboring
lacewings1543303lacewings
lacing94626233la__cing
lackering1639383lackering
lackeying1934923lackeying
lacking143821543la_cking
laden65022193lade__n_
ladened979053laden_ed
ladens74516233lade__ns
ladings93814133lad__ings
ladino73615123lad__ino
ladykin1543963ladykin_
ladykins1643603ladykins
lagging103316743la_gging
lairing83715343la_iring
laking115027043la__king
lalling83519633la_lling
lambing123412413la_mbing
laming94528363la__ming
laminin939973laminin_
laminins1039133laminins
lamming123014583la_mming
lamping123116003la_mping
lancing103314123la_ncing
landing92819323la_nding
landowning1543153landowning
lappering14258843lappering
lapping124117023la_pping
lapsing103511163la_psing
lapwing13308263la_pwing
larding92917873la_rding
larking123718253la_rking
lashing114422893la_shing
lasing74727983la__sing
lassoing946383lassoing
lasting84725243la_sting
latching143712023latching
lathering13912253lathering
lathing114315693la_thing
lauding93211903la_uding
laughing1335933laughing
laundering1245183laundering
laureling1035643laureling
laveering1336813laveering
laving104623573la__ving
lawing104625283la__wing
lawyering1655213lawyering
layerings13235683layerings
laying104525703la__ying
lazing164821473la__zing
lazying2046673la_zying
leading93419553lead__ing
leaning83721203l_eaning
learning978553learning
leavenings1472583leavenings
leering83417643l_eering
lending94118533l__ending
lensing84015103l__ensing
lessening1045333lessening
leveeing12265963leveeing
leveling122910433leveling
levering122212503levering
libeling1139873libeling
licencing1443853licencing
licensing1244753licensing
lichening1545673lichening
lidding103611433lid_ding
limning103710323l_imning
lining74526803l__ining
lippening14234943lippening
listening10128953listening
livering122012383livering
loading94114613load__ing
loaning83614843l_oaning
lodging103110813lod_ging
loosening1044943loosening
lowering122210923lowering
lugeing9359113luge_ing
madding123711993mad_ding
manning103616383ma_nning
masoning1139763masoning
mildening1345673mildening
modeling12311083modeling
modeming1437113modeming
neatening1038353neatening
nidering10510483nidering
omening10310113_omening
opening1039943_opening
ordering1039353ordering
padding123412513pad_ding
paddling13218643paddling
paining103920243pa_ining
pandering133211963pandering
paneling111013633paneling
panning104019393pa_nning
papering132213313papering
pardoning1338763pardoning
parenting12611583parenting
patenting1248953patenting
patining11312303patining
pawning134711413pa_wning
peening103318313_peening
plaining113911553pla_ining
planing103418253pla__ning
planning113610223pla_nning
preening113115853preening
queening1846123queening
radding103715003rad_ding
raddling11229773raddling
radioing1039383radioing
raining83922693ra_ining
rattening10288763rattening
raveling123414373raveling
ravenings13235193ravenings
ravining12269693ravining
razeeing1834373razeeing
reddening1237433reddening
redenying1437783redenying
ripening1138583ripening
rodeoing1037263rodeoing
sabeing102611863sabe_ing
sabering112113743sabering
saddling11239593saddling
saining83621393sa_ining
saning75127643sa__ning
sardining1137573sardining
sheening123010813sheening
sideling101012183sideling
slackening1744343slackening
slandering1237243slandering
slavering1338723slavering
soddening1244553soddening
tabering112211423tabering
tanning83618253ta_nning
tapering112112503tapering
tautening1035843tautening
tokening1336483tokening
valeting1238853valeting
vanning113912463va_nning
wadding133711943wad_ding
waddling14237933waddling
waddying17204723waddying
wading114619533wad__ing
wafering15208893wafering
wagering13219523wagering
wagoning1336923wagoning
wakenings1743053wakenings
wandering143310983wandering
waning103623803wa__ning
wanning113816213wa_nning
warning113717093wa_rning
watering122316323watering
wavering152410543wavering
weakening1734843weakening
wedeling1338773wedeling
weening114113983_weening
wizening21255483wizening
yarning113512953ya_rning
yawning14378343ya_wning
yodeling1357683yodeling

Search took 9 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.440406115.9
2DLD Change Limit1461622957.62319173.8
3Display Results2952950.1262341.3
 (SQL Overall)1786912958.18921820.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.