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

219 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
ethyls123590(None) 
ethyl1136511ethyl_
methyls1535451methyls
bethels1238532bethels
ethers94518412ethers
ethics11169282ethics
ethinyls1442872ethinyls
ethnos947052ethnos
ethos85514192eth_os
ethoxyls2142212ethoxyls
eths76619522eth__s
ethylic1546322ethylic
ethyne12407152ethyne
ethynes13377572ethynes
ethynyls1741872ethynyls
lethals1038112lethals
methyl1436402methyl_
tetryls1034642tetryls
acetyls12285353acet_yls
acyls104211523_acyls
aethers103614943aethers
alkyls13465723alkyls
allyls9437273allyls
alphyls15113953alphyls
amyls104512693_amyls
anethols1145843anethols
aryls87015813_aryls
atolls65511353atolls
benzyls2133673benzyls
beryls11107883beryls
betels84515063bet_els
bethel1169643bethel_
beths105519223beth__s
bimethyls1951713bimethyls
buhls105111803buh_ls
butyls1176753butyls
chyle134913483_chyle
chyles144813283_chyles
dahls95012283dah_ls
details84214043details
dhals95415443_dhals
dimethyls1851603dimethyls
earls56127513e_arls
easels65914553easels
eches106322163ech_es
echoes114715523echoes
echos105216463ech_os
ecthyma1752613ecthyma
edhs86212103edh__s
eels46536743e__els
ells46431353e__lls
els37645723e___ls
emails84412343emails
emmys12446023emmy_s
emyds1144923e_myds
enhalo987563enhalo
enhalos1087533enhalos
enols54718403e_nols
enrols61213383enrols
entails7912823entails
enthrals11278903enthrals
entoils7810733entoils
enzyms2063433enzyms
ephahs1435503ephahs
ephas10311543eph_as
ephods1238363ephods
ephors11311403ephors
equals1538703equals
ervils948773ervils
etapes85415293etapes
etas46432273et__as
etchers123411293etchers
etches114217763etches
eth66630983eth___
ethane94613243ethane
ethanes103713513ethanes
ethanols1144333ethanols
ethene93312923ethene
ethenes103313873ethenes
ether84518773eth_er
ethic101511223eth_ic
ethicals1345533ethicals
ethinyl1343433ethinyl_
ethion938813ethion
ethions1038483ethions
ethnic1148853ethnic
ethnics1236263ethnics
ethoses10311763ethoses
ethoxy1933923ethoxy
ethoxyl2042353ethoxyl_
ethylate1446223ethylate
ethylates1545943ethylates
ethylene1444233ethylene
ethylenes1544223ethylenes
ethynyl1642123ethynyl
etnas54713933et_nas
etoile6312263etoile
etoiles7411293etoiles
etudes73811603etudes
etuis54013133et_uis
etwees9348793etwees
etyma1036583et_yma
evils84114263e_vils
excels1536663excels
exhale1636873exhale
exhales1737143exhales
expels1547173expels
extolls1444603extolls
extols1337683extols
eyas76427433e__yas
eyes75837883e__yes
fetials103711743fetials
ghyll1246323_ghyll
ghylls1335143_ghylls
heths116317783heth__s
hexyls1933443hexyls
hols76946293__hols
hyla106716513__hyla
hylas114815903__hylas
hyps125418413__hyps
idyls9498803_idyls
ketols104210763ket_ols
kohls12437803koh_ls
lethal939803lethal_
lethes94818083leth_es
menthols1347043menthols
metals84520893met_als
methods1338893methods
meths105320233meth__s
methylal1644273methylal
methylals1743683methylals
methylase1744243methylase
methylic1846013methylic
metols84115773met_ols
mohels115011333mohels
nihils937573nihils
nonyls957853nonyls
octyls11135323octyls
odyls9428653_odyls
others93918003others
pentyls1236523pentyls
petals84719813pet_als
petrels9279373petrels
petrols92913083petrols
phyla13469183_phyla
phyle134111153_phyle
retails74718973retails
retells73211523retells
retools73411023retools
schuls11299853schuls
shuls85319713_shuls
shyly144811573_shyly
sibyls1135303sibyls
stalls64019933stalls
stays86022023stay_s
steals64020063steals
steels64117983steels
stills64118573stills
stools65117023stools
stulls63912983stulls
styes86316523st_yes
style85519363st_yle
styles94418653st_yles
styli83911173st_yli
stylus9397463st_ylus
taels56822073_taels
tails55634193_tails
talls55133433_talls
teals56234133_teals
teels55726373_teels
tells55828943_tells
tellys9348843tellys
tels46841693_t_els
tepals85415043tepals
tethers103815313tethers
teths85418513teth__s
tetryl935693tetryl_
thaws116515463_thaws
thens85921833_thens
thews117416193_thews
thill85918733_thill
thills95515383_thills
thins85826333_thins
thiols95112763_thiols
thirls95012063_thirls
this76027383_th_is
thole85620843_thole
tholes94919783_tholes
tholos94213003_tholos
thous86017263_thous
thuds95110133_thuds
thugs95611993_thugs
thurls9418713_thurls
thus76721473_th_us
thuyas1234773_thuyas
thy97022913_thy__
thyme134612473_thyme
thymes144810743_thymes
thymi13418633_thymi
thymols1533843_thymols
thymus14324743_thymus
thymy16437923_thymy
thyrse1235133_thyrse
thyrsi1234453_thyrsi
tills54631713_tills
tils45739613_t_ils
tirls54519803_tirls
toils54527493_toils
tolls54728433_tolls
tolyls9436963tolyls
tools55325243_tools
toyos87519143_toyos
toys78036343_toy_s
tyes76433373_t_yes
vinyls12467003vinyls
wethers135214693wethers
whys137011663_why_s
xylyls1931833xylyls
zephyrs2441943zephyrs

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162194.61024450.3
3Display Results2192190.0762881.6
 (SQL Overall)1786912195.06235300.5
 
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.