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

135 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
ectatic1131012(None) 
ecstatic1246151ecstatic
acmatic13311702acmatic
astatic9514192astatic
ecstatics1344372ecstatics
ectasis9249612ectasis
ectopic1338162ectopic
enatic8317562e_natic
entastic1048552entastic
erratic9311122erratic
eustatic1047342eustatic
octadic1245712octadic
sciatic11910172sciatic
static83118682_static
acetic10314503ac_etic
acrotic112515543acrotic
actinic111810563actinic
agnatic10310973agnatic
aquatic1838113aquatic
atactic11410083_atactic
atavic11189293_atavic
ataxic15169203_ataxic
attic75618353_at_tic
aviatic1239243aviatic
botanic1159583botanic
cantic103920543_cantic
cattie85221023_cattie
ceramic1339823ceramic
ceratin93020163ceratin
cerotic11415063cerotic
chaotic14310043_chaotic
clastic113013963_clastic
clitic103315053_clitic
coati75624643_coati_
coatis85122603_coatis
comatic131816943comatic
cretic102816283_cretic
critic103616813_critic
cultic105111903_cultic
cyanic133110773_cyanic
cystic132710653_cystic
deltaic1037023delta_ic
ecbolic1345623ecbolic
ecesic10369223ec_esic
echoic1339043ec_hoic
eclair836813ecla_ir
eclamptic1742613eclamptic
eclat7523603eclat__
eclats8313033eclat_s
eclectic1156073eclectic
ecliptic1455333ecliptic
ecotypic1744413ecotypic
ectases92911673ectases
ectopia1147703ectopia
eidetic1039743eidetic
ekistic1377843ekistic
elastic93013393elastic
emetic10614453e_metic
empathic1764663empathic
emphatic1747863emphatic
enclitic1247513enclitic
entail61114343enta_il
entasia73110063entasia
entasis73012573entasis
enteric9314213enteric
enthetic131110613enthetic
entopic1149953entopic
epistatic1346103epistatic
epitaxic1944283epitaxic
ergastic11106623ergastic
ergotic1049723ergotic
eristic9814093eristic
erotic82620273e_rotic
erratics1046983erratics
estate64719763estat_e
estated83715573estated
estates74520183estates
estating92614993estating
esthetic13119773esthetic
etamin81311853e_tamin
etatism9610293e_tatism
etatist7415033e_tatist
ethic101511223e_t_hic
ethnic1148853e_thnic
etic66123953e___tic
eucritic1247133eucritic
eutectic1245503eutectic
exotic153112653e_xotic
fanatic12610703fanatic
geotactic1444083geotactic
hectic132311523hec__tic
hematic141816753hematic
hepatic141712773hepatic
icteric1138033icteric
ictic9311803ic__tic
italic839903_italic
ketotic1348643ketotic
litotic939243litotic
lunatic938753lunatic
mechanic1747613mechanic
mitotic1139713mitotic
necrotic12310053necrotic
nematic111714003nematic
neumatic1258533neumatic
oceanic1146163oceanic
osmatic11179993osmatic
otitic83112683_otitic
pectate112214693pectat_e
pectates122213953pectates
pectic122913873pec__tic
phatic133014413_phatic
piratic11314293piratic
potamic13310853potamic
protatic12314753protatic
psoatic1139303psoatic
ptotic102713373_ptotic
satanic939933satanic
sceptic1337833sceptic
sciatica12106113sciatica
sciatics12117273sciatics
sematic111716883sematic
smectitic1543433smectitic
somatic111916473somatic
statice92614033_statice
statics93314533_statics
statin63921473_statin
tactic10612753__tactic
tectonic1248453tectonic
tektitic1444133tektitic
tetanic9810133tetanic
titanic968553titanic
uratic83016363_uratic
vatic10316423__vatic
venatic12311523venatic
viatic11311453_viatic

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271356.76619808.9
3Display Results1351350.0602250.0
 (SQL Overall)1786911357.24924650.4
 
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.