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

289 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
etyma103658(None) 
atma68121772at_ma
cyma116715842_cyma
ecthyma1752602ecthyma
edema8610552edema
enema7612742enema
eta35834192et__a
etna46415262et_na
etymon1134692etymon
eyra76217552e_yra
stoma75918272stoma
stymy13358292stymy
tryma1037222tryma
aboma91114603aboma
adyta936853adyta
agama85815573agama
agma77623263_agma
alma66333023_alma
ama510853303__ama
anima74620073anima
aroma71220143aroma
asthma11126563asthma
asyla839333asyla
ataman81013063ataman
atman75520143at_man
atmas75721013at_mas
atom67824523atom_
atoms76817563atoms
atomy107415193atomy
atria56022333atria
bayman133712703bayman
bema85825253_bema
beta66234133bet__a
betime105914833betime
betta74916843bet_ta
bima86723823_bima
boyla102912363boyla
cayman133613213cayman
chyme156512503chyme
coma87134853_coma
comma114514793comma
cymae126713013_cymae
cymar125711263_cymar
cymas126417883_cymas
cyme119420373_cyme
derma84918513derma
dogma96112463dogma
dolma86214173dolma
douma85817703douma
drama85117413drama
duma75524453_duma
ectypal1442773ectypal
ectype1334283ectype
eczema1973073eczema
edemas9310503edemas
elemi7312503elemi
elm57531743e_lm_
elms67322703e_lms
elmy95616793e_lmy
elytra934893elytra
em49445153e__m_
eme55837183e__me
emmy116013243e_mmy
emmys12446023emmys
empyema1642643empyema
ems56435493e__ms
emu55929983e__mu
emyd1047073emy_d
emyde1136383emyde
emyds1144923emyds
enemas8812003enemas
enemy1059993enemy
enigma935633enigma
entera64216833entera
entia5318203entia
entomb1037363entomb
enzym1964393enzym_
enzyme2054343enzyme
enzyms2063433enzyms
epha9310053e_pha
era35741503e__ra
erica7316543erica
et26964193et___
etamin81311853etamin
etape74413703etape
etas46432273et_as
etch95419143et_ch
eth66630983et__h
ether84518773ether
ethic101511223ethic
ethos85514193ethos
eths76619523et_hs
ethyl1136513ethyl
ethyls1235903ethyls
ethyne12407153ethyne
etic66123953et_ic
etnas54713933etnas
etude63612303etude
etui45416233et_ui
etuis54013133etuis
etwee84115333etwee
etymons1244153etymons
exam132514623exam_
exams14199083exams
extra1239003extra
extrema1675013extrema
eyas76427433e_yas
eye65539773e_y_e
eyed86623233e_yed
eyen76223663e_yen
eyer76127283e_yer
eyes75837883e_yes
eyne76322463e_yne
eyras84715923e_yras
eyre75525253e_yre
eyry106315883e_yry
feta76528903fet__a
flyman14326423flyman
gama77035513_gama
gamma106116103gamma
gemma106311773gemma
geta56627443get__a
grama85620283grama
gumma105313103gumma
gym95719063_gym_
gyms107514593_gyms
halma108219253halma
herma105318883herma
hetman112510603het_man
hoya107418373hoy_a
hyla106716513_hyla
hymn12311313_hymn
intima81910013intima
item65620383item_
items7499613items
jetsam15116323jetsam
karma113415003karma
kerygma1741963kerygma
korma115913073korma
lama66635293_lama
layman113511303layman
lemma94811033lemma
lima65734133_lima
llama799893llama
louma76213633louma
luma65527523_luma
lytta888063lytta
ma410060653___ma
magma104513573magma
mama86231583_mama
mamma86317913mamma
maya95824583may_a
meta65932413met__a
metepa1066013metepa
metump1235713metump
momma85111053momma
myna95815293_myna
myoma1239273myoma
nema65522523_nema
noma67529463_noma
oedema936573oedema
optima10106533optima
phyla13469183phyla
pima85428653_pima
prima95019343prima
puma85424123_puma
pya87023753_py_a
raya75224823ray_a
regma84612333regma
reteam83214533reteam
retem74221953retem_
retems83914573retems
retia55326113ret_ia
retime85321803retime
retina65023383retina
retype11399143retype
rhyme13479553rhyme
rhyta1135083rhyta
rya67622013_ry_a
seta45637313set__a
sigma84513823sigma
sima64730783_sima
skyman1535313skyman
soma65635293_soma
soya75724433soy_a
stamp95217363stamp
steam76322923steam
stela54019043stela
stem610628243stem_
stemma10328133stemma
stems75219953stems
stigma9226753stigma
stime76521793stime
stimy105114733stimy
stoa45425913st_oa
stomal85213313stomal
stomas84816323stomas
stomp95616663stomp
stria55723203stria
stroma84313073stroma
struma84313273struma
stum65526013stum_
stump94616463stump
stums75320083stums
stupa74112313stupa
sty66227313sty__
stye76218973sty_e
styed95815483styed
styes86316523styes
stylar9358113stylar
style85519363style
styli83911173styli
stymie1137623stymie
styrax1675243styrax
summa94713313summa
ta211662453_t__a
taka87623593_taka
tala45938053_tala
tam58663423_tam_
tamal73522613_tamal
tame66343663_tame
tamp86133003_tamp
tams67247933_tams
tapa65129143_tapa
taxa116820093_taxa
tea37353323_t_ea
team66238653team_
teams75726513teams
tecta74215523tecta
teem66132603teem_
teems76019783teems
tegua6109563tegua
tela45532973_tela
telia55821143telia
temp85323333_temp
tenia55324483tenia
tepa66021683_tepa
terga63315643terga
term66233153term_
terms75523473terms
terra54419653terra
tesla55612603tesla
testa54822043testa
tetra53417953tetra
thyme134612473thyme
thymi13418623thymi
thymy16437923thymy
time66235013_time
toea46732333_toea
toga57027413_toga
tola45236333_tola
tom514358053_tom_
toman75724053_toman
tomb89029653_tomb
tome67543193_tome
toms68343493_toms
tora47545993_tora
tram67034553_tram
tuba65422363_tuba
tufa75016613_tufa
tump85927033_tump
tuna45127843_tuna
twa67721643_t_wa
tye65837443_ty_e
tyee75131423_tyee
tyer75323393_tyer
tyes76433373_tyes
tyin76424003_tyin
tyke115720503_tyke
tymbal13236823_tymbal
tympan13257013_tympan
tyne76325053_tyne
typal105311153_typal
type96223743_type
typo95418123_typo
typp115812783_typp
typy126013043_typy
tyre75428253_tyre
tyro76622363_tyro
ulama7711473ulama
ulema7109713ulema
ultima836313ultima
uta37425583ut__a
ya510251503__y_a
yam87448993__yam
yea66445753__yea
zeta135121643zet__a
zeugma1842713zeugma
zyme1819114943_zyme

Search took 4 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 Filter178691836670.1101624463.6
2DLD Change Limit836672893.75022311.2
3Display Results2892890.0803612.5
 (SQL Overall)1786912893.94045353.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.