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

227 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
leafless1124657(None) 
leadless9248791leadless
leaflets11244811leaflets
leakless12246981leakless
beakless14297382beakless
beamless12327002beamless
beatless103311592beatless
beefless1335492beefless
deafness1236212deafness
earless74316072_earless
fearless1137872fearless
gearless937372gearless
headless12289862headless
heatless113011462heatless
lawless1037032l_awless
leafiest113410892leafiest
leafiness1236482leafiness
leaflet10199742leafle_t
leanness837372leanness
legless838012le_gless
lensless835582lensless
loamless10235212loamless
mealless10288362mealless
meatless103410862meatless
peakless14236682peakless
pleatless1134612pleatless
seamless10238722seamless
seatless83213002seatless
selfless1135012selfless
tearless848712tearless
awless939263__awless
barless94317003_barless
beadles103414733beadle_s
beagles103212123beagle_s
beardless1234913beardless
bedless1039703be_dless
befleas1236973be_fleas
beltless10297713beltless
bleakness1543593bleakness
braless92910563bra_less
breadless1235943breadless
capless114312763_capless
carless95118493_carless
ceaseless1135733ceaseless
chadless1436403chadless
clawless1334123clawless
cleanness1144973cleanness
clearness1135633clearness
coalless1038193coalless
coatless1039693coatless
cuffless1634293cuffless
deadness1039233deadness
deafens11317253deaf_ens
deafest112911513deaf_est
dealers84118613dea_lers
dearness939973dearness
deathless1335223deathless
debtless1135653debtless
decayless1542863decayless
deedless10318253deedless
defleas1147223de_fleas
dewless1137473de_wless
dreamless1243513dreamless
eagles73819163_eagle_s
eaglets84111663_eaglets
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fatless103212203_fatless
feastless1235043feastless
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
fernless1136063fernless
flagless1235403flagless
flapless1335343flapless
flawless1434503flawless
fleckless1842893fleckless
fleshless1543993fleshless
foamless13195843foamless
gapless10349993_gapless
gasless8319013_gasless
glebeless1242953glebeless
goalless935723goalless
hapless123311333_hapless
hatless103813443_hatless
healers104319463hea_lers
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hoofless14258013hoofless
idealess935653idea_less
idealless1042953idealless
jagless1537103_jagless
jawless1745653_jawless
keelless12236193keelless
keyless1436163ke_yless
kleagles1343143kleagle_s
laceless10239853laceless
ladlers84613573l_adlers
ladles74619543l_adle_s
landless94011173landless
largess8408913l_argess
laxness1436043l_axness
leachers133712813leachers
leaches123319343leache_s
leadens83610983lea_dens
leaderless1143433leaderless
leaders83819603lea_ders
leadiest93314993leadiest
leafages1244623leafages
leafed105713873leaf_e_d
leafier10329833leafie_r
leafleted1342893leafleted
leafleter1242553leafleter
leafleters1342433leafleters
leaflike1534713leaflike
leafs85721183leaf___s
leaguers935063leaguers
leagues837943league_s
leakers113415423lea_kers
leakiest123212803leakiest
leakiness1337503leakiness
leaners73718173lea_ners
leanest7415863lea_nest
leapers93716663lea_pers
leariest83117853leariest
learners8398153learners
leasers74717843lea_sers
leases65428113lea_se_s
leashes103514403leashe_s
leathers114215083leathers
leavens10409303lea_vens
leavers103717783lea_vers
leaves94222383lea_ve_s
leaviest112910823leaviest
leftest10269463le_ftest
legalese954753legalese
legaleses1044393legaleses
levelers11259323levelers
levelness1245453levelness
lewdness1254173lewdness
lidless8309273l_idless
lifeless11228143lifeless
limbless12246313limbless
limeless10249663limeless
lineless82711943lineless
lintless82710013lintless
lipless9259553l_ipless
listless8269263listless
loafers10349463loaf_ers
loftless1135903loftless
lordless9277483lordless
lossless835473lossless
loveless1168573loveless
luckless14265893luckless
manless93012933_manless
matless93014043_matless
meanness1037183meanness
measles92412753measle_s
napless93110283_napless
nearness838313nearness
neatness839153neatness
neckless14236433neckless
needless9308333needless
netless739863ne_tless
newsless1134533newsless
oarless73913373_oarless
pearlers1039033pearlers
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
planless1036813planless
playless1334863playless
rayless10239003_rayless
reales64934123rea_le_s
realest73322433rea_lest
realness8410443realness
reassess836513reassess
reckless14257973reckless
reflets103513153re_flets
reinless8139433reinless
restless82713163restless
roadless937703roadless
roofless11316733roofless
sapless93313443_sapless
scarless10189053scarless
sealers74323553sea_lers
seedless9319513seedless
selfness1135153selfness
sexless1467243se_xless
sleepless1144553sleepless
snapless10287463snapless
soapless10278073soapless
spanless10247363spanless
starless81610843starless
taxless1436913_taxless
teazles16308923teazle_s
tentless8229843tentless
termless1036233termless
textless15245793textless
thawless1434083thawless
toadless936313toadless
tramless1037503tramless
treadless1036003treadless
turfless1135533turfless
vealers103214293vea_lers
veinless11136263veinless
ventless11249053ventless
verbless1336033verbless
vestless11258843vestless
warless104015103_warless
wayless13308243_wayless
weakness1535353weakness
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wheatless1534003wheatless
yeastless1234053yeastless
zestless17247433zestless

Search took 10 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.423422437.4
2DLD Change Limit1461622278.43617326.0
3Display Results2272270.1901194.7
 (SQL Overall)1786912279.04919747.0
 
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.