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

224 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
unmended1229909(None) 
unamended1344851unamended
unbended12279971unbended
unended92811821un_ended
untended102611151untended
amended11328312_amended
emended11329602_emended
intended102310412intended
mended104418682__mended
remended123010392remended
unbanded123010562unbanded
unblended13265852unblended
unbonded12299762unbonded
unceded11410562unce_ded
undenied102211562undenied
undented102313952undented
unfenced1437732unfenced
unfunded1336472unfunded
ungelded1147402ungelded
unhanded132910182unhanded
unheeded1336892unheeded
unkenned1336182unkenned
unleaded10411332unleaded
unmanned11268602unmanned
unmelted1169182unmelted
unmeshed1437002unmeshed
unmewed13258172unme_wed
unmined102612952unmin_ed
unmolded1237452unmolded
unneeded1036482unneeded
unpenned1137542unpenned
unrented92413922unrented
unseeded1038252unseeded
untented92613412untented
unwedded1435402unwedded
unweeded1336572unweeded
unwelded1337142unwelded
upended11267322u_pended
amender10349613_amender
appended1435483appended
ascended1246513ascended
attended1035763attended
augmented1343833augmented
bended105521233__bended
blended114710713_blended
cemented1338373cemented
commended17137013commended
contended1339273contended
defended1437223defended
demanded13348513demanded
demented12311273demented
depended1337983depended
emender10649843_emender
ended74421263___ended
engender1046633engender
enmeshed1444163enmeshed
expended19136543expended
extended17135833extended
fended114216913__fended
fomented1437803fomented
friended1335033friended
impended1435953impended
incensed11277953incensed
incented112412543incented
indented101811733indented
inmeshed1444483inmeshed
intendeds11265743intendeds
intender93310443intender
invented122510663invented
kneaded13146473kn_eaded
lamented1138193lamented
melded104714713__melded
mender93520793__mender
mensed93916543__mensed
minded103817833__minded
needed84114443_n_eeded
offended1643653offended
omened93711003_omen_ed
pended103819013__pended
remanded123011323remanded
reminded123411523reminded
rended84524103__rended
scended11329873_scended
sended85121233__sended
snedded10377393sn_edded
subtended1345153subtended
suspended13104513suspended
tended83819483__tended
trended94011763_trended
unadded10238523un_added
unaided92414603un_aided
unaneled939793unaneled
unattended1242523unattended
unavenged1443663unavenged
unbanned11279113unbanned
unbearded13146343unbearded
unbeared111611653unbeared
unbelted1179333unbelted
unbend9269773unben__d
unbends10236993unbend_s
unblinded13295233unblinded
unboned103014223unbon_ed
unbounded1335413unbounded
unbranded1336363unbranded
unbundled1344103unbundled
uncandid1244603uncandid
uncandled1345993uncandled
uncanned11289963uncanned
uncarded12310133uncarded
uncoded11312743un_coded
undecided1445983undecided
undecked16238493undecked
undefended1644003undefended
undeluded1244363undeluded
underdid11128133underdid
underfed13311713underfed
unendowed1443143un_endowed
unenvied1244653un_envied
unevaded1336423unevaded
unexpended2142703unexpended
unfaded123111733un_faded
unfeared121511013unfeared
unfelted1279403unfelted
unfence1239193unfence_
unfences1337933unfences
unfolded1338313unfolded
unfounded1435363unfounded
unfriended1542693unfriended
ungirded1136083ungirded
ungraded11209923ungraded
unguided1136233unguided
unhandled1445703unhandled
unhanged13258833unhanged
unhealed121511073unhealed
unheated121514553unheated
unhedged1434973unhedged
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257473unhinged
unhooded13277873unhooded
unimpeded1542793unimpeded
unintended1243513unintended
unjaded16279143un_jaded
unkeeled13117183unkeeled
unkend11309223unken__d
unkennel1243833unkennel
unkinder1335363unkinder
unkindled1594203unkindled
unkinked12215903unkinked
unladed92614373un_laded
unlamented1344353unlamented
unleadeds1143943unleadeds
unleased9310713unleased
unletted9310313unletted
unlevied1236843unlevied
unlined82515803unlin_ed
unlinked13237793unlinked
unloaded1049533unloaded
unmade92911063unm_ade_
unmailed11229763unmailed
unmanaged1344493unmanaged
unmapped1535173unmapped
unmarked15248813unmarked
unmarred11258403unmarred
unmasked15267143unmasked
unmated103317023unm_ated
unmatted1138293unmatted
unmeet83815743unme__et
unmerited1239643unmerited
unmeshes1346153unmeshes
unmilled1197853unmilled
unmingled1344283unmingled
unmitred1136843unmitred
unmixed17228213unm_ixed
unmoored1137333unmoored
unmounted1245903unmounted
unmoved13248903unm_oved
unnerved1248063unnerved
unopened1137023unopen_ed
unowned1148813unown_ed
unpadded1345183unpadded
unpeeled11118533unpeeled
unpegged1334353unpegged
unpinned1136383unpinned
unranked1338563unranked
unreeled91310333unreeled
unreeved12117673unreeved
unrenewed1344233unrenewed
unrested91914513unrested
unrinsed938383unrinsed
unrounded1135863unrounded
unscented1237513unscented
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseized1838443unseized
unserved12410233unserved
unsewed112911023unse_wed
unsexed152410253unse_xed
unshaded13149263unshaded
unsounded1135543unsounded
untanned9279963untanned
untenured1044933untenured
untested92612413untested
untinged10308943untinged
untreaded1137983untreaded
untuned82010823untun_ed
unveiled1298163unveiled
unveined1258003unveined
unversed122310433unversed
unvested122210223unvested
unvexed18147103unve_xed
unwanted12249603unwanted
unweaned1238593unweaned
unwetted1238123unwetted
unwinder1235613unwinder
unwonted12248643unwonted
unwooded13207443unwooded
unwounded1444623unwounded
unyeaned1237743unyeaned
unzoned172310653unzon_ed
vended114416353__vended
wended113616153__wended

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.453394461.4
2DLD Change Limit1461622246.46622604.7
3Display Results2242240.0932408.6
 (SQL Overall)1786912247.01225483.6
 
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.