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

183 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
misacted133867(None) 
bisected1336202bisected
impacted15286352impacted
misact10316692misact__
misacts1139352misact_s
misadded1335752misadded
misaimed1338092misaimed
misalter1038342misalter
misate81222692misa_te_
miscited13310422miscited
miscued1239292mis_cued
misdated121211122misdated
mismated131111332mismated
misparted1437262misparted
misrated111315382misrated
misted93625822mis__ted
acted88521743___acted
ansated84214003ansa_ted
biparted1335133biparted
bracted12410933_bracted
cisted95217523cis__ted
coacted123611613_coacted
desalted1038313desalted
dilated93115823dila_ted
directed1238233directed
disabled1248713disabled
disarmed1238643disarmed
disaster949943disaster
discanted1339333discanted
discased122510853discased
disced104914653dis_c_ed
discoed11312483dis_coed
disjected2086353disjected
dismasted1346833dismasted
disparted1338853disparted
disputed1238353disputed
disrated10915573disrated
dissected13108663dissected
distasted1137963distasted
distracted1448873distracted
enacted10310643_enacted
exacted1737303_exacted
exsected1835673exsected
fisted104218703fis__ted
fixated1835533fixa_ted
fracted1339373_fracted
hijacked2542373hijacked
histed104420243his__ted
imitated1138263imita_ted
impacter14296573impacter
imparted13248063imparted
impasted13297553impasted
isleted837523_isleted
ligated92414143liga_ted
listed74322833lis__ted
maced108528693m__ac_ed
macled116718113m__acled
malted94819863m__alted
manacled1336453manacled
marted94425213m__arted
massacred1443193massacred
masted94025803m__asted
mated85537783m__a_ted
matted94521413m__atted
meated94222403m_ea_ted
menaced122710093menac_ed
miaoued1034583mi_aoued
miaowed1333883mi_aowed
miauled1036663mi_auled
miched143913393mi__ched
migrated121110513migrated
milted93919943mi__lted
mimicked1943253mimicked
minareted1244623minareted
minced114114913mi_nc_ed
minted94220583mi__nted
minuted10329503mi_nuted
miracle1138843miracle_
miracles1238333miracles
misacting1439083misacting
misadapted1642993misadapted
misadd1037163misa__dd
misallied1246543misallied
misaltered1344563misaltered
misalters1136913misalters
misatoned1246693misatoned
misaver1249813misa_ver
misaward1464593misaward
miscalled1447443miscalled
miscite11314383miscite_
miscites12313783miscites
miscode12310413mis_code
miscoded1437983miscoded
miscue10412223mis_cue_
miscues11312393mis_cues
misdate101413963misdate_
misdates111113633misdates
misdeed113211053mis_deed
miseaten10310773miseaten
misedited1346783misedited
misenter10310833misenter
misfed124113023mis__fed
misfeed13389683mis_feed
misfiled14278653misfiled
misfired14238543misfired
misfitted1544963misfitted
misgauged1443703misgauged
misgrafted1743793misgrafted
mishanter1446453mishanter
misinter1038833misinter
miskicked1744063miskicked
misled94719313mis__led
misliked15319513misliked
mislived14328783mislived
mislocated15196253mislocated
mismarked1845243mismarked
mismatched2063403mismatched
mismate111415353mismate_
mismates121114563mismates
mismoved1635653mismoved
misnamed13127593misnamed
mispaged1438243mispaged
mispainted1545013mispainted
misparsed1446253misparsed
mispatched2053833mispatched
misplaced1646253misplac_ed
misplanted1565443misplanted
mispled12310463mis_pled
misquoted2144083misquoted
misraised1268313misraised
misrate91319143misrate_
misrates101318243misrates
misrouted1247303misrouted
misruled1137083misruled
misseated12610113misseated
missed94423603mis__sed
missorted1247033missorted
misspaced1645353misspac_ed
misstarted1344873misstarted
misstated1278973misstated
misstep11158463mis_step
missuited1257023missuited
mistend103812523mis__tend
mister84728563mis__ter
mistimed1339123mistimed
mistitled1246283mistitled
mistraced1439453mistrac_ed
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misvalued1544283misvalued
misyoked1834623misyoked
moated94819003m_oa_ted
mosaicked1842483mosaicked
mulcted12296693m_ulcted
muscatel1246063muscatel
muscled1237783mus_cled
musicked1734033musicked
mustached17164833mustached
musted93321073mus__ted
mutated102712253muta_ted
nidated939863nida_ted
outacted1139383outacted
pirated102515613pira_ted
preacted132710943preacted
reacted103015713_reacted
redacted12410243redacted
resected112514743resected
sacked135525213__sacked
sacred94917103__sacred
salted74121203__salted
sated66238533__sa_ted
sauted74119603__sauted
semisacred1552363semisacred
tincted1037273ti_ncted
trisected1244913trisected
unacted10312733_unacted
unsalted9510923unsalted
unsated83419933unsa_ted
visaed104110503visa__ed
visaged1235683visa_ged
visited1168773vis_ited
wisted104120273wis__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.440406115.9
2DLD Change Limit1461621836.39022873.6
3Display Results1831830.0762407.9
 (SQL Overall)1786911836.90625874.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.