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

107 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
misadding1411583(None) 
madding123711992m__adding
misacting1439082misacting
misaiming1437872misaiming
miscoding1538182miscoding
misdating131010662misdating
misdoing1238802mis_doing
adding93914963___adding
bidding123613513bi__dding
bradding13268933_bradding
cladding1337143_cladding
desanding12207653desanding
disabling1337753disabling
disarming1338803disarming
disbanding1545583disbanding
disbudding1643563disbudding
discarding1547343discarding
gadding113411453__gadding
gladding1236303_gladding
imbedding1643243imbedding
islanding1135623_islanding
kidding14389773ki__dding
lidding103611433li__dding
marauding1344983marauding
miaouing1134893mi_aouing
miaowing1434593mi_aowing
miauling1137343mi_auling
middling13249343mi_ddling
milding113615453mi__lding
minding113317893mi__nding
misadapting1743063misadapting
misadd1037163misadd___
misadded1335753misadd_ed
misadds1136303misadd__s
misadvice1742463misadvice
misadvise1542933misadvise
misadvising1852923misadvising
misalign1146433misa_lign
misallying1644313misallying
misassign1243223misassign
misatoning1346443misatoning
misawarding1842993misawarding
misbinding1645063misbinding
misbranding1744293misbranding
miscalling1547863miscalling
miscasting1557073miscasting
misciting1439673misciting
miscuing1338733mis_cuing
misdoings1344423mis_doings
miseating121215433miseating
misediting1446573misediting
misfeeding1744993misfeeding
misfiling1537223misfiling
misfiring1536973misfiring
misgauging1543903misgauging
misgiving1645593misgiving
misgrading1546823misgrading
misguiding1544343misguiding
mishandling1843333mishandling
misjudging2242783misjudging
mislaying1557913mislaying
misleading1446833misleading
misliking1637113misliking
misliving1546983misliving
mislodging1543973mislodging
mislying1437843mis_lying
mismaking18118023mismaking
mismarking1955863mismarking
mismating141211823mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
misparsing1546613misparsing
misparting1538083misparting
misraising1348123misraising
misrating121014853misrating
misreading1448263misreading
misruling1237493misruling
missaying1537633missaying
missending1446493missending
missing103619073mis__sing
mistaking1699693mistaking
mistending1447953mistending
mistiming1438913mistiming
misting103623383mis__ting
mistuning1237673mistuning
mistyping1744723mistyping
misusing1138893mis_using
misvaluing1684603misvaluing
miswording1744863miswording
misyoking1944923misyoking
mudding123310813m__udding
outadding1235793outadding
padding123412513__padding
quadding2035363_quadding
radding103715003__radding
readding11411363_readding
resaddling1343503resaddling
resodding1237203resodding
ridding103314193ri__dding
saddling11239593__saddling
sanding93520603__sanding
sodding103712733__sodding
squadding2143233squadding
unsaddling1342533unsaddling
visaing11279333visa__ing
wadding133711943__wadding

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411077.34320242.5
3Display Results1071070.0502140.0
 (SQL Overall)1786911077.82922824.2
 
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.