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

220 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
mandated1231028(None) 
mandate10315571mandate_
mandates11314091mandates
ansated84214002_ansated
bandaged1337312bandaged
caudated1238062caudated
emanated1139162eman_ated
emendated1344642emendated
lanated8313202lan_ated
managed113212602man_aged
manatee9317662man_atee
mandator1148172mandator
manducated1644562manducated
misdated121211112misdated
sandaled1039232sandaled
undated93118462_undated
abated95918453_a_bated
ablated102513443_ablated
adapted1135833_a_dapted
adnate72913483_adnate_
aerated85322373_aerated
alated75625143_a_lated
andante8311273_andante_
andantes9310853_andantes
aneared8512743_aneared
animated111612373_animated
annates72415423_annates
ansate64517863_ansate_
anted66328243_an__ted
antedated1146693_antedated
audited939033_audited
aurated83817793_aurated
aviated11310263_aviated
baccated15148373baccated
backdated1946483backdated
baldpated1543823baldpated
bandage11311023bandage_
bandager1237703bandager
bandages12310633bandages
bandaid11310473banda_id
banded105223173band__ed
bandied114414303band_ied
bandmate1347973bandmate_
bandmates1447923bandmates
banjaxed2542353banjaxed
bendayed1534873bendayed
canaled103615553can_aled
candied113816023cand_ied
candled113815733cand_led
canted94825783can__ted
canulated12310673canulated
canvased14246213canvased
caseated11310713caseated
caudate10311353caudate_
caudates11310253caudates
caveated1439133caveated
cuneated11310103cuneated
dandered112110963dandered
dandled103313543dand_led
dated75530993___dated
dentated10411703dentated
denudated1244933denudated
donated93513863don_ated
emaciated1446933emaciated
emanate9312473eman_ate_
emanates10311333eman_ates
emendate1146763emendate_
emendates1246063emendates
endited93512913_endited
falcated1438473falcated
galeated104111573galeated
gandered112211173gandered
gradated1157433gradated
handaxes1938403handaxes
handed114919983hand__ed
handfasted1843003handfasted
handled124114533hand_led
hangared1337563hangared
hanted104124313han__ted
indited93515023_indited
inundated1144753inundated
iodated9310023_iodated
labiated11109303labiated
lactated1138863lactated
lanate6421263lan_ate_
lanceted1137073lanceted
landed84619243land__ed
lapidated1345673lapidated
lariated91212063lariated
lineated9711063lineated
lunated8310823lun_ated
macerated142010523macerated
maculated142411503maculated
madame1139853ma_dame_
madames12310063ma_dames
madded113513553ma_d_ded
maddened1334893maddened
magdalen1243523magdalen
magnate10512703magnate_
magnates11511603magnates
maladapted1652123maladapted
malate84624553ma_late_
malates93522603ma_lates
maleate94117543maleate_
maleates103316343maleates
malted94819853ma__lted
mammate104411273mammate_
manacled1336453manacled
manage93818903man_age_
manager103413583man_ager
manages103418963man_ages
manat76039983man_at__
manatees10310423man_atees
manatoid1148813man_atoid
manats84623463man_at_s
mandala10310203manda_la
mandalas1139433mandalas
mandalic1347793mandalic
mandamus1345523mandamus
mandamused1652093mandamused
mandarin11411013mandarin
mandatary1543243mandatary
mandating1339773mandating
mandators1247863mandators
mandatory1545243mandatory
mandrake1546003mandrake_
mandrakes1646353mandrakes
mandrel1038683mand_rel
manducate1445773manducate_
manducates1545593manducates
maned86634093man___ed
mangabey1643463mangabey
mangled113615253man_gled
manmade1237963manmade_
manned94418643man__ned
mannered11249653mannered
mannite9312903mannite_
mannites10312613mannites
mansard1049313mansa_rd
mansarded1343993mansarded
mantel84317973man__tel
mantes84430783man__tes
mantid93820373man__tid
mantled104113393man_tled
manured1039473man_ured
manward1349093manwa_rd
marinated122513173marinated
marketed1537323marketed
marted94425213ma__rted
massaged1236753massaged
masted94025803ma__sted
mated85537783m___ated
matted94521413ma__tted
maturated1249163maturated
maundered1394943maundered
meandered1346143meandered
meated94222403m__eated
medaled113411603m_edaled
mediated123011873mediated
menaced122710093men_aced
mended104418683mend__ed
migrated121110493migrated
minded103817833mind__ed
minted94220583min__ted
minuted10329503min_uted
misdate101413963misdate_
misdates111113623misdates
mismated131111333mismated
misrated111315383misrated
moated94819003m__oated
montaged12107763montaged
mordanted1344403mordanted
mundane1038073mundane_
muriated1139793muriated
mutated102712253m_utated
narrated9310323narrated
nidated939863_nidated
nonrated9310843nonrated
outdated1012513193outdated
oxidated1745033oxidated
palmated132511003palmated
palpated13249763palpated
pancaked1734893pancaked
pandered121812573pandered
pandied113913443pand_ied
panted95024823pan__ted
pennated11299543pennated
pinnated11338553pinnated
predated12513273predated
radiated102512593radiated
ranted74324703ran__ted
redated93120923_redated
sandalled1145893sandalled
sanded84920613sand__ed
sanitated1068993sanitated
satiated9311603satiated
scandaled1344643scandaled
sedated93714343_sedated
sensated938183sensated
sinuated938403sinuated
tannate71813523tannate_
tannates81911953tannates
unabated11310133unabated
unadapted1344653unadapted
unbated103317733_unbated
ungated92717213_ungated
unmated103317023_unmated
unrated82621553_unrated
unsated83419933_unsated
updated11369423_updated
vacated1349353va_cated
validated1446493validated
valuated12239203valuated
vanadate1245513vanadate_
vanadates1345133vanadates
vandyked2041573vandyked
variated121211393variated
wandered132110793wandered
wanted104319723wan__ted
zonated173310533zon_ated

Search took 10 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.1701051123.5
2DLD Change Limit1461622208.79616616.9
3Display Results2202200.1261746.0
 (SQL Overall)1786912209.09219653.7
 
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.