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

150 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
unneeded103648(None) 
unheeded1336891unheeded
unseeded1038251unseeded
unweeded1336561unweeded
needed84114442__needed
unbended12279972unbended
unceded11410562u_nceded
unended92811822u_nended
ungelded1147402ungelded
unkeeled13117182unkeeled
unleaded10411332unleaded
unmended12299092unmended
unnerved1248062unnerved
unpeeled11118532unpeeled
unreeled91310332unreeled
unreeved12117672unreeved
untended102611152untended
unwedded1435392unwedded
unwelded1337132unwelded
annealed936333annealed
annexed1535753ann_exed
anteceded1343463anteceded
conceded1438283conceded
deeded94615543__deeded
exceeded1943493exceeded
funneled1254873funn_eled
funnelled1374233funnelled
heeded114215763__heeded
innerved1246293innerved
intended102310413intended
kneaded13146473_kneaded
kneeled12328063_kneeled
needer73614953__needer
needled9358513__needled
reeded84022563__reeded
reseeded1038093reseeded
screeded1235633screeded
seeded84520463__seeded
snedded10377393_snedded
sneered83113973_sneered
sneezed17287793_sneezed
speeded113310423_speeded
succeeded1542383succeeded
tunneled955233tunn_eled
tunnelled1054583tunnelled
unadded10238523u_nadded
unaided92414603u_naided
unamended1344853unamended
unaneled939793unaneled
unannexed1743543unannexed
unbanded123010563unbanded
unbearded13146343unbearded
unbeared111611653unbeared
unbelted1179333unbelted
unblended13265853unblended
unbonded12299763unbonded
uncarded12310133uncarded
unchewed1735803unchewed
uncoded11312743u_ncoded
uncrewed1456763uncrewed
undecided1445983undecided
undecked16238493undecked
undefended1644003undefended
undeleted1148063undeleted
undeluded1244363undeluded
undenied102211563undenied
undented102313953undented
underdid11128133underdid
underfed13311713underfed
unentered1037573unentered
unenvied1244653unenvied
unevaded1336423unevaded
unfaded123111733u_nfaded
unfeared121511013unfeared
unfelted1279403unfelted
unfenced1437733unfenced
unfledged1543553unfledged
unflexed1935253unflexed
unfolded1338313unfolded
unfreed11510123unfre_ed
unfunded1336473unfunded
ungirded1136083ungirded
ungraded11209923ungraded
unguided1136233unguided
unhanded132910183unhanded
unhealed121511073unhealed
unheated121514553unheated
unhedged1434963unhedged
unhelmed1435993unhelmed
unhelped1435923unhelped
unhooded13277873unhooded
unideaed1045733unideaed
unimpeded1542793unimpeded
unindexed1843063unindexed
unintended1243513unintended
unjaded16279143u_njaded
unkenned1336183unkenned
unladed92614373u_nladed
unleadeds1143943unleadeds
unleased9310713unleased
unletted9310313unletted
unleveled1344973unleveled
unlevied1236843unlevied
unloaded1049533unloaded
unmelted1169183unmelted
unmeshed1437003unmeshed
unmewed13258173u_nmewed
unmolded1237453unmolded
unnailed9229443unnailed
unnamed102410273unn_amed
unneedful1351763unneedful
unnerve1066653unnerve_
unnerves1157273unnerves
unnoted8311363unn_oted
unopened1137023unopened
unpadded1345183unpadded
unpegged1334353unpegged
unpenned1137543unpenned
unpledged1443833unpledged
unreeler8127293unreeler
unreeve10176763unreeve_
unreeves11106163unreeves
unrenewed1344233unrenewed
unrented92413923unrented
unrested91914513unrested
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseized1838443unseized
unserved12410233unserved
unsewed112911023u_nsewed
unsexed152410253u_nsexed
unshaded13149263unshaded
unsteeled1045753unsteeled
untented92613413untented
untested92612413untested
untreaded1137983untreaded
unveiled1298163unveiled
unveined1258003unveined
unversed122310433unversed
unvested122210223unvested
unvexed18147103u_nvexed
unweaned1238593unweaned
unwetted1238123unwetted
unwooded13207443unwooded
unyeaned1237743unyeaned
upended11267323u_pended
veneered1235983veneered
weeded113914873__weeded

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.1561145455.1
2DLD Change Limit1461621506.45322650.2
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.67226782.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.