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

255 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
etalons73907(None) 
etalon648971etalon_
talons64019441_talons
etamins91511832etamins
ethions1038482ethions
etymons1244152etymons
halons95720712_halons
petalous1058972petalous
salons63823692_salons
stolons73410242stolons
talions7314112_talions
talon55824112_talon_
tauons63412672_tauons
taxons134211502_taxons
teflons1036542teflons
abalone938903abalone
abalones1038753abalones
aeons57624653__aeons
agons66423783__agons
alans55636173__alans
aloes54933673__aloes
aloins65022203__aloins
alone55732963__alone
along65419493__along
amazons1836653amazons
analogs82810453analogs
apetalous1144583apetalous
atamans9710433atamans
axons125517933__axons
azlons154110423_azlons
azons146518253__azons
bacons104917583_bacons
ballons93916963ballons
barons85025383_barons
batons85519423_batons
beacons11410733beacons
belons84119413_belons
betatrons1145083betatrons
betons84919553bet__ons
billons93013363billons
blazons1836163blazons
calos74431903_calo_s
canons85522063_canons
capons104119503_capons
cataloes10311653cataloes
catalogs1148033catalogs
catalos9414163catalo_s
cations94524143cations
catlins93818843catlins
celadons1137003celadons
chalone12312103chalone
chalones13312173chalones
claxons1635803claxons
clons75228133__clons
colons86028683_colons
cratons94316033cratons
crayons12439233crayons
daltons8310403_daltons
deacons10310393deacons
decagons1235893decagons
decalogs1245633decalogs
detains83716093deta_ins
dialogs938103dialogs
doblons1037043doblons
dragons938383dragons
earns55927563e_a_rns
ebons74316093e__bons
echelons1385543echelons
eftsoons1142613eftsoons
eidolons944983eidolons
eikons1038503e_ikons
elains64919853ela_ins
elans55527753e__lans
elations83719123elations
elevons1067573elevons
eloins65419383e__loins
employs1455523employs
emulous937343emulous
enamors939123enamors
enations83316903enations
endlong934823endlong
enhaloes1197343enhaloes
enhalos1087533enhalo_s
enterons8314153enterons
eons46638713e___ons
epigons1048183epigons
epilogs1076583epilogs
epsilons1044223epsilons
erasions8310983erasions
erelong835593erelong
escalops1244673escalops
estragons1044653estragons
etamin81311853etamin_
etamine91313073etamine
etamines101611813etamines
etapes85415293eta_pes
etas46432273eta___s
ethanols1144333ethanols
ethion938813ethion_
ethnos947053ethno_s
ethos85514193et_ho_s
etymon1134693etymon_
evasions1136543evasions
exalts13328313exal_ts
examens1637193examens
exons125813343e__xons
falcons1239123_falcons
fanons96115213_fanons
felons93615763_felons
fetations12511383fetations
flacons1238053flacons
flagons1137973flagons
gallons83015953gallons
galops94712623_galops
haloes94623863_haloes
halon86124863_halon_
halos85230253_halo_s
heptagons1543453heptagons
hexagons1943943hexagons
hyalins13229273hyalins
italics936993italics
jalops15329593_jalops
jealous1438093jealous
jetons134512613jet__ons
jettons1437273jet_tons
kalong1177703_kalong
kalongs1255443_kalongs
kaons95014853_ka_ons
kations114013663kations
klaxons1833263klaxons
macons104017243_macons
masons83916513_masons
matrons93517633matrons
megalops1356123megalops
megatons11279703megatons
melons84117713_melons
menazons1945733menazons
merlons93311273merlons
metaling111613723metaling
metals84520883metal__s
metazoans2044473metazoans
methadons1544423methadons
metopons12107023metopons
nations74720563nations
natrons73215663natrons
negatons9299273negatons
nylons9267973_nylons
octagons1144493octagons
orlons6411013_orlons
paeons83915523_paeons
patrons93818103patrons
pedalos10329703pedalo_s
pentagons1246153pentagons
petaline10314883petaline
petalody1443873petalody
petaloid1148753petaloid
petals84719813petal__s
petasos948603petaso_s
ptyalins1364693ptyalins
pylons113011243_pylons
racons84319343_racons
radons74118533_radons
rations74123433rations
ratlins73615583ratlins
ratoons73815473ratoons
rattons73815323rattons
rayons94113343_rayons
reasons72514943reasons
retailors9285363retailors
retains74522253reta_ins
salmons93713263_salmons
salols64017873_salols
salon55228553_salon_
saloons74415323_saloons
seasons72614233seasons
sepalous1047523sepalous
setons64620173set__ons
settlors8255013settlors
setulous846913setulous
shaloms1288983shaloms
slaloms9106543slaloms
solons65120023_solons
stains64923653sta_ins
stalags838643stalags
stales65538293stal_es
staling83925423staling
stalks104614553stal_ks
stallions946073stallions
stalls64019933stal_ls
stamens93411483stamens
stanols739733stanols
statins73719773statins
stations82415223stations
stators73915583stators
stolon64112073stolon_
taboos83815433_taboos
tabors84517113_tabors
tabuns8489223_tabuns
tacos77023553_taco_s
tailors73212393_tailors
tains54936323_ta_ins
takins105117403_takins
talars66021683_talars
talas55935893_tal_as
talcous939483_talcous
talcs74817183_tal_cs
talent6323323_talent
talents7312013_talents
talers64628143_talers
tales55451373_tal_es
talion6317713_talion_
talks94322693_tal_ks
tallis63319963_tallis
tallols73311363_tallols
tallows103313743_tallows
talls55133433_tal_ls
taloned8310223_taloned
taluks10418283_taluks
talus55423263_tal_us
tampons112711563_tampons
tans46154823_ta__ns
taos45541003_ta_o_s
tarns56433953_ta_rns
tarocs84615663_tarocs
taroks106115283_taroks
taros55640823_taro_s
tarots66422993_tarots
tarpons92612213_tarpons
tauon54816583_tauon_
taxols13328633_taxols
taxon124414663_taxon_
teals56234133teal__s
teapots939053teapots
teapoys1235963teapoys
teflon937453teflon_
telos55424523_telo_s
telsons739223telsons
tendons8311473tendons
tenons62916603_tenons
testons7313563testons
tetragons1045353tetragons
tiglons837343tiglons
tigons74112263_tigons
tolans64319273_tolans
tons46553053_t__ons
toons55027533_t_oons
toyons95512133_toyons
valors93413773_valors
wagons103911213_wagons
weakons14287803weakons
weapons12278603weapons
weasons102310583weasons
yapons114411773_yapons
zealots1636763zealots
zealous1637813zealous

Search took 7 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.390458182.1
2DLD Change Limit1340272555.98322401.3
3Display Results2552550.0962656.3
 (SQL Overall)1786912556.46927622.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.