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 “gladliest” 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
gladliest113538(None) 
gladiest101710341glad_iest
deadliest1138182deadliest
gladdest11145842glad_dest
gladlier1034342gladlie_r
glairiest1035492glairiest
glariest92012532gla_riest
glassiest10279252glassiest
glaziest18227922gla_ziest
gnarliest10186552gnarliest
godliest1039452g_odliest
goodliest1146392goodliest
beadiest113815533bead_iest
blastiest111710053blastiest
brawliest14177193brawliest
cladist10311973clad_i_st
clammiest1535743clammiest
clankiest1536673clankiest
classiest11309553classiest
clayiest1337923cla_yiest
cleanliest1244363cleanliest
cloddiest1334633cloddiest
coaliest10316223coa_liest
crawliest14187403crawliest
cuddliest1343333cuddliest
drawliest13166243drawliest
earliest82415243_earliest
faddiest1338113_faddiest
featliest1238363featliest
flabbiest1644213flabbiest
flaggiest14145513flaggiest
flakiest153210553fla_kiest
flamiest133111983fla_miest
flappiest1644863flappiest
flashiest1557993flashiest
flawiest14298583fla_wiest
flaxiest18298193fla_xiest
fledgiest1444183fledgiest
gabbiest1337273g_abbiest
gadflies1334733g_adflies_
gainliest1037133gainliest
gallies84122713g_allies_
gamiest102816233g_a_miest
gammiest13339333g_ammiest
gangliest1137673gangliest
gappiest13259483g_appiest
gassiest93212523g_assiest
gaudiest1039393g_audiest
gauziest1836233g_auziest
gawkiest16327313g_awkiest
ghastliest1443443ghastliest
giddiest11298553g_iddiest
giggliest1234323giggliest
girliest93010403g_irliest
glades84820343glad__es_
gladier93810993glad_ie_r
gladness1036153glad_ness
gladsomest1452463gladsomest
glandless1134163glandl_ess
glassies94012273glassies_
gleamiest1235313gleamiest
gleetiest1035913gleetiest
glintiest1037623glintiest
glitziest1944003glitziest
globbiest1444023globbiest
gloomiest1235603gloomiest
gloppiest1444833gloppiest
glossiest10277943glossiest
gluiest839773gl__uiest
glumpiest1434953glumpiest
gnattiest1035383gnattiest
goalies8316023goa_lies_
goggliest1234063goggliest
grabbiest1435323grabbiest
gradient10310373grad_ient
grainiest10188993grainiest
grapiest112211933gra_piest
grassiest10309513grassiest
grisliest1047353grisliest
grodiest10310553grod_iest
growliest1335583growliest
headiest123015553head_iest
kindliest1436113kindliest
kludgiest1543153kludgiest
laciest93819043_la_ciest
laddies93715053_laddies_
ladies75124883_lad_ies_
ladles74619543_ladl_es_
lakiest113517273_la_kiest
lambiest122410193_lambiest
lankiest122912503_lankiest
lardiest93813893_lardiest
larkiest123713323_larkiest
lathiest11312663_lathiest
laziest163814483_la_ziest
leadiest93314993lead_iest
ledgiest10288593_ledgiest
lordliest1036103lordliest
loudliest1035773loudliest
lowliest11229473_lowliest
manliest102314943_manliest
marliest102415183_marliest
mealiest102215973mea_liest
measliest1147173measliest
nearliest949363nearliest
paliest93021613_pa_liest
palliest102814643_palliest
pearliest1139363pearliest
plashiest1478383plashiest
platiest103216093pla_tiest
playlist1347573playli_st
puddliest1343693puddliest
readiest93719043read_iest
scaliest101714403sca_liest
shadiest121711283shad_iest
shaliest111415063sha_liest
slaggiest11157713slaggiest
slangiest10129083slangiest
slatiest82616273sla_tiest
sludgiest1135813sludgiest
snarliest91810213snarliest
studliest1036573studliest
vealiest112513203vea_liest
weakliest1635853weakliest

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411246.50022867.8
3Display Results1241240.0631968.3
 (SQL Overall)1786911246.99925530.9
 
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.