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

247 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
misdated12121112(None) 
misdate101413961misdate_
misdates111113631misdates
mismated131111331mismated
misrated111315381misrated
disrated10915572disrated
iodated9310022_iodated
mandated12310292mandated
migrated121110512migrated
misacted1338672misacted
misadapted1642992misadapted
misadded1335752misadded
misate81222692mis_ate_
miscited13310422miscited
misdeed113211052misd_eed
misdialed1345512misdialed
miseaten10310772miseaten
misedited1346782misedited
mismate111415352mismate_
mismates121114562mismates
misnamed13127592misnamed
mispaged1438242mispaged
misparted1437262misparted
misrate91319142misrate_
misrates101318242misrates
misseated12610112misseated
misstated1278972misstated
misted93625822mis__ted
nidated939862ni_dated
airdate8311323airdate_
airdates939723airdates
ansated84214003ans_ated
bisected1336203bisected
bistate9313823bistate_
caseated11310713caseated
caudated1238063caudated
ciliated11510953ciliated
cisted95217523cis__ted
citrated112712253citrated
crispated1445023crispated
cristated1247423cristated
cuspated1335913cuspated
dated75530993___dated
dictated1239203dictated
dilated93115823di_lated
discanted1339333discanted
discased122510853discased
disdained1246023disdained
diseased103011713diseased
dismasted1346833dismasted
dismayed1535743dismayed
disparted1338853disparted
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
dissaved1337313dissaved
disseated11711083disseated
distasted1137963distasted
emendated1344653emendated
emigrated1347073emigrated
estated83715573_estated
filiated12610083filiated
fissate103010033fissate_
fisted104218703fis__ted
fixated1835533fi_xated
gestated102910573gestated
gradated1157433gradated
histed104420243his__ted
ideated9310973_ideated
imitated1138263imitated
indited93515023_indited
instated91613343instated
iodate7313503_iodate_
iodates8312903_iodates
isleted837523_isleted
isolated9410523_isolated
librated113110313librated
ligated92414143li_gated
lineated9711063lineated
liquated1835493liquated
listed74322833lis__ted
mandate10315573mandate_
mandates11314093mandates
massaged1236753massaged
masted94025803mas__ted
mated85537783m___ated
meated94222403m__eated
medaled113411613m_edaled
mediated123011873mediated
mesdames1346043mesdames
messaged1235543messaged
middled123311903mi_ddled
midsized2144733midsized
migrate101314173migrate_
migrates111112853migrates
milded104416153mild__ed
mildened1235773mildened
mildewed1543763mildewed
militated1248803militated
milted93919943mi__lted
minded103817833mind__ed
minted94220583mi__nted
minuted10329503mi_nuted
misadd1037163mis_a_dd
misaimed1338093misaimed
misalter1038343misalter
misatoned1246693mis_atoned
misaver1249813mis_aver
misbiased1444843misbiased
miscalled1447443miscalled
miscite11314383miscite_
miscites12313783miscites
miscoded1437983miscoded
miscreated1547423miscreated
miscued1239293mis_cued
misdating131010663misdating
misdealer1245593misdealer
misdeeds12276813misd_eeds
misdeem12217873misd_eem
misdeemed1544603misdeemed
misdialled1443013misdialled
misdid10510573misd__id
misdoer1048633misd_oer
misdoes10312493misd_oes
misdone10310863misdone_
misdoubted1642553misdoubted
misdrew1335833misd_rew
misease92713043misease_
miseases102614343miseases
miseat82925703miseat__
miseats92815783miseat_s
miseducated1752223miseducated
misenter10310833misenter
misfed124113023mis__fed
misfeed13389683mis_feed
misfiled14278653misfiled
misfired14238543misfired
misfitted1544963misfitted
misframed1745623misframed
misgauged1443703misgauged
misgave13298283misgave_
misgraded1446233misgraded
misgrafted1743793misgrafted
mishanter1446453mishanter
misinter1038833misinter
mislabel1296173mislabel
mislaid1039303misla_id
mislayer1337503mislayer
misleared1277453misleared
misled94719313mis__led
misliked15319513misliked
mislived14328783mislived
mislocated15196253mislocated
mismade12129353mismade_
mismake15139373mismake_
mismakes16129883mismakes
mismarked1845243mismarked
mismatch1743943mismatch
mismatched2063403mismatched
mismoved1635653mismoved
misname11119483misname_
misnames12119883misnames
mispage12310523mispage_
mispages13311183mispages
mispainted1545013mispainted
misparsed1446253misparsed
mispatch1743853mispatch
mispatched2053833mispatched
misplaced1646253misplaced
misplanted1565443misplanted
misplayed1745303misplayed
mispled12310463mis_pled
misquoted2144083misquoted
misraised1268313misraised
misrelated1346493misrelated
misrouted1247303misrouted
misruled1137083misruled
missaid10310303missa_id
missed94423603mis__sed
misshaped1744753misshaped
missorted1247033missorted
misspaced1645353misspaced
misstarted1344873misstarted
misstate10711343misstate_
misstates11710633misstates
misstep11158463mis_step
missuited1257023missuited
mistake131312623mistake_
mistaken14147833mistaken
mistaker14109333mistaker
mistakes141213413mistakes
mistend103812523mis__tend
mister84728563mis__ter
mistimed1339123mistimed
mistitled1246283mistitled
mistraced1439453mistraced
mistreated1348423mistreated
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misvalued1544283misvalued
misyoked1834623misyoked
mitigated1347083mitigated
moated94819003m__oated
mordanted1344413mordanted
muriated1139793muriated
muscatel1246063muscatel
musted93321073mus__ted
mutated102712253m_utated
nictated1137793nictated
nidate7313783ni_date_
nidates8311893ni_dates
nitrated92213153nitrated
outdated1012513193outdated
oxidated1745033oxidated
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
pirated102515613pi_rated
postdated1346883postdated
predated12513273predated
redated93120923_redated
reseated93220263reseated
reslated93517523reslated
restated93120183restated
sated66238533__s_ated
seated75131053__seated
sedated93714343_sedated
sinuated938413sinuated
situated938033situated
skated114414883__skated
slated75028313__slated
stated75427833__stated
titrated92611683titrated
undated93118463_undated
unsated83419933uns_ated
unseated91317683unseated
unstated91615813unstated
updated11369423_updated
vibrated14228393vibrated
violated1237883violated
visaed104110503vis_a_ed
visaged1235683vis_aged
visited1168773vis_ited
vistaed1138023vista_ed
vitiated12289223vitiated
wisted104120273wis__ted

Search took 8 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 Limit1461622477.39019778.3
3Display Results2472470.1102245.5
 (SQL Overall)1786912477.93622516.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.