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

205 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
debtless113565(None) 
beatless103311592beatless
beltless10297712beltless
deathless1335222deathless
deedless10318252deedless
deftness1236302deftness
depthless1542752depthless
dewless1137472de_wless
doubtless1243312doubtless
ductless11196312ductless
dustless9328352dustless
feetless1137382feetless
heatless113011462heatless
meatless103410862meatless
netless739862ne_tless
peltless10267372peltless
restless82713162restless
seatless83213002seatless
tentless8229842tentless
textless15245792textless
ventless11249052ventless
vestless11258842vestless
webless1237002web_less
zestless17247432zestless
adeptness1273953adeptness
artless73712513_artless
beakless14297383beakless
beamless12327003beamless
bedless1039703be_dless
beefless1335493beefless
beetlers1037403beetlers
beetles9312083beetle_s
bibless11439173bib_less
bless75917813__b_less
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
coatless1039693coatless
costless10310003costless
crestless1146783crestless
dabblers13379363dabblers
dabbles124514773dabble_s
daftness1235533daftness
dartles84014133dartle_s
dateless9259963dateless
dauntless1033663dauntless
deadness1039233deadness
deafness1236213deafness
dealers84118613de_alers
dearness939973dearness
debacles1335723debacle_s
debasers11377903debasers
debases103814133debase_s
debaters113511923debaters
debates103718533debate_s
deboners11268113deboners
debones103315113debone_s
debriefs1433533debriefs
debtors1038533debt_ors
debts86418373debt___s
debyes1238103deb_ye_s
decayless1542863decayless
deciles104417723decile_s
deckles143312803deckle_s
declass1038733de_class
deepness1136443deepness
defilers12439473defilers
defiles114016843defile_s
defleas1147223de_fleas
deftest112611713deft_est
deities82621923deitie_s
deles65139253de__le_s
demoness1138053demoness
depress10239873de_press
deters74724683de_t_ers
detest74122843de_t_est
detests83711743de_t_ests
dewiness1238453dewiness
dibblers13377583dibblers
dibbles124013333dibble_s
distress9311713distress
doorless936713doorless
dottles83912283dottle_s
downless1236363downless
dreamless1243513dreamless
dripless1135243dripless
earless74316073_earless
edgeless1034883edgeless
editress944933editress
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eventless1244603eventless
exitless1534883exitless
eyeless1058053_eyeless
fatless103212203_fatless
fearless1137873fearless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
fernless1136063fernless
fettles103912733fettle_s
footless113710803footless
fretless1138063fretless
gearless937373gearless
gentles83714343gentle_s
gentlest93410573gentlest
giftless1245173giftless
glebeless1242953glebeless
gustless9287683gustless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
headless12289863headless
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hiltless11297123hiltless
hitless103211193_hitless
hurtless11307783hurtless
idealess935653ide_aless
idealless1042953idealless
jobless16237563job_less
keelless12236193keelless
kettles113411613kettle_s
keyless1436163ke_yless
knotless1264573knotless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lensless835583lensless
lintless82710013lintless
listless8269263listless
loftless1135903loftless
mastless102610023mastless
matless93014043_matless
mealless10288363mealless
meetness1036653meetness
meritless1144593meritless
mettles94115023mettle_s
neatness839153neatness
neckless14236433neckless
needless9308333needless
nestlers8359233nestlers
nestles73015463nestle_s
nettlers8307513nettlers
nettles73214083nettle_s
newsless1134533newsless
orbless937493orb_less
outbless1037963outbless
pastless102411203pastless
peakless14236683peakless
pebbles1337573pebble_s
peerless1037513peerless
pegless1038053pe_gless
pertness10310093pertness
pestles93217693pestle_s
pettles93916483pettle_s
pleatless1134613pleatless
plotless10256793plotless
poetless1038723poetless
portless10310643portless
prebless1236823preb_less
reckless14257973reckless
reinless8139433reinless
restress82511773restress
ribless93410343rib_less
riftless1136943riftless
rootless83910443rootless
rustless83510243rustless
saltless8259343saltless
scentless1135113scentless
seamless10238723seamless
seedless9319513seedless
selfless1135013selfless
settlers8289023settlers
settles73916003settle_s
sexless1467243se_xless
sheetless1235823sheetless
shitless11249243shitless
slitless8268143slitless
spotless1037043spotless
subtlest10511363subtlest
tactless10288463tactless
tearless848713tearless
teethless1243703teethless
termless1036233termless
tintless8239863tintless
tubeless1037023tubeless
veinless11136263veinless
verbless1336033verbless
wartless11279923wartless
wattless11268723wattless
weedless12287963weedless
weldless12285813weldless
wetness10277723we_tness
wheatless1534003wheatless
witless103310983_witless
yeastless1234053yeastless

Search took 9 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.486367677.0
2DLD Change Limit1461622057.90618487.5
3Display Results2052050.280732.1
 (SQL Overall)1786912058.67220605.5
 
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.