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

208 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
gladden1037631(None) 
gladded11357451gladded
gladdens11364461gladdens
gladder10398311gladder
bladder11429152bladder
cladded12356922cladded
gadded103913172g_added
gadder93714712g_adder
garden84215082g_arden
gladdened1342582gladdened
gladdener1252402gladdener
gladdest11145842gladdest
gladding1236302gladding
glade75121962gla_de_
glades84820342gla_des
gladier93810992gladier
glandes95413832glandes
ladder84617622_ladder
laden65022192_la_den
madden103912522_madden
sadden83212402_sadden
slidden935152slidden
added84918433__added
addend9458453__addend
adder75419593__adder
admen84516183__admen
badder103817513_badder
badmen114613833_badmen
beadmen12299453beadmen
begladded1542863begladded
bemadden1443113bemadden
bidden104010793_bidden
blacken15439793blacken
bladders12397803bladders
bladdery15344583bladdery
blade85923333bla_de_
bladed104717763bla_ded
blader93618583bla_der
blades95221253bla_des
blander103715163blander
bradded12388713bradded
chidden14255223chidden
cladding1337143cladding
clade85821013cla_de_
clades94920463cla_des
cladode1134613cladode_
cladodes1245323cladodes
deaden83714323dea_den
deadmen11248573deadmen
flagmen13226913flagmen
flamen115215993fla_men
flanken14226763flanken
flatten10429653flatten
flaxen16518573fla_xen
gadders103611503g_adders
gaddi85211633g_add_i
gadding113411453g_adding
gaddis94211373g_addis
gadget93616183g_adget
gadje1457743g_adje_
gaen57329603g_a__en
gagmen103910413g_agmen
gander84322763g_ander
gardens93312093g_ardens
gasmen93111563g_asmen
glace87420153gla_ce_
glaceed1136193glaceed
glaces94218023gla_ces
glacier103911293glacier
glad65624013gla_d__
gladdeners1352063gladdeners
gladdening1442693gladdening
gladiest101710333gladiest
gladlier1034343gladlier
gladly11497933gla_dly
gladness1036153gladness
glads75620613gla_d_s
glady105413943gla_d_y
glaiket1238363glaiket
glaire74411293glaire_
glaired9387743glaired
glaires84010133glaires
glaive10357933glaive_
glaived12375973glaived
glaives11347833glaives
glance94312313glance_
glanced11439233glanced
glancer103710073glancer
glances104113143glances
gland75217713gland__
glanders103811503glanders
glands85314403gland_s
glare65222953gla_re_
glared84715193gla_red
glares75518863gla_res
glarier84112203glarier
glassed93710433glassed
glasses84414273glasses
glassmen1145393glassmen
glaze155418163gla_ze_
glazed174711773gla_zed
glazer164212263gla_zer
glazes165315643gla_zes
glazier17409353glazier
glede75517833gl_ede_
gledes84915133gl_edes
gleemen1035723gleemen
glen56027203gl___en
gliadin935593gliadin
gliadine1045403gliadine
glide74521593gl_ide_
glided94513903gl_ided
glider84614263gl_ider
glides84518863gl_ides
glisten8418083glisten
gluten74210753gl_uten
goaded94913713goa_ded
godded104811803g_odded
golden84411153g_olden
goodmen1135623goodmen
graben9419723gra_ben
grade75126093gra_de_
graded94919553gra_ded
grader84919693gra_der
grades84926313gra_des
gradient10310373gradient
gradin83517483gra_din
gradine93317033gradine
grandee93115513grandee
grander93315873grander
graven104513523gra_ven
gridded11387583gridded
gridder10367763gridder
guarded1036153guarded
guarder936463guarder
gulden8328763g_ulden
harden105718533_harden
headmen13259513headmen
hidden11429743_hidden
hodden113811453_hodden
ladders94115173_ladders
laddie83713173_laddie
laddies93715053_laddies
lade56345983_la_de_
laded74232613_la_ded
ladens74516233_la_dens
lader65633723_la_der
lades65141273_la_des
ladies75124883_ladies
ladle66320443_ladle_
ladled85013483_ladled
ladler74314933_ladler
ladles74619543_ladles
ladron73413323_ladron
landed84619243_landed
lander74028483_lander
landmen1038553_landmen
larded84319093_larded
larder73720973_larder
lardon74415063_lardon
lateen64014863_lateen
laten54328343_la_ten
latten65018203_latten
lauded83812153_lauded
lauder73815013_lauder
lawmen11308593_lawmen
laymen113010843_laymen
leaden74515223_leaden
leadmen10277903leadmen
lidded93410243_lidded
linden7411453_linden
loden66621143_l_oden
louden73711793_louden
madded113513553_madded
maddens11359753_maddens
madder103515593_madder
madmen113511743_madmen
maiden93512283_maiden
midden104112853_midden
olden65114853ol__den
padded114113503_padded
padder103415493_padder
plaided11409643plaided
platen84518203pla_ten
playpen1434693playpen
plodded1265563plodded
plodder1146003plodder
quadded1934863quadded
radded94716493_radded
readded103310733readded
redden83613623_redden
ridden83511723_ridden
saddens9309603_saddens
sadder82916973_sadder
shodden12265763shodden
slacken13399933slacken
slander84015443slander
sledded10378873sledded
sledder9399203sledder
sodden84011513_sodden
sudden83310833_sudden
swidden1234233swidden
trodden934883trodden
unadded10238523unadded
unladen8248653unla_den
wadded124014173_wadded
wadder114215483_wadder
warden104515513_warden

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272086.57620381.2
3Display Results2082080.0633301.6
 (SQL Overall)1786912087.04525364.2
 
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.