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

186 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
lactones1031124(None) 
lactone9311411lactone_
lactoses1039831lactoses
acetones10310032_acetones
atones65225772_a_tones
lactases1038522lactases
lactates10311232lactates
lactonic1248052lactonic
lactose969492lactose_
lacunes9159622lac_unes
ladrones92710982ladrones
acetone9310793_acetone_
achenes12313493_achenes
acnes75922623_ac__nes
acnodes1037833_acnodes
actings104512463_actings
actins86321103_actin_s
actioner1048663_actioner
actioners1147733_actioners
actions94218513_action_s
actives12311523_actives
actors81016773_acto_rs
agones75719863_a_gones
alcoves1297883alc_oves
ambones11312683_ambones
ancones93116343_ancones
astonies8815113_astonies
atone56527983_a_tone_
atoned75417543_a_toned
atoner64817193_a_toner
atoners75013963_a_toners
atonies75320953_a_tonies
attunes737823_attunes
axones134614513_a_xones
backbones1947253backbones
bacons104917583bac_on_s
baritones1158953baritones
barytones1455563barytones
batons85519423ba_ton_s
cactuses1237933cactuses
cajones163311333ca_jones
calzones1948763calzones
cantoned111411523cantoned
cantons95221203canton_s
canzones1939153canzones
capstones1347373capstones
cartoned111312833cartoned
cartons94122473carton_s
centones10313663centones
claystones1544393claystones
clones84526563__clones
cones76457423__c_ones
crones84729243__crones
cyclones1537483cyclones
dacrons103211033dacron_s
daemones11209163daemones
daimones11208803daimones
daltons8310403dalton_s
dapsones1138383dapsones
duotones937643duotones
earstones948523earstones
ecotones1039493ecotones
factions133013063faction_s
factoids1446243factoids
factored1436233factored
factories14810123factories
factors12912133facto_rs
factures13129043factures
flacons1238053flac_on_s
flagstones1444003flagstones
flavones1435833fla_vones
galactoses1344263galactoses
gladstones1244663gladstones
halftones1545223halftones
hambones1539673hambones
haptenes133810823haptenes
histones11312803histones
icones84616383_ic_ones
intones7816553_intones
isotones82210443isotones
jackstones2344053jackstones
jaconet16311483jac_onet
jaconets1745613jac_onets
jawbones20134853jawbones
ketones115014503_ketones
laces76141763lac___es
laches116528353lac__hes
laciness102112553lac_iness
lacings105013653lac_ings
laconic1139883lac_onic
laconism1248043lac_onism
lacrosse1044143lacrosse
lacrosses1145323lacrosses
lactams1136953lact_ams
lactase937963lactase_
lactate9312703lactate_
lactated1138873lactated
lacteals1095663lacteals
lacteous1046783lacteous
lacunas9138173lac_unas
lacune8169673lac_une_
lacunose1083793lacunose
ladrone83611883ladrone_
ladrons83813193ladron_s
lagoons839253lagoon_s
lagunes8148523la_gunes
laitances1145613laitances
laities7320343lait_ies
lanes54946793la___nes
lantanas838263lantanas
laptops1166603lapto_ps
lardons83914493lardon_s
lasagnes944783lasagnes
lassoes74613853lasso_es
lastings94214423lastings
latches123320133la_tches
lateens74210553la_teens
latened8711923la_tened
lateness82614073la_teness
latens64620213la_ten_s
latents75214313la_tents
latexes1438313la_texes
lathes95127503la_t_hes
latices9313763la_tices
latinas74416463la_tinas
latinos73613803la_tinos
latkes104715873la_t_kes
latrines8515013latrines
lattens75014673latten_s
lattes65324203la_t_tes
lattices1038383lattices
lattins74115483lattin_s
lauwines1145713lauwines
lawines103313563la_wines
lazybones2342273lazybones
lectins92515003lectin_s
lections102413843lection_s
lectors93415773lecto_rs
lectures101310163lectures
leones64417723l__eones
leptons91910433lepton_s
lictors93212603licto_rs
litotes7311183l_itotes
loadstones1144233loadstones
locoes85516583loc_o_es
lotoses73713653l_otoses
lucarnes1045093lucarnes
lucernes1046363lucernes
machines15312903machines
macons104017243mac_on_s
macrons113514893macron_s
madrones112912283madrones
maltoses1039863maltoses
mucrones1237603mucrones
octanes91111393_octanes
oxytones1844053oxytones
pactions122613503paction_s
padrones112711043padrones
partons94620513parton_s
patines95225773pa_tines
pectines121914683pectines
peptones12311033peptones
platanes102711883pla_tanes
racons84319343rac_on_s
racoons93912433racoon_s
ratines75328583ra_tines
rattons73815323ratton_s
sacatons1038973sacaton_s
saltines82917793saltines
sawbones13126643sawbones
scones84521303_sc_ones
stones65130033__stones
subtones10311383subtones
tacnodes1145003tacnodes
tacrines10310563tacrines
tactions102912423taction_s
tones56048663___tones
tritones83413453tritones
vaccines1536503vaccines
vacuoles1345013vacuoles
wantoned12117223wantoned
wantoner1187563wantoner
wantoners12116683wantoners
wantons103713013wanton_s
xanthones1957023xanthones
zacatons1945703zacaton_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621867.18620339.8
3Display Results1861860.0802325.0
 (SQL Overall)1786911867.68923239.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.