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

125 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
glegness103461(None) 
gladness1036152gladness
gleaners9348072gleaners
glegnesses1245072glegnesses
glibness1134132glibness
glueyness1342912glueyness
gluiness937362gluiness
glumness1135202glumness
greyness1235242greyness
legless838012_legless
agedness1036683agedness
agileness1046493agile_ness
alertness946053alertness
alienness945373alienness
aligners9117573aligners
bigness1038193_bigness
bleakness1543593bleakness
blueness1038213blueness
cleaners103610543cleaners
cleanest10310293cleanest
cleanness1144973cleanness
cleanses10358143cleanses
clearness1135633clearness
deepness1136443deepness
dueness82310123due_ness
egress73310433__egress
elegies81312903elegie_s
elegises9128823elegises
evenness1135543evenness
eyedness1245103eyedness
fellness1135913fellness
fewness1335003_fewness
feyness1334923_feyness
flagless1235403flagless
flatness1138153flatness
fleetness1244753fleetness
flenses1039473fle_nses
freeness11710443freeness
gameness112810693gameness
gaminess112911063gaminess
gastness9278473gastness
gayness1136843g_ayness
geekiness1435413geekiness
gelidness1144473gelidness
genes65133093g_e_ne_s
geneses82613523g_e_neses
genesis82510823g_e_nesis
genets75716663g_e_nets
glariness1038553glariness
glaziness1935753glaziness
gleamers11306563gleamers
gleaned9349423gleane_d
gleaner8379773gleane_r
gleans75014743glean__s
glebeless1242953glebeless
glebes95512243gle_be_s
gledes84915133gle_de_s
gleeds84711623gle__eds
gleeks11489673gle__eks
glees65027593gle__e_s
gleets75315053gle__ets
glens66519853gle_n__s
goldenness1243413goldenness
goneness9310763goneness
goodness1036253goodness
gooeyness1343543gooeyness
goriness9310753goriness
governess1346173governess
grayness1235933grayness
greatness1036903greatness
greenest9312623greenest
greenness1046793greenness
grimness1175993grimness
haleness11312623hale_ness
hugeness1237373hugeness
idleness936843idle_ness
illness736473il_lness
keenness1234883keenness
laxness1436043_laxness
leaners73718173_leaners
leanest7415863_leanest
leanness837373_leanness
legends936073_legends
legers74518313_leg_ers
leges64427283_leg_e_s
legginess1135033_legginess
lenes54738523_le_ne_s
lenses64620893_le_nses
leones64417723_leone_s
lewdness1254173_lewdness
lioness739103_lioness
loginess9310163_loginess
longness938553longness
lowness1037813_lowness
maleness10312313male_ness
meekness1434303meekness
meetness1036653meetness
newness1035703_newness
oldness836403ol_dness
oleines7313393oleine_s
oneness7512143one_ness
openness1035473openness
paleness10312983pale_ness
pegless1038053_pegless
plugless1133863plugless
redness82012443_redness
regress82711453_regress
sageness92111983sageness
selfness1135153selfness
skewness1533763skewness
sleekness1344543sleekness
slimness1036523slimness
slowness1135013slowness
slyness1035263sl_yness
smugness1143813smugness
snugness934323snugness
soleness8814263sole_ness
trigness968403trigness
tweeness11246403tweeness
ugliness936863ugl_iness
vileness1139983vile_ness
waeness102512783wae_ness
wellness1135793wellness
wetness10277723_wetness
woeness1020211543woe_ness

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.1601116818.8
2DLD Change Limit1461621257.20020300.3
3Display Results1251250.0502500.0
 (SQL Overall)1786911257.41024114.8
 
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.