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

204 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
unpenned113754(None) 
unkenned1336181unkenned
unpinned1136381unpinned
penned94217612__penned
unbanned11279112unbanned
unbended12279972unbended
uncanned11289962uncanned
undenied102211562undenied
undented102313952undented
unended92811822un_ended
unfenced1437732unfenced
unkennel1243832unkennel
unmanned11268602unmanned
unmended12299092unmended
unopened1137022unope_ned
unpeeled11118532unpeeled
unpegged1334352unpegged
unplanned1244412unplanned
unpruned1136862unpruned
unrented92413922unrented
untanned9279962untanned
untended102611152untended
untented92613412untented
unveined1258002unveined
unweaned1238592unweaned
unyeaned1237742unyeaned
upended11267322u_pended
appended1435483appended
cayenned1443163cayenned
denned84215633__denned
depended1337983depended
dungeoned1242743dungeoned
enplaned1137483enplaned
expended19136543expended
expensed18126413expensed
impended1435953impended
incensed11277953incensed
incented112412543incented
indented101811733indented
inspanned1242853inspanned
intended102310413intended
interned93016653interned
invented122510663invented
japanned1843143japanned
julienned1741313julienned
kenned114411273__kenned
mispenned1445413mispenned
neoned7311483_n_eoned
opened94311863_ope_ned
panned94123433__panned
peened94318163__peened
peined94918843__peined
pended103819013__pended
penne75423853__penne_
penner84616663__penner
pinned94818383__pinned
punned93416193__punned
repented112614983repented
repinned1157473repinned
ripened1038203ripe_ned
spanned104111223_spanned
speaned103411523_speaned
subpenaed1444773subpenaed
suntanned1044013suntanned
suspended13104513suspended
unamended1344853unamended
unaneled939793unaneled
unatoned939423unatoned
unavenged1443663unavenged
unbanded123010563unbanded
unbeared111611653unbeared
unbelted1179333unbelted
unbend9269773unbe_n_d
unblended13265853unblended
unbonded12299763unbonded
unboned103014223un_boned
unbonnet1047173unbonnet
unburned11227413unburned
unceded11410563unce_ded
uncleaned1237173uncleaned
uncoined111813023uncoined
undecked16238493undecked
undefined1445873undefined
underfed13311713underfed
unearned9310063unearned
unenvied1244653un_envied
unexpended2142703unexpended
unfeared121511013unfeared
unfeigned1453293unfeigned
unfelted1279403unfelted
unfence1239193unfence_
unfences1337933unfences
unfunded1336473unfunded
ungelded1147403ungelded
ungowned1335183ungowned
unhanded132910183unhanded
unhanged13258833unhanged
unhealed121511073unhealed
unheated121514553unheated
unhedged1434973unhedged
unheeded1336893unheeded
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257473unhinged
unironed939083unironed
unjoined16248443unjoined
unkeeled13117183unkeeled
unkend11309223unke_n_d
unkenneled1542333unkenneled
unkennels1342573unkennels
unkinked12215903unkinked
unleaded10411333unleaded
unlearned1035653unlearned
unleased9310713unleased
unletted9310313unletted
unlevied1236843unlevied
unlined82515803un_lined
unlinked13237793unlinked
unmelted1169183unmelted
unmeshed1437003unmeshed
unmewed13258173unme_wed
unmined102612953un_mined
unneeded1036483unneeded
unnerved1248063unnerved
unowned1148813un_owned
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unp_aged
unpainted1237183unpainted
unpaired11208943unpaired
unparted11310823unparted
unpaved133410053unp_aved
unpen72913573unpe_n__
unpenning1236183unpenning
unpens82511013unpe_n_s
unpent83117373unpe_n_t
unpeopled1444533unpeopled
unpicked17237213unpicked
unpierced1443443unpierced
unpiled102312743unp_iled
unpitied1138793unpitied
unpitted1148623unpitted
unplaced1338613unplaced
unplanted1236853unplanted
unplayed1437263unplayed
unpleased1236083unpleased
unpledged1443843unpledged
unplowed1436353unplowed
unpointed1237153unpointed
unpoised1139183unpoised
unpolled1168943unpolled
unposed10711903unp_osed
unposted1159433unposted
unpotted11108393unpotted
unpressed1237953unpressed
unpriced1338143unpriced
unprimed1337203unprimed
unprinted1238133unprinted
unprized2038513unprized
unprobed1366973unprobed
unproved1457533unproved
unpurged1236293unpurged
unranked1338563unranked
unreeled91310333unreeled
unreeved12117673unreeved
unrefined1345463unrefined
unrenewed1344233unrenewed
unrested91914513unrested
unrinsed938383unrinsed
unripened1244393unripe_ned
unscanned1245133unscanned
unscented1237513unscented
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseeded1038253unseeded
unseized1838443unseized
unserved12410233unserved
unsewed112911023unse_wed
unsexed152410253unse_xed
unsigned1037563unsigned
unstoned9311043unstoned
untenanted1144453untenanted
untenured1044933untenured
untested92612413untested
untinged10308943untinged
untuned82010823un_tuned
unturned9228563unturned
untwined1237063untwined
unveiled1298163unveiled
unversed122310433unversed
unvested122210223unvested
unvexed18147103unve_xed
unwanted12249603unwanted
unwarned1238453unwarned
unwedded1435403unwedded
unweeded1336573unweeded
unwelded1337143unwelded
unwetted1238123unwetted
unwonted12248643unwonted
unzoned172310653un_zoned
upend85011043u_pe_n_d
yenned10409383__yenned

Search took 9 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.420425454.8
2DLD Change Limit1461622047.56319325.9
3Display Results2042040.0802550.0
 (SQL Overall)1786912048.06322161.9
 
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.