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

131 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
acetose93884(None) 
acerose9310891acerose
acetone9310791acetone
acetate92514752acetate
acetones10310032acetones
acetous9410362acetous
acinose938572acinose
arenose7311372arenose
ketose105711812_ketose
lactose969472lac_tose
racemose1245002racemose
setose65114772_setose
abets75621673abet_s_
acarbose1244683acarbose
acaulose1044383acaulose
accost101112263ac_cost
accuse103411033ac_cuse
acerate92818913acerate
acerola947823acerola
acerous9513333acerous
aces67645093ace__s_
aceta74017353acet__a
acetal84314903acet_al
acetals93411353acetals
acetated112010683acetated
acetates102013063acetates
acetic10314503acet_ic
acetify1545003acetify
acetin8314693acet_in
acetins9313173acetins
acetonic1238733acetonic
acetoxyl2041763acetoxyl
acetum1038463acet_um
acetyl11396553acet_yl
acetyls12285353acetyls
achiote1239213achiote
acidoses1136773acidoses
acnode938193ac_node
across8312643ac_ross
active11313743ac_tive
actor71116073ac_to_r
actors81016763ac_tors
acts66929863ac_t_s_
acute74720363acut__e
acutes83917723acutes_
acutest94410603acutest
adenoses947903adenoses
adipose1036653adipose
aerobe8412403a_erobe
aftosa996573a_ftosa
agarose838673agarose
aldose7311093a_ldose
alehouse1146123alehouse
altos55822953a_ltos_
amitoses1039053amitoses
amylose1237193amylose
anatase738943anatase
anemone9119453anemone
anemoses10159433anemoses
anethole1146253anethole
appose10411993a_ppose
areole61017283are_ole
arete56031353aret__e
aretes64425353aretes_
ariose64818723a_riose
arkose104911343a_rkose
arose55832083a__rose
athetoses1244973athetoses
atone56527983a__tone
autos56523323a_utos_
averse95811183ave_rse
awesome1245573awesome
azotise1637073azotise
betise85616273_betise
caboose1138273caboose
callose9313663callose
cantos84826973cantos_
caseose939163caseose
cease75227653_ce_ase
cenote83715843_cenote
cense75121403_ce_nse
centos85920463_centos_
cerise84822043_cerise
ceros74726073_ceros_
ceruse83914523_ceruse
cestode1037963_cestode
cestos84718093_cestos_
cetane8315283_cetane
cete64934783_cet__e
cetes75731103_cetes_
choose115116143_choose
chose105925403_c_hose
citole8311503_citole
close76425223_c_lose
comose105016843_comose
cymose13429653_cymose
depose94215763_depose
ecotone938583ecotone
erose55727273__erose
facete115014833facet__e
facetiae1346213facetiae
facets116316653facet_s_
gjetost1543223gjetost
heptose1237493heptose
hexose16267843_hexose
icehouse1344763icehouse
ketone105014533_ketone
ketoses114912873_ketoses
lactase937953lac_tase
lactone9311393lac_tone
lactoses1039813lac_toses
lacunose1083793lacunose
maltose939783maltose
metope10611123_metope
necrose939723necrose
operose939433operose
pectase112410363pectase
pentose9311593pentose
poetise9314043poetise
racehorse1443763racehorse
rechose121312043rechose
rectos85718783rectos_
repose84121413_repose
rerose63320843_rerose
retore67630763_retore
retuse66617223_retuse
scapose1147753scapose
sclerose1046213sclerose
tsetse664693tset_se
venose9310843_venose
vetoes92914083_vetoes

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.1561145455.1
2DLD Change Limit1340271316.98319193.3
3Display Results1311310.0333969.7
 (SQL Overall)1786911317.17224915.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.