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 “gladdest” 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
gladdest1114584(None) 
gladiest101710331gladiest
baddest112611142_baddest
blandest113811042blandest
gladded11357452gladde_d
gladden10376312gladde_n
gladdens11364462gladdens
gladder10398312gladde_r
glades84820342gla_des_
gladliest1135372gladliest
gladness1036152gladness
glandes95413832glandes_
glariest92012522glariest
glaziest18227912glaziest
grandest10311572grandest
haddest122711992_haddest
maddest112311212_maddest
saddest92412382_saddest
addrest958633__addrest
baldest102313533_baldest
beadiest113815533beadiest
blackest16269303blackest
bladder11429153bladde_r
bladders12397803bladders
bladdery15344583bladdery
blades95221253bla_des_
blankest14439063blankest
blindest11609093blindest
blondest11419243blondest
cladded12356923cladde_d
clades94920463cla_des_
cladist10311973cla_dist
cladodes1245323cladodes_
clayiest1337913clayiest
cloddiest1334633cloddiest
deadest93014883dea_dest
eldest72912683el__dest
faddiest1338113_faddiest
faddist12289643_faddist
flakiest153210543flakiest
flamiest133111973flamiest
flattest1138713flattest
flawiest14298573flawiest
flaxiest18298183flaxiest
gabfest1336453g_abfest
gadded103913173g_adde_d
gadder93714713g_adde_r
gadders103611503g_adders
gaddis94211373g_addis_
gadget93616183g_adge_t
gadgets10348683g_adgets
gamest94919933g_a_mest
gamiest102816233g_amiest
gashest114813413g_ashest
gaudiest1039393gaudiest
gayest104314333g_a_yest
giddiest11298553giddiest
glaces94218023gla_ces_
gladdened1342583gladdened
gladdener1252403gladdener
gladding1236303gladding
glade75121963gla_de__
gladier93810993gladie_r
glads75620613gla_d_s_
gladsomest1452463gladsomest
glaiket1238363glaike_t
glaires84010133glaires_
glairiest1035483glairiest
glaives11347833glaives_
glances104113143glances_
glanders103811503glanders
glandless1134163glandless
glands85314403gland_s_
glares75518863gla_res_
glasnost944953glasnost
glasses84414273glasses_
glassiest10279243glassiest
glazes165315643gla_zes_
gleamiest1235303gleamiest
gledes84915133gl_edes_
glibbest1343683glibbest
glides84518863gl_ides_
gluiest839773gl_uiest
glummest13235563glummest
goddess1035263g_oddess
goldest92411173g_oldest
grades84926313gra_des_
gradient10310373gradient
grapiest112211923grapiest
gravest114011633gra_vest
grayest11489363gra_yest
grodiest10310553grodiest
hardest113118413_hardest
headiest123015553headiest
headrest122910203headrest
laciest93819033_laciest
ladder84617623_ladde_r
ladders94115173_ladders
laddies93715053_laddies_
laddish12299723_laddish
lades65141273_la_des_
ladies75124883_ladies_
ladles74619543_ladles_
lakiest113517263_lakiest
lamest84722763_la_mest
lankest112714113_lankest
lardiest93813883_lardiest
largest83715103_largest
latest63822703_la_test
laxest134913363_la_xest
laziest163814473_laziest
leadiest93314983leadiest
lewdest1136283_lewdest
loudest839933_loudest
oddest81710863__oddest
oldest72114093ol__dest
plainest10313613plainest
platiest103216083platiest
readiest93719043readiest
reddest9311953_reddest
shadiest121711273shadiest
slackest14289393slackest
slatiest82616263slatiest
staidest939803staidest

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.420425454.8
2DLD Change Limit1461621247.23620199.3
3Display Results1241240.0761631.6
 (SQL Overall)1786911247.73223110.6
 
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.