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 “ductless” 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
ductless1119631(None) 
dustless9328351dustless
dauntless1033662dauntless
debtless1135652debtless
doubtless1243312doubtless
duchess1335552duc_hess
ductules1155542ductule_s
gustless9287682gustless
gutless82610712gu_tless
hurtless11307782hurtless
luckless14265892luckless
rustless83510242rustless
suckless14288822suckless
tactless10288462tactless
actress948533_actress
adultness1043973adultness
adultress1042943adultress
artless73712513_artless
backless162910633backless
beatless103311593beatless
beltless10297713beltless
blotless10347153blotless
boltless10338283boltless
bootless103410983bootless
bractless1335543bractless
bucklers16349503bucklers
buckles153416093buckle_s
budless1038873bu_dless
bushless1335813bushless
bustlers104210613bustlers
bustles93816323bustle_s
butlers94518053bu_tlers
butles84423913bu_tle_s
buttress1035883buttress
coatless1039693coatless
costless10310003costless
countless1146373countless
crustless1155403crustless
cuffless1634293cuffless
cureless10319703cureless
curtness1037263curtness
cutlass938013cu_tlass
cutlers94217003cu_tlers
cutlets94113653cu_tlets
cuttles93613923cuttle_s
daftness1235533daftness
dartles84014133dartle_s
dateless9259963dateless
deathless1335223deathless
decayless1542863decayless
deciles104417723decile_s
deckles143312803deckle_s
declass1038733dec_lass
deedless10318253deedless
deftness1236303deftness
depthless1542753depthless
dewless1137473d_ewless
dictiest113212783dictiest
distress9311713distress
doctorless1342583doctorless
doorless936713doorless
dottles83912283dottle_s
downless1236363downless
dripless1135243dripless
duces86327473duc__e_s
duchies133312313duchie_s
duckers143214713duc_kers
duckies143613813duckie_s
duckiest153211863duckiest
ducted104012123duct_e_d
ductile1048483ductile__
ductilely1543563ductilely
ductings12346673ductings
ducts85319893duct___s
ductule1065503ductule__
duelers83412053du_elers
duellers9268223duellers
dueness82310123du_eness
duffles14308923duffle_s
dullest8312633du_llest
dullness934873dullness
dulness8307983du_lness
dulses73913653du__lses
dumbness1334613dumbness
dunness8298983du_nness
duress74712063du__ress
dusters84918363dust_ers
dustiest93015073dustiest
dustiness102211033dustiness
duties74921903du_tie_s
exitless1534883exitless
faceless13269173faceless
fatless103212203_fatless
faultless1243163faultless
feckless17225783feckless
feetless1137383feetless
footless113710803footless
fretless1138063fretless
fruitless1244163fruitless
fumeless13236603fumeless
furless103210143fu_rless
fuseless11237233fuseless
giftless1245173giftless
guiltless1043023guiltless
gumless10228273gu_mless
gunless8299633gu_nless
guttlers9306933guttlers
guttles83011933guttle_s
haltless11308443haltless
hatless103813443_hatless
heatless113011463heatless
hiltless11297123hiltless
hitless103211193_hitless
huckles163612623huckle_s
hueless1058823hu_eless
humpless15226333humpless
huntress1144833huntress
hurtles103913753hurtle_s
hustlers11349203hustlers
hustles103414173hustle_s
iceless9219963_iceless
juiceless1843253juiceless
juryless1832983juryless
justles143311433justle_s
justness1535323justness
knotless1264573knotless
laceless10239853laceless
lintless82710013lintless
listless8269263listless
loftless1135903loftless
mastless102610023mastless
matless93014043_matless
meatless103410863meatless
muchness1534073muchness
muckles153413253muckle_s
neckless14236433neckless
netless739863_netless
nucleus956573nuc_leus
nutlets74111253nu_tlets
outbless1037963outbless
outclass1037203outclass
outlets73616363ou_tlets
pastless102411203pastless
peltless10267373peltless
plotless10256793plotless
poetless1038723poetless
portless10310643portless
pulpless12224953pulpless
pumpless14236373pumpless
punchless1643653punchless
puttyless1442013puttyless
reckless14257973reckless
restless82713163restless
riftless1136943riftless
rockless14297293rockless
rootless83910443rootless
ruckles133414603ruckle_s
ruleless836633ruleless
rumpless12256543rumpless
rungless956733rungless
runless72810423ru_nless
rustlers8339853rustlers
rustles73416413rustle_s
ruthless1135413ruthless
saltless8259343saltless
scumless1254993scumless
seatless83213003seatless
seductress1352253seductress
shitless11249243shitless
slitless8268143slitless
sockless14267793sockless
spotless1037043spotless
subtlest10511363subtlest
success1146403suc_cess
suchness1335763suchness
sucklers14379963sucklers
suckles134516743suckle_s
sudsless944353sudsless
sumless92611123su_mless
sunless73013693su_nless
sutlers73116973su_tlers
tackless14419483tackless
tentless8229843tentless
textless15245793textless
tintless8239863tintless
truceless11235393truceless
trustless955953trustless
tubeless1037023tubeless
tugless837383tu_gless
tuneless837913tuneless
turfless1135533turfless
turtlers8258203turtlers
turtles72914343turtle_s
tuskless1234213tuskless
unless62413073_u_nless
useless7188423_useless
ventless11249053ventless
vestless11258843vestless
viceless1337983viceless
victress1344523victress
wartless11279923wartless
wattless11268723wattless
wickless1736083wickless
witless103310983_witless
zestless17247433zestless

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.406440125.6
2DLD Change Limit1461622056.75021653.6
3Display Results2052050.0932204.3
 (SQL Overall)1786912057.24924650.4
 
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.