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 “edgeless” 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
edgeless103488(None) 
ageless8310342_ageless
badgeless1343202badgeless
edginess1036052edginess
eggless935662e_ggless
egoless836982e_goless
eyeless1058052e_yeless
wageless1237172wageless
angerless1045023angerless
aweless1038723_aweless
baseless1099563baseless
bedless1039703bed__less
boneless10310213boneless
bridgeless1452153bridgeless
careless102813633careless
ceaseless1135733ceaseless
clueless1035883clueless
codeless112010113codeless
coreless103013833coreless
cudgelers1343083cudgelers
cureless10319703cureless
dateless9259963dateless
debtless1135653debtless
deedless10318253deedless
deles65139253_d_ele_s
dewless1137473_dewless
duelers83412053_duelers
dueness82310123_dueness
eagerest9510273eagerest
eagerness1046263eagerness
eagles73819163eag_le_s
eaglets84111663eag_lets
earless74316073e_arless
echoless1345603echoless
edelweiss135733ed_elweiss
edgers84413923edg__ers
edges75718743edg__e_s
edgeways1642583edgeways
edgewise1342733edgewise
edgiest92310353edg_iest
edibles1048003edible_s
ediles74016983ed_ile_s
editress944933editress
egress73310433e_g_ress
endless839833e_ndless
exitless1534883exitless
eyeglass1263333eyeglass
eyelets1057523e_yelets
faceless13269173faceless
fadeless12258323fadeless
fameless13259203fameless
feeless103511103_feeless
fenceless1444163fenceless
fireless112810593fireless
fogless1138193fog_less
fumeless13236603fumeless
fuseless11237233fuseless
gateless9279953gateless
gelees74116263__gelees
hideless12278713hideless
hiveless14227933hiveless
holeless1189363holeless
homeless131110133homeless
hopeless13118303hopeless
hueless1058823_hueless
hugeness1237373hugeness
iceless9219963_iceless
idealess935653idealess
idleness936843idleness
ireless72312243_ireless
isleless834853isleless
jagless1537103jag_less
kedgerees1542693kedgerees
kegelers1355163kegelers
laceless10239853laceless
legless838013leg_less
lifeless11228143lifeless
limeless10249663limeless
lineless82711943lineless
loveless1168573loveless
maneless102812343maneless
mateless102711293mateless
menseless1145203menseless
moveless1367753moveless
nameless10248373nameless
nerveless1243933nerveless
noseless839513noseless
noteless839403noteless
odorless934173odorless
paneless102611763paneless
pegless1038053peg_less
pileless1088623pileless
pipeless12107663pipeless
poleless1089873poleless
popeless1288473popeless
ruleless836633ruleless
sageness92111983sageness
senseless945973senseless
shoeless1137803shoeless
sighless1276553sighless
soleless8910033soleless
tameless10259903tameless
tapeless10218643tapeless
tideless9269083tideless
tieless72512563_tieless
timeless10239543timeless
tireless82510263tireless
toeless72612393_toeless
toneless8610393toneless
treeless839283treeless
tubeless1037023tubeless
tugless837383tug_less
tuneless837913tuneless
useless7188423_useless
viceless1337983viceless
voteless1137493voteless
wakeless1536473wakeless
waveless1437483waveless
wifeless14277483wifeless
wigless11359673wig_less
wineless112711173wineless
wireless11249633wireless
yokeless1535303yokeless
zoneless1737823zoneless

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.436409841.7
2DLD Change Limit1461621247.06320694.0
3Display Results1241240.0631968.3
 (SQL Overall)1786911247.56223630.1
 
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.