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

293 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
listless826926(None) 
lintless82710011lintless
blissless1142632blissless
costless10310002costless
distress9311712distress
dustless9328352dustless
fishless1436412fishless
giftless1245172giftless
gustless9287682gustless
hiltless11297122hiltless
hitless103211192hi_tless
istles62814982_istle_s
lidless8309272li_dless
lifeless11228142lifeless
lightless1386072lightless
limbless12246312limbless
limeless10249662limeless
limitless1142942limitless
lineless82711942lineless
lipless9259552li_pless
lisles63416282lis_le_s
listees73416672list_ees
listels74212432list_els
listens74014132list_ens
listers74026532list_ers
listlessly1343462listlessly
littles73212782little_s
littlest8309242littlest
loftless1135902loftless
lossless835472lossless
lostness837682lostness
mastless102610022mastless
mistress10310702mistress
pastless102411202pastless
restless82713162restless
riftless1136942riftless
riskless1235762riskless
rustless83510242rustless
slitless8268142sli_tless
tintless8239862tintless
vestless11258842vestless
vistaless1254572vistaless
waistless1235092waistless
wishless1435992wishless
witless103310982wi_tless
zestless17247432zestless
aidless83612073ai_dless
aimless93610813ai_mless
airless73712043ai_rless
aisles64721143ais_le_s
artless73712513_artless
ashless10318453_ashless
assetless943573assetless
baseless1099563baseless
beatless103311593beatless
beltless10297713beltless
bibless11439173bi_bless
bisters93922613bist_ers
bistres94017213bistre_s
blisters104015083blist_ers
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
bristles101510433bristle_s
bushless1335813bushless
bustlers104210623bustlers
bustles93816323bustle_s
cashless1336773cashless
castles94917733castle_s
cistuses1038283cistuses
classless1143843classless
clickless1743983clickless
clientless1272493clientless
cloistress1242713cloistress
coatless1039693coatless
crestless1146783crestless
crustless1155403crustless
debtless1135653debtless
ductless11196313ductless
epistlers1154113epistlers
epistles1047783epistle_s
exitless1534883exitless
fastness11238763fastness
fatless103212203_fatless
feastless1235043feastless
feetless1137383feetless
filmless1344553filmless
finless102810783fi_nless
fireless112810593fireless
firstness1245013firstness
fitness10299393fi_tness
fleshless1543993fleshless
flightless1773393flightless
footless113710803footless
fretless1138063fretless
frostless1235743frostless
fuseless11237233fuseless
gasless8319013gas_less
gastness9278483gastness
glassless1043873glassless
glistens9366593glist_ens
glisters93912603glist_ers
gristles9189203gristle_s
guiltless1043023guiltless
gutless82610713_gutless
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hideless12278713hideless
hipless12399923hi_pless
hiveless14227933hiveless
hostess103210243host_ess
hostlers113310483hostlers
hurtless11307783hurtless
hustlers11349203hustlers
hustles103414173hustle_s
iceless9219963_iceless
inkless11348713_inkless
innless7288293_innless
ireless72312243_ireless
isleless834853_isleless
isles54220563_is_le_s
islets64513083_is_lets
istle52214713_istle__
ixtles13217063_ixtle_s
jointless1634323jointless
jostlers15357683jostlers
jostles143411143jostle_s
justles143311433justle_s
justness1535323justness
kindless13289243kindless
kingless13288693kingless
kinless113310273ki_nless
kirtles11309663kirtle_s
kittles113012493kittle_s
kittlest12297573kittlest
klisters123910483klist_ers
knotless1264573knotless
laceless10239853laceless
landless94011173landless
lasters75627693last_ers
lawless1037033l_awless
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013l_egless
leisters83312823leist_ers
lensless835583lensless
libelees10227213libelees
libelers10238623libelers
licitness1145373licitness
lifters104313783lift_ers
lightness13107433lightness
ligules82210923ligule_s
likeness12229863likeness
liminess10510643liminess
limpness1246703limpness
linerless936333linerless
lintels73311163lint_els
linters73822633lint_ers
lintiest82715913lintiest
lioness739103li_oness
lisle53916723lis_le__
lispers94514323lis_pers
listed74322833list_e_d
listee64223063list_e_e
listel64214743list_e_l
listen64816813list_e_n
listeners9147333listeners
lister64527253list_e_r
listings93310043listings
lists56628693list___s
liteness82213213liteness
liters65429883li_t_ers
lithest10513913li_thest
litres65220393li_tre_s
litters73422573li_tters
little63312163little__
littleness1045023littleness
littler7348553little_r
littlish1145043littlish
liveness112411393liveness
loamless10235213loamless
lordless9277483lordless
loveless1168573loveless
luckless14265893luckless
lushness1136233lushness
lusterless1043693lusterless
lusters73921443lust_ers
lustiest82914493lustiest
lustiness92010453lustiness
lustres73013233lustre_s
massless10277113massless
matless93014043_matless
meatless103410863meatless
milkless1434773milkless
mindless11319443mindless
mirthless1443353mirthless
misclass1246843misclass
misguess1134643misguess
misters93927513mist_ers
mistiest103018313mistiest
mistiness111911633mistiness
moistness1146343moistness
nestlers8359233nestlers
nestles73015463nestle_s
netless739863_netless
nightless1386073nightless
noiseless945553noiseless
noseless839513noseless
ostlers72911203_ostlers
passless10247223passless
pastness102510503pastness
peltless10267373peltless
pestles93217693pestle_s
pileless1088623pileless
pilotless1144003pilotless
pintles94118733pintle_s
pipeless12107663pipeless
pistes85325633pist_e_s
pistoles102514723pistole_s
pithless13117023pithless
pitiless10127333pitiless
pleatless1134613pleatless
plotless10256793plotless
poetless1038723poetless
pointless1135713pointless
portless10310643portless
printless1137523printless
resistless1043173resistless
restress82511773restress
ribless93410343ri_bless
rimless9369363ri_mless
rindless92510203rindless
rootless83910443rootless
rustlers8339853rustlers
rustles73416413rustle_s
saltless8259343saltless
sashless1136603sashless
seatless83213003seatless
shiftless15265303shiftless
shirtless12266413shirtless
shitless11249243shitless
sighless1276553sighless
sightless1385923sightless
sinless73014213si_nless
sisters73721593sist_ers
skirtless13254423skirtless
slipless10246993sli_pless
spotless1037043spotless
stress66616673__stress
tactless10288463tactless
taintless935743taintless
tasteless935673tasteless
tentless8229843tentless
textless15245793textless
thistles1198233thistle_s
tideless9269083tideless
tieless72512563ti_eless
timeless10239543timeless
tipless92610063ti_pless
tireless82510263tireless
titles63719923ti_tle_s
tittles73413253tittle_s
trustless955953trustless
tuskless1234213tuskless
unstress837373unstress
useless7188423_useless
vastness11257293vastness
ventless11249053ventless
viceless1337983viceless
victress1344523victress
viewless1434033viewless
visorless1243143visorless
vittles103211113vittle_s
wartless11279923wartless
wattless11268723wattless
whistlers1595163whistlers
whistles14108213whistle_s
wickless1736083wickless
wifeless14277483wifeless
wigless11359673wi_gless
windless123310863windless
wineless112711173wineless
wingless122910023wingless
winless103212283wi_nless
wintles103414983wintle_s
wireless11249633wireless
wiseness112010753wiseness
witness103010013wi_tness
wristlets1244473wristlets
yeastless1234053yeastless
zipless18276303zi_pless

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.423422437.4
2DLD Change Limit1461622936.48322545.4
3Display Results2932930.1262325.4
 (SQL Overall)1786912937.03225411.1
 
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.