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

124 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
gladdens1136446(None) 
gladden10376311gladden_
bladders12397802bladders
gadders103611502g_adders
gardens93312092g_ardens
gladded11357452gladde_d
gladdened1342582gladdened
gladdener1252402gladdener
gladdeners1352062gladdeners
gladder10398312gladde_r
gladdest11145842gladdest
gladding1236302gladding
glades84820342gla_de_s
gladness1036152gladness
glanders103811502glanders
glandes95413832glande_s
ladders94115172_ladders
ladens74516232_la_dens
maddens11359752_maddens
saddens9309602_saddens
addend9458453__addend
addends10356053__addends
adders84315703__adders
bemaddens1542103bemaddens
blackens16388103blackens
bladder11429153bladde_r
bladdery15344583bladdery
bladers104214683bla_ders
blades95221253bla_de_s
cladded12356923cladde_d
cladding1337143cladding
claddings1433213claddings
clades94920463cla_de_s
cladodes1245323cladode_s
deadens93410693dea_dens
flamens124611063fla_mens
flattens11357483flattens
gadded103913173g_adde_d
gadder93714713g_adde_r
gadding113411453g_adding
gaddis94211373g_add_is
gadgets10348683g_adgets
ganders93521703g_anders
garden84215083g_arden_
glaces94218023gla_ce_s
glaciers11277893glaciers
gladdening1442693gladdening
glade75121963gla_de__
gladier93810993gladie_r
gladiest101710333gladiest
glads75620613gla_d__s
glaires84010133glaire_s
glaives11347833glaive_s
glancers11408003glancers
glances104113143glance_s
glandless1134163glandless
glands85314403gland__s
glans65125833gla___ns
glares75518863gla_re_s
glasses84414273glasse_s
glazers174410033gla_zers
glazes165315643gla_ze_s
glaziers18406563glaziers
gledes84915133gl_ede_s
glens66519853gl___ens
gliadines1144773gliadines
gliadins1035193gliadins
gliders94811843gl_iders
glides84518863gl_ide_s
glistens9366593glistens
glutens8437593gl_utens
goddess1035263g_oddess
grabens10367003gra_bens
graders94715993gra_ders
grades84926313gra_de_s
gradient10310373gradient
gradients1145273gradients
gradines103615253gradines
gradins93416233gra_dins
grandees103211283grandees
gridders11286293gridders
guarders1035873guarders
guldens9356573g_uldens
hardens113815023_hardens
hoddens12378803_hoddens
ladder84617623_ladde_r
laddies93715053_laddies
laden65022193_la_den_
laders74927763_la_ders
lades65141273_la_de_s
ladies75124883_ladie_s
ladlers84613563_ladlers
ladles74619543_ladle_s
ladrons83813193_ladrons
landers84026213_landers
larders83516943_larders
lardons83914493_lardons
lateens74210553_lateens
latens64620213_la_tens
lattens75014673_lattens
lauders84012893_lauders
leadens83610983_leadens
lindens839413_lindens
lodens74315063_l_odens
loudens8368053_loudens
madden103912523_madden_
madders113513213_madders
maidens10349663_maidens
middens11379373_middens
padders113312873_padders
platens94213983pla_tens
playpens1534073playpens
plodders1235523plodders
reddens9259783_reddens
sadden83212403_sadden_
slackens14367713slackens
slanders94014013slanders
sledders10257373sledders
slidden935153slidden_
soddens9348413_soddens
suddens9308783_suddens
swiddens1342713swiddens
wadders123812443_wadders
wardens113711903_wardens

Search took 10 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.263679433.5
2DLD Change Limit1461621248.84616522.9
3Display Results1241240.0462695.7
 (SQL Overall)1786911249.15519518.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.