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

241 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
mismated13111133(None) 
misdated121211121misdated
mismate111415351mismate_
mismates121114561mismates
misrated111315381misrated
dismasted1346832dismasted
dismayed1535742dismayed
disrated10915572disrated
migrated121110512migrated
misacted1338672misacted
misate81222692mis_ate_
miscited13310422miscited
misdate101413962misdate_
misdates111113632misdates
miseaten10310772miseaten
mismade12129352mismade_
mismake15139372mismake_
mismakes16129882mismakes
mismarked1845242mismarked
mismatch1743942mismatch
mismatched2063402mismatched
mismoved1635652mismoved
misnamed13127592misnamed
mispaged1438242mispaged
misparted1437262misparted
misrate91319142misrate_
misrates101318242misrates
misseated12610112misseated
misstated1278972misstated
misted93625822mis__ted
animated111612373animated
ansated84214003ans_ated
bisected1336203bisected
bistate9313823bistate_
bromated1339173bromated
caseated11310713caseated
casemated1446953casemated
ciliated11510953ciliated
cisted95217523cis__ted
citrated112712253citrated
cremated133412963cremated
crispated1445023crispated
cristated1247423cristated
cuspated1335913cuspated
dictated1239203dictated
dilated93115823di_lated
discanted1339333discanted
discased122510853discased
diseased103011713diseased
dismaler1137903dismaler
dismantled1443693dismantled
disparted1338853disparted
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
dissaved1337313dissaved
disseated11711083disseated
distasted1137963distasted
emigrated1347073emigrated
estated83715573_estated
filiated12610083filiated
fissate103010033fissate_
fisted104218703fis__ted
fixated1835533fi_xated
gemmated14336293gemmated
gestated102910573gestated
histed104420243his__ted
ideated9310973_ideated
imaged1097763_i_maged
imamate1138103imamate_
imamates1237663imamates
imitated1138263imitated
inmate82917363_inmate_
inmates92715783_inmates
instated91613343instated
iodated9310023_iodated
isleted837523_isleted
isolated9410523_isolated
kismat123011673kismat__
kismats13257843kismat_s
librated113110313librated
ligated92414143li_gated
limited102310233li_mited
lineated9711063lineated
liquated1835493liquated
listed74322833lis__ted
mammate104411273mammate_
mandated12310293mandated
massaged1236753massaged
masted94025803mas__ted
mated85537783___mated
meated94222403m__eated
mediated123011873mediated
messaged1235543messaged
messmate1246393messmate_
messmates1346233messmates
miasmata1244503miasmat_a
miasmatic1545633miasmatic
migrate101314173migrate_
migrates111112853migrates
militated1248803militated
milted93919943mi__lted
mimed105622733mi_m__ed
mimeoed1235193mi_meoed
minted94220583mi__nted
minuted10329503mi_nuted
misadapted1642993misadapted
misadd1037163mis_a_dd
misadded1335753misadded
misaimed1338093misaimed
misalter1038343misalter
misatoned1246693mis_atoned
misaver1249813mis_aver
misbiased1444843misbiased
miscalled1447443miscalled
miscite11314383miscite_
miscites12313783miscites
miscoded1437983miscoded
miscreated1547423miscreated
miscued1239293mis_cued
misdeed113211053mis_deed
misdialed1345513misdialed
misease92713043misease_
miseases102614343miseases
miseat82925713miseat__
miseats92815793miseat_s
misedited1346783misedited
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
mismanaged1643443mismanaged
mismark1536703misma_rk
mismarks1645893mismarks
mismatches1953753mismatches
mismating141211823mismating
mismeet113215163mism_eet
mismeets12297733mismeets
mismet103722373mism__et
mismove1437083mismove_
mismoves1537293mismoves
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
muriated1139793muriated
muscatel1246063muscatel
musted93321073mus__ted
mutated102712253m_utated
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
palmated132511003palmated
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
pirated102515613pi_rated
remated103522473_remated
reseated93220263reseated
reslated93517523reslated
restated93120183restated
sated66238533__s_ated
seated75131063__seated
sigmate10710143sigmate_
sinuated938413sinuated
situated938033situated
skated114414883__skated
slated75028313__slated
smarted105012613__smarted
stated75427833__stated
summated13298833summated
titrated92611683titrated
unmated103317023_unmated
unsated83419933uns_ated
unseated91317683unseated
unstated91615813unstated
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.423422437.4
2DLD Change Limit1461622416.90621164.5
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.42224075.9
 
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.