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

135 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
lactoses103982(None) 
lactases1038511lactases
lactones10311231lactones
lactose969481lactose_
cactuses1237932cactuses
galactoses1344252galactoses
lacrosse1044112lacrosse
lacrosses1145302lacrosses
lactase937952lactase_
lactates10311222lactates
lactone9311402lactone_
lotoses73713642l_otoses
maltoses1039852maltoses
abioses9311493_abioses
accosts11107993_accosts
accuses114112193_accuses
acetones10310033_acetones
acetose938843_acetose_
acidoses1136773_acidoses
acnodes1037833_acnodes
across8312643_acros_s
actives12311523_actives
actors81016763_acto_rs
actress948533_actress
aftosas10147153_aftosas
alcoves1297873alc_oves
aldoses8311203_aldoses
amitoses1039053amitoses
apposes11511473_apposes
arkoses113910833_arkoses
atones65225773_a_tones
baptises1238923baptises
bathoses13310463bathoses
cabooses1237863cabooses
calloses10313393calloses
caseoses1039293caseoses
choses115825133__choses
closes85425593__closes
coses76949493__c_oses
cycloses1538183cycloses
ectases92911673_ectases
elastases946113elastases
encloses10911053encloses
factoids1446243factoids
factored1436223factored
factories14810103factories
factors12912123facto_rs
factures13129023factures
fatsoes10379423fa_tsoes
flatuses1137173fla_tuses
fructoses1444253fructoses
fucoses12148303fuc_oses
galactose1243953galactose_
glacises1138503glac_ises
glucoses1145333gluc_oses
halitoses1246603halitoses
haploses1338853haploses
heptoses1338373heptoses
ictuses938303_ictuses
incloses101610533incloses
ketoses114912873_ketoses
kurtoses12105623kurtoses
laceless10239853laceless
laces76141763lac___es
laches116528343lac__hes
laciness102112553laciness
lactams1136953lact_ams
lactate9312693lactate_
lactated1138863lactated
lacteals1095663lacteals
lacteous1046773lacteous
lactonic1248043lactonic
lacunes9159623lac_unes
lacunose1083793lacunose_
ladrones92710973ladrones
laicises1039573laicises
laities7320343lait_ies
lampases1267293lampases
lanose6313593la_nose_
lapises93513463la_pises
lapses85217693la__pses
laptops1166603lapto_ps
lases54944763la___ses
lasses64827593la__sses
lassoes74613853lasso_es
latches123320123la_tches
latests73910313la_tests
latexes1438313la_texes
lathes95127493la_t_hes
latices9313763la_tices
latkes104715873la_t_kes
latosol745283la_tosol
latosols845003la_tosols
lattes65324203la_t_tes
lattices1038383lattices
lectors93415763lecto_rs
lectures101310153lectures
leukoses1244613leukoses
licenses10118923licenses
lictors93212593licto_rs
litotes7311183l_itotes
locoes85516583loc_o_es
looses67328243l__ooses
lordoses937143lordoses
loses56742013l___oses
lotuses74011253l_otuses
maltases1039693maltases
maltose939783maltose_
mannoses1039083mannoses
mantises10317923mantises
mitoses9312183_mitoses
mycoses1437733myc_oses
narcoses103910543narcoses
necroses10310563necroses
ostoses71213553_ostoses
papooses1248053papooses
parcloses1347963parcloses
pastises103616053pastises
pathoses13412773pathoses
pectases122411193pectases
pentoses10312893pentoses
practises1349623practises
ptoses83514673__ptoses
pycnoses1554973pycnoses
rachises131412413rachises
rictuses1037563rictuses
saroses73619333sa_roses
sucroses1039933sucroses
sycoses1249133syc_oses
tacnodes1145003tacnodes
tactless10288463tactless
uncloses10910943uncloses
vacuoles1345013vacuoles
vamooses1345523vamooses
vamoses1239143va_moses

Search took 9 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.436409841.7
2DLD Change Limit1461621357.70318974.7
3Display Results1351350.0462934.8
 (SQL Overall)1786911358.18521831.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.