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

144 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
acetyl1139655(None) 
acetal84314901acetal
acetyls12285351acetyls
aceta74017352acet_a
acetals93411352acetals
acetic10314502acetic
acetin8314692acetin
acetoxyl2041762acetoxyl
acetum1038462acetum
acetylic1543572acetylic
acyl95314292ac__yl
adenyl1035022adenyl
biacetyl1542472biacetyl
dactyl1234982dac_tyl
diacetyl1452912diacetyl
octyl10136062oc_tyl
abet610547943abet__
abets75621673abet_s
abettal946073abettal
ace59656833ace___
aced79540883ace__d
acedia9310393acedia
acerb9312763ace_rb
acerola947823acerola
aces67645093ace__s
acetate92514753acetate
acetify1545003acetify
acetins9313173acetins
acetone9310793acetone
acetose938843acetose
acetous9410353acetous
acetoxyls2151913acetoxyls
acetylate1444213acetylate
acetylene1452683acetylene
achy126316093ac_hy_
acidly125211793acidly
acidy117214893acidy_
act59557843ac_t__
acta69524803ac_t_a
acted88521733ac_ted
actin74922553ac_tin
actor71116073ac_tor
acts66929863ac_t_s
actual8311023actual
acuity1139373acuity_
acute74720363acut_e
acutely1246123acutely
acuter84412863acuter
acutes83917723acutes
acyls104211523ac__yls
adenyls1143923adenyls
adeptly1344183adeptly
aecial84817313aecial
aery77231683a_ery_
agedly1136463agedly
alanyl955483alanyl
alertly1046793alertly
alkyl12518043a_lkyl
allyl85310543a_llyl
alphyl1484083alphyl
amatol838683amatol
amity10416093amity_
amyl95515093a__myl
anethol1045383anethol
aortal65217513aortal
apery106517903apery_
apetaly1237253apetaly
aptly105111813a_ptly
areal55928733are_al
arete56031353aret_e
aretes64425353aretes
artal55525473a_rtal
artel56122743a_rtel
arty77531313a_rty_
aryl75922343a__ryl
ascetic11310063ascetic
auntly95211063auntly
aunty85919813aunty_
axel115222073axe__l
beryl101211673_beryl
betel74419903_betel
biacetyls1651923biacetyls
butyl1089103_butyl
cacodyl1543213cacodyl
caecal103713733caecal
cantal84122033cantal
canty105226803canty_
cartel85022533cartel
catty104520413catty_
cecal94619113_cecal
ceil65725063_ce_il
cel56040553_ce__l
cell65031723_ce_ll
cental84420963_cental
ceorl7410913_ceorl
cete64934783_cet_e
cetes75731103_cetes
city95122623_city_
cresyl1135133cresyl
dactyli1343603dac_tyli
dactyls1333913dac_tyls
diacetyls1542253diacetyls
dicotyl1344403dicotyl
ethyl1136513__ethyl
facet106038523facet__
facete115014833facet_e
faceted13509563faceted
facetely1643853facetely
facets116316653facet_s
fetal85623373_fetal
foetal9311883foetal
gaiety10119373gaiety_
gametal1037603gametal
gayety13116383gayety_
hexyl1844463_hexyl
hyetal1236543hyetal
ketol95414003_ketol
lacey105820913lace_y_
lacteal966813lacteal
meetly1138673meetly
metal75427383_metal
methyl1436403_methyl
metol75917813_metol
nicety1138433nicety_
octal71214723oc_tal
octyls11135323oc_tyls
pacey126720283pace_y_
pentyl1138813pentyl
petal76526893_petal
phenyl1435323phenyl
piety105817303piety_
protyl11308213protyl
rackety16499113rackety_
rectal84418133rectal
safety12206913safety_
setal56430903_setal
suety85318493suety_
tacet75840023tacet__
tacitly1236223tacitly
tapetal938273tapetal
tectal83713253tectal
tetryl935693_tetryl
trotyl9236673trotyl
wetly114511713_wetly

Search took 10 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.1401276364.3
2DLD Change Limit1127161449.06312436.9
3Display Results1441440.0463130.4
 (SQL Overall)1786911449.24919320.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.