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

171 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
undocks143616(None) 
uncocks1537231uncocks
undock1337701undock_
unlocks1337061unlocks
burdocks1744032burdocks
docks126022312__docks
gunlocks1544682gunlocks
knocks11397442kn_ocks
nocks115121012_n_ocks
redocks14409932redocks
ruddocks1643042ruddocks
sundecks1544252sundecks
unblocks1644522unblocks
uncock1438562uncock_
uncorks1337442uncorks
undocked16277632undocked
undoers82910582undoers
undoes73917402undo_es
unfrocks1753842unfrocks
unhooks1436412unhooks
unlock1248532unlock_
unpacks1576092unpacks
unpicks1545182unpicks
untacks1357502untacks
untucks1334672untucks
anticks134612253anticks
bannocks1644353bannocks
bedecks1635793bedecks
bedrocks1745333bedrocks
bemocks1735373bemocks
blocks144513943_blocks
bocks134526573__bocks
bonnocks1644623bonnocks
boondocks1863023boondocks
brocks145214153_brocks
bullocks1636293bullocks
burdock1644603burdock_
buttocks1645233buttocks
chocks174815313_chocks
clocks144916233_clocks
cocks135227163__cocks
crocks145118423_crocks
decks124822193__decks
dicks125824693__dicks
dock116228743__dock_
docs75631153__doc_s
dorks105724443__dorks
ducks124823213__ducks
endocast1146683endocast
endows104610423endo_ws
flocks154713533_flocks
frocks154111213_frocks
futtocks1743833futtocks
gundogs1034603gundo_gs
gunlock1444563gunlock_
gunstocks1643233gunstocks
haddocks1984903haddocks
hocks144925493__hocks
hummocks2163453hummocks
indices103513443indices
indicts103210723indicts
indoles83716363indoles
indols74714203indo_ls
indoors838553indoors
indows104210793indo_ws
induces103611813induces
inducts10259573inducts
jocks185118083__jocks
knacks11428543kn_acks
knock10487963kn_ock_
locks115126923__locks
medicks16368413medicks
mocks135023823__mocks
mudrocks1743993mudrocks
mullocks1645033mullocks
necks115119333_n_ecks
nicks114920493_n_icks
nock106127183_n_ock_
nooks95420393_n_ooks
nubucks1544003nubucks
nudnicks1542403nudnicks
nudniks1262333nudniks
outrocks1437903outrocks
paddocks1894323paddocks
padlocks1755473padlocks
padouks1434873padouks
piddocks1893653piddocks
pocks135022963__pocks
recocks154711463recocks
redock134311543redock_
relocks134411293relocks
rocks114626413__rocks
ruddock1543133ruddock_
runbacks1655903runbacks
rundowns1284533rundowns
shlocks16317183shlocks
shocks154414583_shocks
smocks145710013_smocks
snacks124514553sn_acks
snecks124410033sn_ecks
snicks124312473sn_icks
snooks104412833sn_ooks
socks114926083__socks
stocks124715633_stocks
sunblocks1743413sunblocks
sundeck1445273sundeck_
sundogs947103sundo_gs
sundowns1285433sundowns
trocks123614633_trocks
tussocks1443333tussocks
udons65411463u_do_ns
udos56619903u_do__s
umiacks1534013umiacks
unblock1545793unblock_
unbolts9247803unbolts
unboxes16208303unboxes
uncloaks1444133uncloaks
uncocked17248753uncocked
uncoils979533uncoils
uncork1239043uncork_
uncos74117033un__cos
uncus74014983un__cus
undecked16238493undecked
undies73821963und_ies
undines8716083undines
undo55620153undo___
undocile1145953undocile
undocking1735653undocking
undoer73113043undo_er
undoing9312243undoing
undoings1035793undoings
undone7914253undo_ne
undraws1136893undraws
undress838893undress
unfolds11146803unfolds
unfrock1674633unfrock_
unhoods1137503unhoods
unhook1347523unhook_
unhusks1443263unhusks
unions64216753unio_ns
unkinks10265413unkinks
unlaces92513623unlaces
unlinks11307403unlinks
unloads8278523unloads
unlocked15268383unlocked
unlucky1643223unlucky
unmasks1344553unmasks
unmolds10135743unmolds
unmoors945903unmoors
unpack1457833unpack_
unpick1446903unpick_
unrobes9269733unrobes
unrolls797793unrolls
unroofs1035783unroofs
unroots738563unroots
unstacks1446043unstacks
unsticks1436233unsticks
untack1239763untack_
untracks1437523untracks
untuck1236403untuck_
unvocal1245233unvocal
unvoices13125163unvoices
unyoke1367293unyo_ke
unyokes1466733unyokes
updos8389513updo__s
upticks1535153upticks
wedlocks1844393wedlocks
windsocks1943073windsocks
winnocks1743873winnocks
yapocks18354723yapocks
yocks144418373__yocks

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271716.53320515.4
3Display Results1711710.0602850.0
 (SQL Overall)1786911717.01325480.0
 
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.