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

212 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
lactates1031122(None) 
lactases1038511lactases
lactate9312691lactate_
lactated1138861lactated
acetates102013062_acetates
actuates10310302_actuates
dictates11311372dictates
glaciates1267342glaciates
labiates101011512labiates
lacerates112413762lacerates
lactams1136952lacta_ms
lactase937952lactase_
lactones10311222lactones
lactoses1039812lactoses
lattes65324202la_t_tes
leachates1446652leachates
locates93218812loc_ates
nictates1039582nictates
pectates122213932pectates
placates12311752plac_ates
tractates1159752tractates
vacates12312832vac_ates
abates85825033_a_bates
ablates92416903_ablates
acetate92514753_acetate_
acetated112010683_acetated
activates1449683_activates
actives12311523_actives
actuate9311443_actuate_
actuated1138743_actuated
acuate8315633_acuate_
acutes83917723_ac_utes
acylates1339743_acylates
aerates74627483_aerates
agates76121333_a_gates
agitates9310873agitates
agnates82813183_agnates
alates64833963_a_lates
alcades101011473alc_ades
annates72415423_annates
aviates10313063_aviates
baccate131011263baccate_
baccated15148373baccated
backdates1848153backdates
cactuses1237933cactuses
cantatas103410083cantatas
carates95630603ca_rates
cartages11313313cartages
caseates10313703caseates
castrates11312663castrates
cates75951873__c_ates
caudates11310253caudates
cavitates14168963cavitates
crates85736053__crates
dacites101114593dac_ites
delectates1348183delectates
dictate10311663dictate_
dictated1239203dictated
ectases92911673_ectases
elastases946113elastases
emaciates1347883emaciates
eructates1146933eructates
estates74520173_estates
evacuates14256803evacuates
facades1339033fac_ades
factures13129023factures
flatmates1446193flatmates
fluctuates1543073fluctuates
gallates92815523gallates
gestates93213723gestates
glaciate1168073glaciate_
glaciated1365753glaciated
hamates122917673ha_mates
hastate10313913hastate_
hectares1338853hectares
imitates10310503imitates
instates81615823instates
jacales16310323jac_ales
jaculates182810363jaculates
karates115617473ka_rates
labiate91313573labiate_
labiated11109303labiated
lacerate102214703lacerate_
lacerated122210673lacerated
laces76141763lac___es
laches116528343lac__hes
lactam10310943lacta__m
lactary1237843lacta_ry
lactating1239183lactating
lactation11310813lactation
lactations1239423lactations
lacteals1095663lacteals
lacteous1046773lacteous
lactone9311393lactone_
lactose969473lactose_
lacunate10128963lacunate_
lacunes9159623lac_unes
laitances1145613laitances
laities7320343lait_ies
lambastes13114693lambastes
laminates112712903laminates
lampases1267293lampases
lanate6421263la_nate_
lanated8313203la_nated
lancinates1247153lancinates
lantanas838263lantanas
lapidates1247143lapidates
lariated91212063lariated
lariats7615053lariat_s
latches123320123la_tches
latchets133410013latchets
latexes1438313la_texes
lathes95127493la_t_hes
latices9313763la_tices
latkes104715873la_t_kes
latte55426303la_t_te_
latten65018203la_t_ten
lattens75014673la_t_tens
latter65027893la_t_ter
lattices1038383lattices
laureates987683laureates
lavages1138603la_vages
layettes1136263layettes
leachate1347443leachate_
lectures101310153lectures
legates82917673l_egates
levitates1247863levitates
librates103412933librates
liftgates1343513liftgates
ligates82318373l_igates
liquates1737443liquates
litotes7311183l_itotes
locales93715093loc_ales
locate83919843loc_ate_
located103114183loc_ated
locater93113603loc_ater
locaters102710063loc_aters
lockages1536723lockages
lottes65322753l_ot_tes
lucites9311863luc_ites
lustrates939453lustrates
luxates1436973l_uxates
lysates10317473l_ysates
macerates132113563macerates
machetes1539633machetes
macrames1438953macrames
maculates132013723maculates
magnates11511603magnates
malates93522603ma_lates
maleates103316343maleates
maltases1039693maltases
mandates11314093mandates
mattes85624533ma_t_tes
metates92720003_metates
mutates92215793_mutates
narrates8312753narrates
nictate9310223nictate_
nictated1137793nictated
notates72817483_notates
nutates73214973_nutates
oatcakes1445543oatcakes
octanes91111393_octanes
octaves12316963_octaves
packages17138733packages
palates93624933pa_lates
palpates122613063palpates
partakes1449923partakes
pectases122411183pectases
pectate112214693pectate_
picrates122013203picrates
placate11312433plac_ate_
placated1338453plac_ated
placater1238013plac_ater
placaters1336463plac_aters
platanes102711883pla_tanes
playdates1554903playdates
playmates1646603playmates
racemates1348853racemates
radiates92415293radiates
ratites74920683ra_tites
recrates102420353recrates
reluctates1246693reluctates
restates83423413restates
rotates72819773_rotates
saccades13137243saccades
saccate111311763saccate_
sanitates9611733sanitates
satiates8314633satiates
savates10312953sa_vates
spectates13228813spectates
states64337083__states
tannates81911953tannates
tartrates979553tartrates
tates55444983___tates
tectites1039993tectites
testates83615443testates
tractate10411003tractate_
uncrates10314553uncrates
unstates81314993unstates
upstates10189643upstates
vacate11314553vac_ate_
vacated1349353vac_ated
valuates112811193valuates
vantages12119023vantages
variates111214973variates
waftages15105393waftages
wantages12109023wantages
wastages12109753wastages
watapes12228383wa_tapes
wattages12106783wattages
wattapes1395253wattapes
xanthates1945653xanthates

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.1731032896.0
2DLD Change Limit1461622128.70316794.4
3Display Results2122120.0932279.6
 (SQL Overall)1786912128.96919923.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.