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

191 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
lactated113887(None) 
lactate9312701lactate_
lactates10311231lactates
acetated112010692_acetated
actuated1138752_actuated
baccated15148382baccated
dictated1239202dictated
glaciated1365762glaciated
labiated11109302labiated
lacerated122210692lacerated
lactase937962lactase_
lactases1038522lactases
lanated8313202la_nated
lariated91212062lariated
located103114182loc_ated
nictated1137792nictated
placated1338452plac_ated
vacated1349352vac_ated
abated95918453_a_bated
ablated102513443_ablated
acerated113114003_acerated
acetate92514753_acetate_
acetates102013063_acetates
acted88521743_ac__ted
activated1567883_activated
actuate9311443_actuate_
actuates10310313_actuates
acuate8315633_acuate_
acylated1437883_acylated
aerated85322383_aerated
agitated1038413agitated
alated75625153_a_lated
ansated84214003_ansated
arcuated1138813arcuated
aurated83817793_aurated
aviated11310263_aviated
baccate131011263baccate_
backdated1946483backdated
batted95623653ba_t_ted
blatted104812713bla_t_ted
cacheted16148243cacheted
caftaned1445093caftaned
capitated14159043capitated
caseated11310723caseated
castrated1239523castrated
catted95422473ca_t_ted
caudated1238063caudated
caveated1439143caveated
cavitated15177353cavitated
coated94927043__coated
crated94827773__crated
delectated1446723delectated
dentated10411703dentated
dictate10311663dictate_
dictates11311383dictates
emaciated1446933emaciated
eructated1245643eructated
estated83715573_estated
evacuated15196263evacuated
faceted13509573fac_eted
facetted1445753facetted
factored1436233factored
falcated1438483falcated
fasciated1546133fasciated
fatted105419843fa_t_ted
flatted114012943fla_t_ted
fluctuated1642493fluctuated
galeated104111583galeated
gestated102910573gestated
glaciate1168083glaciate_
glaciates1267353glaciates
guttated10266873guttated
hastate10313913hastate_
hatted104921513ha_t_ted
imitated1138263imitated
instated91613343instated
jacketed22146543jacketed
jaculated19289053jaculated
labiate91313573labiate_
labiates101011513labiates
laced87132643lac___ed
lacerate102214713lacerate_
lacerates112413783lacerates
lacertid1146393lacertid
lacked135324653lac__ked
lackered15108683lackered
lackeyed18104513lackeyed
lactam10310943lacta__m
lactams1136953lacta_ms
lactary1237853lacta_ry
lactating1239193lactating
lactation11310813lactation
lactone9311413lactone_
lactones10311243lactones
lactose969493lactose_
lactoses1039833lactoses
lacunate10128963lacunate_
lambasted14103253lambasted
lamented1138193lamented
laminated122610283laminated
lanate6421263la_nate_
lanceted1137083lanceted
lancinated1345573lancinated
lapidated1345673lapidated
lappeted13255833lappeted
lasted74323603la__sted
latched133914073la_tched
lated65240673l___ated
latened8711923la_tened
lathed104718463la_t_hed
latte55426303la_t_te_
latten65018203la_t_ten
latter65027893la_t_ter
lattes65324203la_t_tes
latticed1134793latticed
laureated1096163laureated
leachate1347443leachate_
leachates1446663leachates
lectured11127233lectured
legated92513983l_egated
letted74118543l_et_ted
levitated1346413levitated
librated113110313librated
lichted13268803lic_hted
ligated92414143l_igated
lineated9711063lineated
liquated1835493liquated
lobated102610943l_obated
locate83919843loc_ate_
locater93113603loc_ater
locates93218813loc_ates
loculated1288313loculated
lotted74222403l_ot_ted
lunated8310823l_unated
lustrated1037973lustrated
luxated1535713l_uxated
lyrated11388473l_yrated
macerated142010533macerated
maculated142411503maculated
mandated12310293mandated
matted94521413ma_t_ted
mutated102712253_mutated
narrated9310333narrated
nictate9310223nictate_
nictates1039593nictates
notated82713663_notated
nutated83113423_nutated
packaged18115753packaged
packeted17148293packeted
palmated132511003palmated
palpated13249763palpated
patted94724683pa_t_ted
pectate112214693pectate_
pectates122213953pectates
picrated132110113picrated
placate11312433plac_ate_
placater1238013plac_ater
placates12311753plac_ates
platted103614263pla_t_ted
plicated13310643plic_ated
punctated1445053punctated
racheted14149513racheted
racketed15169133racketed
radiated102512593radiated
ratted74923343ra_t_ted
recoated113416793recoated
recrated112918613recrated
reluctated1345943reluctated
restated93120183restated
rotated82715293_rotated
saccate111311763saccate_
sacheted14127843sacheted
sanitated1068993sanitated
satiated9311603satiated
scatted103512773scat_ted
slatted84015183sla_t_ted
spectated14236593spectated
stated75427833__stated
tartrated1096653tartrated
tatted74920533ta_t_ted
tractate10411003tractate_
tractates1159763tractates
uncoated11314963uncoated
uncrated11416313uncrated
unstated91615813unstated
vacate11314553vac_ate_
vacates12312833vac_ates
valuated12239203valuated
variated121211393variated
vatted104214733va_t_ted
yachted1634853yac_hted

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 Limit1461621918.44017317.8
3Display Results1911910.0762513.2
 (SQL Overall)1786911918.95219961.0
 
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.