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

165 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
lactose96949(None) 
lactase937961lactase
lactone9311411lactone
lactoses1039831lactoses
acetose938842_acetose
galactose1243962galactose
lacrosse1044132lacrosse
lactases1038522lactases
lactate9312702lactate
lactones10311242lactones
lacunose1083792lacunose
lanose6313592la_nose
maltose939792maltose
accost101112263_accost
accuse103411033_accuse
acerose9310903_acerose
acetone9310793_acetone
acinose938583_acinose
acnode938203_acnode
across8312643_across
active11313743_active
actor71116083_acto_r
actors81016773_actors
acts66929863_act_s_
aftosa996573_aftosa
alcove1178093alc_ove
aldose7311093_aldose
altos55822953_altos_
appose10411993_appose
ariose64818723_ariose
arkose104911343_arkose
arose55832083_a_rose
atone56527983_a_tone
autos56523323_autos_
baptise1139553baptise
caboose1138273caboose
cacaos104616183cacaos_
cactoid12311033cactoid
cactus104912233cactus_
cactuses1237933cactuses
callose9313663callose
cantos84826973cantos_
caseose939163caseose
chose105925403__chose
close76425223__close
datos65222783da_tos_
dattos74311903dattos_
elastase845643elastase
enclose9910003enclose
factoid1338693factoid
factor11911463facto_r
factored1436233factored
factors12912133factors
factory15108353factory
facts107021893fact_s_
facture12108933facture
floccose1543133floccose
fructose1343663fructose
fucose11167683fuc_ose
galactoses1344263galactoses
glucose1045123gluc_ose
heptose1237493heptose
inclose9910223inclose
jatos125116823ja_tos_
jocose1537103joc_ose
ketose105711813_ketose
lace66848473lac___e
lacers85225253lacers_
laces76141763lac_es_
laches116528353laches_
laciest93819043laciest
lacks116129203lac_ks_
lacrosses1145323lacrosses
lacs66942483lac__s_
lactam10310943lact_am
lactams1136953lactams
lactary1237853lactary
lactated1138873lactated
lactates10311233lactates
lacteal966823lacteal
lactean956483lactean
lacteous1046773lacteous
lactic10713493lact_ic
lactonic1248053lactonic
lacunae9116803lacunae
lacune8169673lac_une
lacunes9159623lacunes
ladrone83611873ladrone
laicise939333laicise
laities7320343laities
laminose1036913laminose
lapse74917683la__pse
laptop1076813lapto_p
laptops1166603laptops
largos74815063largos_
lase46148513la___se
lassoes74613853lassoes
lassos64913813lassos_
lasts57731263last_s_
latches123320133latches
late47560483la_t__e
latest63822703la_test
lathe85626723la_t_he
lathes95127503la_thes
laths86022403la_ths_
latish92416173la_tish
latke94817093la_t_ke
latkes104715873la_tkes
latosol745283la_tosol
lats45962703la_t_s_
latte55426303la_t_te
lattes65324203lattes_
lattice938433lattice
lector83514993lecto_r
lectors93415773lectors
lecture9149523lecture
lentos65317403lentos_
leprose938553leprose
license9148423license
lictor83610863licto_r
lictors93212603lictors
locoes85516583loc_oes
locos75822603loc_os_
loose56627683l__oose
lose45144583l___ose
lotos54724633l_otos_
lotoses73713653l_otoses
lottos64613103lottos_
machos135217493machos_
macros104017013macros_
maltase938903maltase
maltoses1039863maltoses
mannose939243mannose
mucose10149313muc_ose
nachos115014183nachos_
narcose95910393narcose
necrose939733necrose
pacts95125803pact_s_
pantos85222743pantos_
papoose1147513papoose
pappose1047413pappose
parclose1247243parclose
pectase112410363pectase
pentose9311593pentose
practise12310143practise
racemose1245003racemose
ramose8314403ra_mose
ratos55528763ra_tos_
rechose121312053rechose
rectos85718783rectos_
santos64421833santos_
scapose1147753scapose
setose65114773_setose
sucrose939313sucrose
tacnode1045093tacnode
tacos77023553tac_os_
tactile9310613tactile
tacts76524123tact_s_
talcose938143talcose
unclose91111643unclose
vacuole1245373vacuole
vadose1037963va_dose
vamoose1235863vamoose
vamose1159283va_mose
wackos155210993wackos_

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 Filter1786911340270.546327272.9
2DLD Change Limit1340271658.25016245.7
3Display Results1651650.0503300.0
 (SQL Overall)1786911658.84620200.2
 
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.