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

230 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
termless103623(None) 
armless9369942_armless
beamless12327002beamless
fernless1136062fernless
formless13248082formless
gormless11235442gormless
harmless1337402harmless
helmless1334272helmless
herbless1336662herbless
kermess13396222kerm_ess
normless10235922normless
seamless10238722seamless
stemless1036652ste_mless
tearless848712tearless
tentless8229842tentless
termers95414502term_ers
textless15245792textless
tireless82510262tireless
tramless1037502tramless
treeless839282treeless
turfless1135532turfless
verbless1336032verbless
aimless93610813_aimless
airless73712043air_less
armlets94610063_armlets
artless73712513_artless
barbless12318713barbless
barkless14318023barkless
barless94317003bar_less
beakless14297383beakless
beardless1234913beardless
beatless103311593beatless
bedless1039703be_dless
beefless1335493beefless
beltless10297713beltless
bermes106023003berm_e_s
berryless1442293berryless
braless92910563_braless
brimless1235273brimless
careless102813633careless
carless95118493car_less
cermets1139713cerm_ets
charmless1633583charmless
cordless11299963cordless
coreless103013833coreless
crewless1335413crewless
cureless10319703cureless
debtless1135653debtless
deedless10318253deedless
dermises112512023dermises
dewless1137473de_wless
dreamless1243513dreamless
earless74316073_earless
eeriness8311873eeriness
eggless935663_eggless
egoless836983_egoless
endless839833_endless
eyeless1058053_eyeless
fearless1137873fearless
feckless17225783feckless
feeless103511103fe_eless
feetless1137383feetless
ferules103112723ferule_s
filmless1344553filmless
fireless112810593fireless
firmness1334743firmness
foamless13195843foamless
fordless12289003fordless
forkless15267433forkless
fretless1138063fretless
furless103210143fur_less
garbless11388253garbless
gearless937373gearless
germens1078633germ_ens
germiest11249923germiest
germiness1257693germiness
gumless10228273_gumless
headless12289863headless
heartless1236393heartless
heatless113011463heatless
heedless12278813heedless
heelless11257653heelless
heirless1146053heirless
helpless1335063helpless
hornless1137363hornless
hurtless11307783hurtless
ireless72312243_ireless
juryless1832983juryless
keelless12236193keelless
kermes124616133kerm_e_s
kermesse14303483kerm_esse
kermises14248313kermises
keyless1436163ke_yless
kirmess13234313kirm_ess
leadless9248793leadless
leafless11246573leafless
leakless12246983leakless
legless838013le_gless
lensless835583lensless
loamless10235213loamless
lordless9277483lordless
mealless10288363mealless
meatless103410863meatless
merciless1344473merciless
meritless1144593meritless
merles85322763mer_le_s
neckless14236433neckless
needless9308333needless
nerveless1243933nerveless
netless739863ne_tless
newsless1134533newsless
oarless73913373oar_less
orbless937493_orbless
peakless14236683peakless
peerless1037513peerless
pegless1038053pe_gless
peltless10267373peltless
pertness10310093pertness
portless10310643portless
prebless1236823prebless
reckless14257973reckless
reinless8139433reinless
restless82713163restless
rimless9369363_rimless
scumless1254993scumless
seatless83213003seatless
seedless9319513seedless
selfless1135013selfless
sexless1467243se_xless
starless81610843star_less
sterlets8169273ster_lets
sternness946093sternness
sumless92611123_sumless
tackless14419483tackless
tactless10288463tactless
tailless8239083tailless
tameless10259903tameless
tankless12267823tankless
tapeless10218643tapeless
tartlets8289663tartlets
tartness82210133tartness
taxless1436913t_axless
teariness9310633teariness
teazles16308923teazle_s
teemers95012903teem_ers
teethless1243703teethless
teles54536003te__le_s
teleses7313123te__leses
telesis7310793te__lesis
tellers73717603te_llers
tempehs14325153te_mpehs
tempers113513013te_mpers
tempest1139223te_mpest
tempests1234443te_mpests
temples112610893temple_s
templets12226143templets
tercelets1144813tercelets
tercels94110363ter_cels
terces83921413ter_ce_s
tercets93512443ter_cets
termed94816703term_e_d
termer85717253term_e_r
terminus1037393terminus
termites10313693termites
termly1138433terml__y
termors94712773term_ors
terms75523473term___s
ternes65422903ter_ne_s
terrases82111483terrases
terreens8246533terreens
terrets72913583ter_rets
terriers84210823terriers
terries73425633terrie_s
terrorless1043103terrorless
terseness948403terseness
tersest71713993ter_sest
terylene1144153terylene
terylenes1244933terylenes
thawless1434083thawless
thermels13607763therm_els
thermes126214613therm_e_s
thermoses1447973thermoses
thewless1433923thewless
thornless1243633thornless
thowless1434613thowless
thumbless1643433thumbless
tideless9269083tideless
tieless72512563t_ieless
timeless10239543timeless
tintless8239863tintless
tipless92610063t_ipless
toadless936313toadless
toeless72612393t_oeless
tombless1236783tombless
toneless8610393toneless
toolless836343toolless
topless92511123t_opless
townless1135653townless
toyless10268713t_oyless
treadless1036003treadless
trebles9311443treble_s
tremblers1334483tremblers
trembles1237353tremble_s
tress55423163t_r__ess
trimness1067563trimness
tubeless1037023tubeless
tugless837383t_ugless
tummlers12295703tummlers
tuneless837913tuneless
turtlers8258203turtlers
turtles72914343turtle_s
tuskless1234213tuskless
twigless1293663twigless
veinless11136263veinless
ventless11249053ventless
vermes115019143verm_e_s
vestless11258843vestless
wardless12249303wardless
warless104015103war_less
warmness1337063warmness
wartless11279923wartless
waterless1238013water_less
weariless1234763weariless
webless1237003we_bless
weedless12287963weedless
weldless12285813weldless
wireless11249633wireless
wordless12258843wordless
workless15276803workless
zestless17247433zestless

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.466383457.1
2DLD Change Limit1461622307.86018595.7
3Display Results2302300.0932473.1
 (SQL Overall)1786912308.41921224.7
 
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.