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

161 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
etheric1231178(None) 
aetheric13410161aetheric
enteric9314212enteric
enthetic131110612enthetic
ephebic1646512ephebic
esthetic13119772esthetic
ether84518772ether__
etherify1744442etherify
etherish1448272etherish
etherize2049462etherize
ethers94518412ether_s
ethic101511222eth__ic
ethnic1148852eth_nic
ethylic1546322ethylic
hetaeric1346762hetaeric
spheric14510072spheric
steric8317062st_eric
sthenic1268902sthenic
theriac1239142_theriac
thermic1439332_thermic
thetic11412892_thetic
thoric114314042_thoric
aesthetic1497843aesthetic
aether94213673aether__
aethers103614943aether_s
anthemic15410323anthemic
antherid12611093antherid
aphetic142912853aphetic
aspheric1547983aspheric
asthenic1378633asthenic
atelic8313703at_elic
athletic13118653athletic
atresic9310003atresic
atretic9313923atretic
bathetic1548583bathetic
ceric94023093__ceric
chemic153012093_chemic
choric133515903_choric
cleric10612133_cleric
deuteric1146343deuteric
dimeric12310013dimeric
dineric10310973dineric
ecesic10369223e_cesic
echoic1339043ech_oic
ectomeric1546163ectomeric
edenic9310223e_denic
eerie55228533e__erie
eidetic1039743eidetic
eirenic939003eirenic
either94517423either__
emetic10614453e_metic
empiric1345963empiric
enchoric1547103enchoric
endemic1237893endemic
endermic1356173endermic
enterics10312853enterics
epeiric1145313epeiric
ephebi1345083ephebi_
ephedrin1444703ephedrin
ephori1139603ephori_
epimeric1476763epimeric
epithetic1666413epithetic
erythemic1945193erythemic
esoteric1057593esoteric
esthesia1147503esthesia
esthesis1148463esthesis
esthetics14106963esthetics
etcher113912943etcher__
etchers123411293etcher_s
eterne6311723et_erne
ethene93312923ethe_ne
ethenes103313873ethenes
ethereal1146783ethereal
etherized2247083etherized
etherizer2145983etherizer
etherizes2149313etherizes
ethics11169283eth__ics
ethmoid1345803ethmoid
ethnics1236263eth_nics
ethylenic1753113ethylenic
etic66123953et___ic
eugenic1038603eugenic
euphenic1557203euphenic
euphoric15107043euphoric
euthenics1466283euthenics
eutherian1246893eutherian
exoergic1843683exoergic
exoteric1746803exoteric
exothermic2453393exothermic
flueric1246143flueric
generic101310753generic
hemic125718623__hemic
herdic123112303__herdic
heroic113516923__heroic
homeric14312213homeric
icteric1138023icteric
inherit10312973inherit
ither84617603ither__
lethargic1552153lethargic
lithemic1545593lithemic
mesmeric1445813mesmeric
metameric1546203metameric
meteoric1247303meteoric
methodic1656913methodic
methylic1846003methylic
metric10314673met__ric
neoteric1047853neoteric
nephric1446213neph_ric
nether94014163nether__
numeric1158193numeric
other84219103other__
others93918003other_s
pathetic15410963pathetic
plethoric1644653plethoric
pterin81014153pt_erin
ruthenic1345133ruthenic
sherif122915243_sherif
sphenic1449093sphenic
spherics1537073spherics
stearic939423stearic
stelic8313083st_elic
sthenia1058503sthenia
suberic11312213suberic
telic76019823_t_elic
terbic10410963_t_erbic
terebic1137983terebic
tether93716103tether__
tethered1238493tethered
tethering1339133tethering
tethers103815313tether_s
theatric1346133_theatric
thein85919023_the_in
their85512153_the_ir
theirs94610353_theirs
there87527393_ther_e
therein102310353_therein
theres96525473_theres
theriaca1344153_theriaca
theriacs1336543_theriacs
therian10311293_therian
therm106018023_ther_m
therme115814993_therme
thermit12312013_thermit
therms115914873_therms
theroid11313403_theroid
thesis94913733_thesis
theurgic1442953_theurgic
thoria93012893_thoria
thrice114311573_th_rice
thrip103012183_th_rip
thymic16307423_thymic
toric76529313_t_oric
unheroic1345263unheroic
ureteric1046233uret_eric
uteri51012983ut_eri_
valeric1238303valeric
wether123315393wether__
wethers135214693wether_s
xeric144315663__xeric
ytterbic1542373ytterbic
yttric1145433yt_tric

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.406440125.6
2DLD Change Limit1340271616.61020276.4
3Display Results1611610.0602683.3
 (SQL Overall)1786911617.07625253.1
 
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.