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

244 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
zestless1724743(None) 
restless82713161restless
vestless11258841vestless
beatless103311592beatless
beltless10297712beltless
costless10310002costless
crestless1146782crestless
debtless1135652debtless
dustless9328352dustless
feastless1235042feastless
feetless1137382feetless
gustless9287682gustless
heatless113011462heatless
listless8269262listless
mastless102610022mastless
meatless103410862meatless
nestlers8359232nestlers
nestles73015462nestle_s
netless739862ne_tless
pastless102411202pastless
peltless10267372peltless
pestles93217692pestle_s
restress82511772restress
rustless83510242rustless
seatless83213002seatless
tentless8229842tentless
textless15245792textless
ventless11249052ventless
yeastless1234052yeastless
zesters163517292zest_ers
zestiest173011102zestiest
artless73712513_artless
ashless10318453_ashless
assetless943573assetless
baseless1099563baseless
beakless14297383beakless
beamless12327003beamless
bedless1039703be_dless
beefless1335493beefless
beetlers1037403beetlers
beetles9312083beetle_s
bestrews1335603bestrews
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
bushless1335813bushless
bustlers104210623bustlers
bustles93816323bustle_s
cashless1336773cashless
castles94917733castle_s
ceaseless1135733ceaseless
cestuses1038083cestuses
coatless1039693coatless
crustless1155403crustless
deathless1335223deathless
deedless10318253deedless
deftness1236303deftness
depthless1542753depthless
dewless1137473de_wless
distress9311713distress
ductless11196313ductless
earless74316073_earless
eggless935663_eggless
egoless836983_egoless
endless839833_endless
esteems935243_esteems
esters64627733_est_ers
estheses1137783_estheses
esthesis1148463_esthesis
eventless1244603eventless
exitless1534883exitless
eyeless1058053_eyeless
fastness11238763fastness
fatless103212203_fatless
fearless1137873fearless
feckless17225783feckless
feeless103511103fe_eless
fernless1136063fernless
festers104121393fest_ers
fettles103912733fettle_s
fishless1436413fishless
fleshless1543993fleshless
footless113710803footless
fretless1138063fretless
frostless1235743frostless
fuseless11237233fuseless
gasless8319013gas_less
gastness9278483gastness
gearless937373gearless
gentles83714343gentle_s
gentlest93410573gentlest
gestes75721393gest_e_s
giftless1245173giftless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
headless12289863headless
heartless1236393heartless
heathless1535593heathless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helmless1334273helmless
helpless1335063helpless
herbless1336663herbless
hiltless11297123hiltless
hitless103211193_hitless
hostess103210243host_ess
hostlers113310483hostlers
hurtless11307783hurtless
hustlers11349203hustlers
hustles103414173hustle_s
istles62814983_istle_s
jesters144118193jest_ers
jostlers15357683jostlers
jostles143411143jostle_s
justles143311433justle_s
justness1535323justness
keelless12236193keelless
kestrels1235813kestrels
kettles113411613kettle_s
keyless1436163ke_yless
knotless1264573knotless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lensless835583lensless
lintless82710013lintless
loftless1135903loftless
lossless835473lossless
lostness837683lostness
massless10277113massless
matless93014043_matless
mealless10288363mealless
meetness1036653meetness
menseless1145203menseless
meritless1144593meritless
mestees94617753mest_ees
mesteso937133mest_eso
mestesos1045223mest_esos
mettles94115023mettle_s
mistress10310703mistress
neatness839153neatness
neckless14236433neckless
needless9308333needless
nesters74422793nest_ers
nestle63013953nestle__
nestled8349913nestle_d
nestler73510453nestle_r
nettlers8307513nettlers
nettles73214083nettle_s
newsless1134533newsless
noseless839513noseless
ostlers72911203_ostlers
passless10247223passless
pastness102510503pastness
peakless14236683peakless
peerless1037513peerless
pegless1038053pe_gless
pertness10310093pertness
pesters93827093pest_ers
pestiest103018413pestiest
pestle83215843pestle__
pestled102711453pestle_d
pettles93916483pettle_s
pleatless1134613pleatless
plotless10256793plotless
poetless1038723poetless
portless10310643portless
prestress1138133prestress
reckless14257973reckless
reinless8139443reinless
resales74724903resale_s
resiles74026543resile_s
resistless1043173resistless
resoles73823653resole_s
resters74130403rest_ers
restlessly1344263restlessly
restyles1139193restyle_s
resultless1041953resultless
riftless1136943riftless
riskless1235763riskless
rootless83910443rootless
rustlers8339853rustlers
rustles73416413rustle_s
saltless8259343saltless
sashless1136603sashless
scentless1135113scentless
seamless10238723seamless
seedless9319513seedless
selfless1135013selfless
senseless945973senseless
sestets7911473sest_ets
settlers8289023settlers
settles73916003settle_s
sexless1467243se_xless
sheetless1235823sheetless
shitless11249243shitless
slitless8268143slitless
spotless1037043spotless
stress66616673__stress
tactless10288463tactless
tasteless935673tasteless
tearless848713tearless
teethless1243703teethless
termless1036233termless
testees74215913test_ees
testers74124543test_ers
testes65125823test_e_s
testiest82715223testiest
testiness9209753testiness
tintless8239863tintless
trestles83012553trestle_s
trustless955953trustless
tuskless1234213tuskless
unstress837373unstress
useless7188423_useless
vastness11257293vastness
veinless11136263veinless
verbless1336033verbless
vestees103513173vest_ees
vistaless1254573vistaless
waistless1235093waistless
wartless11279923wartless
wattless11268723wattless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
westers105221963west_ers
wetness10277723we_tness
wheatless1534003wheatless
wishless1435993wishless
witless103310983_witless
wrestlers12306103wrestlers
wrestles113310063wrestle_s
zested164214043zest_e_d
zester153617793zest_e_r
zestfulness2345313zestfulness
zestier163010223zestie_r
zests145419743zest___s
zipless18276303z_ipless
zoneless1737823zoneless
zosters163015413zost_ers

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.420425454.8
2DLD Change Limit1461622447.29620033.2
3Display Results2442440.1102218.2
 (SQL Overall)1786912447.82622833.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.