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

207 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
undecked1623849(None) 
undocked16277631undocked
bedecked1874572bedecked
decked145217622__decked
necked134715062_n_ecked
unbacked17268732unbacked
unchecked2144062unchecked
uncocked17248752uncocked
undecayed1645172undecayed
undecided1445982undecided
undenied102211562undenied
undented102313952undented
underfed13311712underfed
unlicked15248262unlicked
unlocked15268382unlocked
unpacked17268662unpacked
unpicked17237212unpicked
untacked15239922untacked
untucked15206052untucked
anticked1538393anticked
becked155417763__becked
checked193710023_checked
deckel134911043__deckel
decker135215993__decker
deked115718533__de_ked
dicked144920863__dicked
docked145018333__docked
ducked144718013__ducked
endeared1038053endeared
flecked17358073_flecked
gecked146911933__gecked
henpecked2141893henpecked
indebted12246873indebted
indeed83913563inde__ed
indented101811733indented
indexed16347363inde_xed
indicted1249203indicted
induced11298933induc_ed
inducted1237273inducted
infected14229403infected
injected18226753injected
invected14258873invected
kecked125113163__kecked
knacked13287793kn_acked
knocked13236293kn_ocked
necker124012793_n_ecker
nicked135019683_n_icked
nocked134617383_n_ocked
pecked155019103__pecked
recked134821803__recked
rednecked1743163rednecked
redocked16206823redocked
snacked144013113sn_acked
sneaked12329693sn_eaked
snicked143811633sn_icked
specked16329013_specked
sundeck1445273sundeck__
sundecks1544253sundeck_s
sundered10312153sunde_red
unacted10312733un_acted
unarched14128553unarched
unasked122010023un_asked
unawaked1635903unawaked
unbaked143312893un_baked
unbeared111611653unbeared
unbelted1179333unbelted
unbended12279973unbended
unblocked1864353unblocked
unbraked15289413unbraked
unbuckled1843633unbuckled
uncaked143514353un_caked
uncasked15278453uncasked
unceded11410563unce_ded
unchoked18257623unchoked
uncooked15269113uncooked
uncorked152210403uncorked
uncracked18226803uncracked
undamped1445333undamped
undated93118463und_ated
undead82711903unde__ad
undebated1338093undebated
undeceived1743993undeceived
undecideds1542233undecideds
undeclared1445043undeclared
undee65327273unde__e_
undefaced1644753undefaced
undefiled1446113undefiled
undefined1445873undefined
undeleted1148063undeleted
undeluded1244363undeluded
underacted1449253underacted
underaged121011233underaged
underbaked1846173underbaked
underbid12108203underbid
underbred1338993underbred
underbud12136213underbud
undercard1347003undercard
underclad1345563underclad
undercooked1943713undercooked
underdid11128133underdid
underfeed1448633underfeed
undergod1136583undergod
underived14310513underived
underlet91516213underlet
undersea9149883undersea
underset91417133underset
underused1139333underused
undesired1147523undesired
undetected1444873undetected
undimmed1434113undimmed
undirected1445023undirected
undock1337703undock__
undocks1436163undock_s
undotted1048523undotted
undraped1239393undraped
undreamed1336973undreamed
undressed1138343undressed
undried92314613und_ried
undubbed1443523undubbed
undulled1036993undulled
undyed1138143und__yed
unedited10249833unedited
unelected1237823unelected
unended92811823un_ended
unfaked153211173un_faked
unfeared121511013unfeared
unfelted1279403unfelted
unfenced1437733unfenced
unforked16218953unforked
unfrocked1944223unfrocked
ungelded1147403ungelded
unhealed121511073unhealed
unheated121514553unheated
unhedged1434963unhedged
unheeded1336893unheeded
unhelmed1435993unhelmed
unhelped1435923unhelped
unhooked16286743unhooked
unhusked1634603unhusked
unideaed1045733unide_aed
unkeeled13117183unkeeled
unkenned1336183unkenned
unkinked12215903unkinked
unlaced102913733unlac_ed
unleaded10411333unleaded
unleased9310713unleased
unletted9310313unletted
unlevied1236843unlevied
unliked122411283un_liked
unlinked13237793unlinked
unmarked15248813unmarked
unmasked15267143unmasked
unmelted1169183unmelted
unmended12299093unmended
unmeshed1437003unmeshed
unmewed13258173unme_wed
unneeded1036483unneeded
unnerved1248063unnerved
unpacker16215893unpacker
unpeeled11118533unpeeled
unpegged1334353unpegged
unpenned1137543unpenned
unplucked1843573unplucked
unpucker16234273unpucker
unraked122914013un_raked
unranked1338563unranked
unreached1536883unreached
unrebuked1652673unrebuked
unreeled91310333unreeled
unreeved12117673unreeved
unrented92413923unrented
unrested91914513unrested
unrevoked1743423unrevoked
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unsecured1244903unsecured
unseeded1038253unseeded
unseized1838443unseized
unserved12410233unserved
unsewed112911023unse_wed
unsexed152410253unse_xed
unsicker1435303unsicker
unslaked1338463unslaked
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unstacked1636433unstacked
unstocked1645063unstocked
untended102611153untended
untented92613413untented
untested92612413untested
untracked16228373untracked
unveiled1298163unveiled
unveined1258003unveined
unversed122310433unversed
unvested122210223unvested
unvexed18147103unve_xed
unweaned1238593unweaned
unwedded1435393unwedded
unweeded1336563unweeded
unwelded1337133unwelded
unwetted1238123unwetted
unworked16238503unworked
unyeaned1237743unyeaned
unyoked1567123un_yoked
wrecked17418333_wrecked

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.1561145455.1
2DLD Change Limit1461622078.53317129.0
3Display Results2072070.0762723.7
 (SQL Overall)1786912078.76520386.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.