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) 
misdated121211111misdated
mismate111415351mismate_
mismates121114551mismates
misrated111315381misrated
dismasted1346822dismasted
dismayed1535742dismayed
disrated10915572disrated
migrated121110492migrated
misacted1338672misacted
misate81222692mis_ate_
miscited13310422miscited
misdate101413962misdate_
misdates111113622misdates
miseaten10310772miseaten
mismade12129352mismade_
mismake15139372mismake_
mismakes16129882mismakes
mismarked1845242mismarked
mismatch1743932mismatch
mismatched2063402mismatched
mismoved1635652mismoved
misnamed13127592misnamed
mispaged1438242mispaged
misparted1437262misparted
misrate91319142misrate_
misrates101318232misrates
misseated12610112misseated
misstated1278952misstated
misted93625822mis__ted
animated111612373animated
ansated84214003ans_ated
bisected1336203bisected
bistate9313813bistate_
bromated1339173bromated
caseated11310713caseated
casemated1446953casemated
ciliated11510943ciliated
cisted95217523cis__ted
citrated112712243citrated
cremated133412963cremated
crispated1445023crispated
cristated1247413cristated
cuspated1335913cuspated
dictated1239203dictated
dilated93115823di_lated
discanted1339333discanted
discased122510853discased
diseased103011713diseased
dismaler1137903dismaler
dismantled1443693dismantled
disparted1338853disparted
disputed1238343disputed
disrate81418523disrate_
disrates91118143disrates
dissaved1337313dissaved
disseated11711073disseated
distasted1137953distasted
emigrated1347063emigrated
estated83715573_estated
filiated12610083filiated
fissate103010033fissate_
fisted104218703fis__ted
fixated1835533fi_xated
gemmated14336293gemmated
gestated102910573gestated
histed104420243his__ted
ideated9310973_ideated
imaged1097763_i_maged
imamate1138093imamate_
imamates1237653imamates
imitated1138263imitated
inmate82917353_inmate_
inmates92715763_inmates
instated91613333instated
iodated9310023_iodated
isleted837523_isleted
isolated9410523_isolated
kismat123011673kismat__
kismats13257843kismat_s
librated113110313librated
ligated92414133li_gated
limited102310233li_mited
lineated9711063lineated
liquated1835483liquated
listed74322833lis__ted
mammate104411273mammate_
mandated12310283mandated
massaged1236753massaged
masted94025803mas__ted
mated85537783___mated
meated94222403m__eated
mediated123011873mediated
messaged1235543messaged
messmate1246393messmate_
messmates1346233messmates
miasmata1244503miasmat_a
miasmatic1545613miasmatic
migrate101314163migrate_
migrates111112843migrates
militated1248803militated
milted93919943mi__lted
mimed105622733mi_m__ed
mimeoed1235193mi_meoed
minted94220583mi__nted
minuted10329503mi_nuted
misadapted1642993misadapted
misadd1037163mis_a_dd
misadded1335753misadded
misaimed1338093misaimed
misalter1038343misalter
misatoned1246693mis_atoned
misaver1249813mis_aver
misbiased1444843misbiased
miscalled1447433miscalled
miscite11314383miscite_
miscites12313783miscites
miscoded1437983miscoded
miscreated1547423miscreated
miscued1239293mis_cued
misdeed113211053mis_deed
misdialed1345503misdialed
misease92713043misease_
miseases102614343miseases
miseat82925703miseat__
miseats92815783miseat_s
misedited1346783misedited
misenter10310833misenter
misfed124113023mis__fed
misfeed13389683mis_feed
misfiled14278653misfiled
misfired14238543misfired
misfitted1544953misfitted
misframed1745623misframed
misgauged1443703misgauged
misgave13298283misgave_
misgraded1446233misgraded
misgrafted1743793misgrafted
mishanter1446453mishanter
misinter1038833misinter
mislabel1296163mislabel
mislaid1039293misla_id
mislayer1337503mislayer
misleared1277453misleared
misled94719313mis__led
misliked15319513misliked
mislived14328783mislived
mislocated15196253mislocated
mismanaged1643443mismanaged
mismark1536703misma_rk
mismarks1645893mismarks
mismatches1953753mismatches
mismating141211813mismating
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
missaid10310293missa_id
missed94423603mis__sed
misshaped1744753misshaped
missorted1247033missorted
misspaced1645353misspaced
misstarted1344863misstarted
misstate10711333misstate_
misstates11710623misstates
misstep11158463mis_step
missuited1257013missuited
mistake131312613mistake_
mistaken14147823mistaken
mistaker14109323mistaker
mistakes141213403mistakes
mistend103812523mis__tend
mister84728563mis__ter
mistimed1339123mistimed
mistitled1246273mistitled
mistraced1439443mistraced
mistreated1348423mistreated
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misvalued1544273misvalued
misyoked1834623misyoked
mitigated1347083mitigated
moated94819003m__oated
muriated1139793muriated
muscatel1246063muscatel
musted93321073mus__ted
mutated102712253m_utated
nictated1137793nictated
nidated939863ni_dated
nitrated92213153nitrated
palmated132511003palmated
picrated132110113picrated
pileated112711133pileated
pinnated11338553pinnated
pirated102515613pi_rated
remated103522473_remated
reseated93220263reseated
reslated93517523reslated
restated93120173restated
sated66238533__s_ated
seated75131053__seated
sigmate10710123sigmate_
sinuated938403sinuated
situated938023situated
skated114414873__skated
slated75028313__slated
smarted105012613__smarted
stated75427833__stated
summated13298833summated
titrated92611683titrated
unmated103317023_unmated
unsated83419933uns_ated
unseated91317683unseated
unstated91615813unstated
vibrated14228383vibrated
violated1237883violated
visaed104110503vis_a_ed
visaged1235683vis_aged
visited1168773vis_ited
vistaed1138013vista_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.1731032896.0
2DLD Change Limit1461622417.56319325.9
3Display Results2412410.1102190.9
 (SQL Overall)1786912417.84622774.8
 
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.