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 “dictated” 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
dictated123920(None) 
dictate10311661dictate_
dictates11311381dictates
nictated1137791nictated
dentated10411702dentated
dictator1147262dictator
digitated1286962digitated
dilated93115822di_lated
disrated10915572disrated
distasted1137962distasted
lactated1138862lactated
nictate9310222nictate_
nictates1039592nictates
picrated132110112picrated
redictated1447482redictated
abdicated1547013abdic_ated
acetated112010683acetated
actuated1138743_actuated
agitated1038413agitated
arcuated1138803arcuated
baccated15148373baccated
bistate9313823bistate_
bitted94418483bi_t_ted
catted95422473__catted
ciliated11510953ciliated
citrated112712253citrated
coated94927043__coated
crated94827773__crated
cristated1247423cristated
dated75530993d___ated
dealated103213603dealated
debated113916083d_ebated
decanted122310493decanted
decayed14309333dec_ayed
deceased1247713deceased
decimated1548953decimated
declared1248743declared
declawed1545923declawed
decocted1437683decocted
decorated13312203decorated
dedicated14310253dedic_ated
defatted1335673defatted
defeated132812163defeated
deflated133412303deflated
delated93722873d_elated
delectated1446723delectated
dentate8315153dentate_
derated93623503d_erated
deratted1048403deratted
desiccated1644993desiccated
deviated13311043deviated
dialed84716453di__aled
diced95824683dic___ed
dicked144920863dic__ked
dickered16117533dickered
dicta84915633dicta___
dictating1338883dictating
dictation12810563dictation
dictators1247363dictators
dictier103411863dict_ier
dieted83115493di__eted
digested11208163digested
dighted132511493di_ghted
digitate1098683digitate_
diktat11310693diktat__
diktats1235623diktat_s
dilatate947773dilatate_
dilate73220693di_late_
dilater83515653di_later
dilates83220663di_lates
diluted9248933di_luted
dinted84419843di__nted
directed1238233directed
dirtied93210853dirt_ied
discanted1339333discanted
discased122510853discased
discepted1547523discepted
diseased103011713diseased
dismasted1346833dismasted
dismayed1535743dismayed
disparted1338853disparted
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
dissaved1337313dissaved
disseated11711083disseated
distained1139603distained
distanced1348573distanced
distaste939943distaste_
distastes1039633distastes
distaves12311403distaves
distorted1139373distorted
distracted1448873distracted
ditched143711903di_tched
dittoed936733di_ttoed
divagated1543873divagated
diverted13199583diverted
divested13268213divested
doated84118183d__oated
docketed16156583docketed
doctored1245613doctored
donated93513863d_onated
dotted84717523d_ot_ted
dratted9358593drat_ted
ducted104012123duc__ted
duetted937023duet_ted
educated1237943educ_ated
eructated1245643eructated
estated83715573_estated
filiated12610083filiated
filtrated1345963filtrated
fitted104716663fi_t_ted
fixated1835533fi_xated
gestated102910573gestated
gitted84015053gi_t_ted
guttated10266873guttated
ideated9310973_ideated
imitated1138263imitated
indicated13310953indic_ated
instated91613343instated
iodated9310023_iodated
kitted115114833ki_t_ted
lactate9312693lactate_
lactates10311223lactates
librated113110313librated
lichted13268803lic_hted
ligated92414143li_gated
lineated9711063lineated
liquated1835493liquated
located103114183loc_ated
medicated15410073medic_ated
meditated1348083medi_tated
micturated1584993micturated
migrated121110513migrated
militated1248803militated
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
misstated1278973misstated
mutated102712253_mutated
nictitated1344403nictitated
nidated939863ni_dated
nitrated92213153nitrated
notated82713663_notated
nutated83113423_nutated
pectate112214693pectate_
pectates122213953pectates
pickaxed2443513pickaxed
picketed17167383picketed
picoted1239213pic_oted
picrate112014143picrate_
picrates122013213picrates
pictured1346573pictured
pileated112711133pileated
pinnated11338553pinnated
pirated102515613pi_rated
pitted94319593pi_t_ted
plicated13310643plic_ated
punctated1445053punctated
radicated13410123radic_ated
recoated113416783recoated
recrated112918603recrated
redictate1249063redictate_
redictates1348233redictates
restated93120183restated
rotated82715293_rotated
scatted103512773_scatted
sinuated938413sinuated
situated938033situated
spectated14236593spectated
spicated13309903spic_ated
stated75427833__stated
ticketed15146643ticketed
tictacked18153053tictacked
titrated92611683titrated
uncoated11314963uncoated
uncrated11416313uncrated
unstated91615813unstated
vacated1349353vac_ated
vibrated14228393vibrated
victualed1543103victualed
violated1237883violated
vistaed1138023vista_ed
vitiated12289223vitiated
vittate10409733vittate_
witted104216813wi_t_ted

Search took 7 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.406440125.6
2DLD Change Limit1461621866.36022981.4
3Display Results1861860.0802325.0
 (SQL Overall)1786911866.84626101.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.