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

162 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
acetone931079(None) 
acetones10310031acetones
acetose938841acetose
acerose9310892acerose
acetate92514752acetate
acetin8314692acetin_
acetins9313172acetins
acetonic1238732acetonic
acetous9410362acetous
anemone9119452anemone
atone56527982a__tone
cetane8315282_cetane
ecotone938582ecotone
ketone105014532_ketone
lactone9311392lac_tone
abalone938903abalone
acarine9316003acarine
acerate92818913acerate
acerola947823acerola
acerous9513333acerous
aceta74017353acet__a
acetal84314903acet_al
acetals93411353acetals
acetated112010683acetated
acetates102013063acetates
acetic10314503acet_ic
acetify1545003acetify
acetoxyl2041763acetoxyl
acetum1038463acet_um
acetyl11396553acet_yl
acetylene1452693acetylene
acetyls12285353acetyls
achene11313813ac_hene
achiote1239213achiote
acinose938583acinose
acne66625873ac___ne
acnode938203ac_node
actin74922553ac_tin_
acting95920983ac_ting
actins86321103ac_tins
action84719683action_
actioner1048663actioner
actions94218513actions
active11313743ac_tive
actor71116073ac_to_r
actors81016763ac_tors
acutance1246303acutance
acute74720363acut__e
adenine8311213adenine
aedine73218393a_edine
aeon45634613a_e_on_
aeons57624653a_e_ons
aerobe8412403a_erobe
agelong934983agelong
agene65621583age__ne
agone65924553a__gone
akene95818663ake__ne
aleurone846113aleurone
alexine142410543alexine
alone55732963a__lone
amarone9311203amarone
amidone10349313amidone
ancone83916953a_ncone
anemones10249473anemones
anethole1146253anethole
anyone94612733a_nyone
aquatone1744913aquatone
arene55329413are__ne
arenose7311373arenose
areole61017283are_ole
arete56031353aret__e
astony9510523a_stony
atoned75417543a__toned
atoner64817193a__toner
atones65225773a__tones
atony87218853a__tony
attune637983a_ttune
awesome1245573awesome
axone125918473a__xone
backbone1847443backbone
baritone1058643baritone
barytone1356023barytone
begone9512133_begone
beton76022063_beton_
betons84919553_betons
betony114211583_betony
cabezone2144433cabezone
calzone1848623calzone
canton85722993canton_
cantoned111411523cantoned
cantons95221203cantons
canzone1858813canzone
capstone1237653capstone
carton84522663carton_
cartoned111312833cartoned
cartons94122473cartons
cenote83715843_cenote
centones10313663_centones
cestode1037963_cestode
cetanes9315133_cetanes
cete64934783_cet__e
cicerone1247523cicerone
citole8311503_citole
clone75728163_c_lone
colone85425003_colone
cone67256963_c__one
cretonne1044363cretonne
crone75231333_c_rone
cyton101511463_cyton_
cytons111710183_cytons
debone93714783_debone
depone93616553_depone
duotone836893duotone
earstone848603earstone
ecotones1039493ecotones
emetine9712943emetine
eyestone1146533eyestone
facete115014833facet__e
facetiae1346213facetiae
faceting1438783faceting
halftone1445153halftone
hexone16289233_hexone
histone10312843histone
intone61115433_intone
isotone7239983isotone
jackstone2244383jackstone
jeton124815403_jeton_
jetons134512613_jetons
ketene106613003_ketene
ketones115014503_ketones
ketose105711813_ketose
lactones10311223lac_tones
lactose969473lac_tose
leone55018823_le_one
macedoine1443553macedoine
metope10611123_metope
ochone11311293oc_hone
octane81411633oc_tane
overtone111012573overtone
oxytone1744203oxytone
panettone1144343panettone
peptone11310763peptone
racemose1245003racemose
redone74820053_redone
retene69224273_retene
retine66237333_retine
retore67630773_retore
retune69121953_retune
rezone153814783_rezone
sacaton938993sacaton_
sacatons1038973sacatons
scene77220573sce__ne
scone74621833sc__one
seton55223543_seton_
setons64620173_setons
setose65114773_setose
stone55431183__stone
subtone9310343subtone
tone46953743___tone
tritone73613883tritone
zacaton1845633zacaton_
zacatons1945703zacatons

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.406440125.6
2DLD Change Limit1340271626.90619407.3
3Display Results1621620.0463521.7
 (SQL Overall)1786911627.35824285.3
 
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.