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 “mistended” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
mistended1313733(None) 
distended12157921distended
dispended14147822dispended
distender11167742distender
intended102310412_intended
listened9168812listen_ed
mispenned1445412mispenned
misrender1286292misrender
mistend103812522misten__d
mistends11419592mistend_s
mistermed1438362mistermed
mistuned1157722mistun_ed
mittened1136362mitten_ed
moistened1246002moisten_ed
ascended1246513_ascended
attended1035763_attended
bartended1344663bartended
besteaded1345043besteaded
bistered112913323biste_red
contended1339273contended
descended1446283descended
disbanded1445643disbanded
dispensed13158773dispensed
dissented1199723dissented
distanced1348573distanced
distend93312073disten__d
distenders12166733distenders
distends10339823distend_s
extended17135833_extended
fastened12257853fasten_ed
glistened11174283glisten_ed
hastened12239103hasten_ed
impended1435953_impended
intendeds11265743_intendeds
intender93310443_intender
islanded1035513_islanded
kittened1334523kitten_ed
listener8158313listen_er
mastered112614003maste_red
mastheaded1743543mastheaded
mended104418683m___ended
mildened1235773milden_ed
minded103817833mi___nded
misadded1335753mis_added
misatoned1246693misaton_ed
misbranded1644143misbranded
miscoded1437983mis_coded
misdeed113211053misde__ed
misdeemed1544603misdeemed
misenter10310833mis_enter
misfeed13389683misfe__ed
misfielded1742443misfielded
misgraded1446233misgraded
misguided14144653misguided
mishandled1743433mishandled
misleader1246503misleader
misleared1277453misleared
mispleaded1644133mispleaded
misrelied1247243misrelied
misrendered1552983misrendered
misrenders1375353misrenders
misseated12610113misseated
missend104411373missen__d
missends11368233missend_s
missense1037963missense_
missenses1148033missenses
missounded1443023missounded
missteered1343553missteered
misstepped1782693misstepped
misted93625823mist___ed
mistending1447953mistending
mistimed1339123mist_imed
mistitled1246283mistitled
mistraced1439453mistraced
mistreated1348423mistreated
mistune9310653mistun_e_
mistunes10311133mistun_es
mistyped1685173mist_yped
misworded1644233misworded
mitered103213233mi_te_red
moistener1145843moisten_er
mustered112511503muste_red
portended1345643portended
pretended1337193pretended
protended1336803protended
scended11329873__scended
sended85121233__s_ended
sistered92612803siste_red
steaded92811673__steaded
subtended1345153subtended
suspended13104513suspended
tended83819483___tended
unintended1243513unintended
untended102611153_untended

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 Filter1786911486410.406440125.6
2DLD Change Limit148641946.28323657.6
3Display Results94940.0462043.5
 (SQL Overall)178691946.73526531.7
 
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.