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

245 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
unlock124853(None) 
gunlock1444561gunlock
unblock1545791unblock
uncock1438561uncock
undock1337701undock
unlocks1337061unlocks
block134917842_block
bullock1537192bullock
clock134917982_clock
flock144717422_flock
gunlocks1544682gunlocks
knock10487962kn_ock
lock106134362__lock
mullock1535712mullock
nock106127182_n_ock
relock124713522relock
shlock15378192shlock
sunblock1643762sunblock
unblocks1644522unblocks
uncloak1365472uncloak
uncocks1537232uncocks
uncork1239042uncork
undocks1436162undocks
unfrock1674632unfrock
unhook1347522unhook
unlace82215172unlace
unlink104011012unlink
unload73010802unload
unlocked15268382unlocked
unlucky1643222unlucky
unpack1457832unpack
unpick1446902unpick
unslick1356022unslick
untack1239762untack
untuck1236402untuck
acock132110213_acock
alack114820063_alack
anlace82513923anlace
antick124814583antick
antilock1446523antilock
armlock1544313armlock
bannock1545043bannock
bemock1636173bemock
black134719073_black
bloc85023273_bloc_
blocks144513943_blocks
blocky17388353_blocky
blocs95219653_blocs
bock126032513__bock
bonnock1545203bonnock
brock136017073_brock
bullocks1636293bullocks
bullocky1943643bullocky
burdock1644603burdock
buttock1545563buttock
chock164316613_chock
clack134720173_clack
click135217953_click
cloak115214013_cloak
clocks144916233_clocks
clonk114417443_clonk
cluck134914893_cluck
cock126332903__cock
crock135921993_crock
daglock1544263daglock
dock116228743__dock
earlock1336923earlock
elflock1642973elflock
enlace82213233enlace
fetlock1645323fetlock
flack144519413_flack
fleck148213593_fleck
flick145017213_flick
floc95922123_floc_
flocks154713533_flocks
flocky18468423_flocky
flocs105519233_flocs
frock145314653_frock
futtock1644153futtock
gunstock1543463gunstock
hemlock1845633hemlock
hillock1646693hillock
hock136031303__hock
hummock2063793hummock
inlace82513043inlace
jock176522643__jock
killock1255253killock
klick105311443_klick
knack104311043kn_ack
knocks11397443kn_ocks
lack105837683__lack
lick106935083__lick
loca65527683__loca
loch95527133__loch
loci66126283__loci
locks115126923__locks
loco67030743__loco
look87333473__look
luck105329823__luck
mock126429443__mock
moloch1356483moloch
mudrock1644353mudrock
mullocks1645033mullocks
mullocky1942813mullocky
neck105423663_n_eck
nick106627613_n_ick
nocks115121013_n_ocks
nook85728493_n_ook
nubuck1434543nubuck
oarlock1336123oarlock
onload7268633onload
outlook1138023outlook
outrock1339303outrock
padlock1665813padlock
plack135017843_plack
plonk114613983_plonk
pluck134212303_pluck
pock126129293__pock
pollock1546843pollock
recock145112723recock
redock134311543redock
relocks134411293relocks
relook104813743relook
rock105735183__rock
rowlock1654783rowlock
ruddock1543133ruddock
runback1556603runback
schlock18235873schlock
shlocks16317183shlocks
shlocky19314503shlocky
shock144917033_shock
shylock1945053shylock
slack115021763_slack
slick115520523_slick
smock135311673_smock
snack114718063sn_ack
sneck114713663sn_eck
snick114416013sn_ick
snook95115573sn_ook
snuck114411913sn_uck
sock105233213__sock
stock114417563_stock
subblock1843673subblock
sunback1548153sunback
sunblocks1743413sunblocks
sundeck1445273sundeck
trock114817603_trock
tussock1343833tussock
umiack1435173umiack
unblocked1864353unblocked
unbolt83013893unbolt
unborn83310813unborn
unbox1438753unbo_x
unci65019463un__ci
uncloaks1444133uncloaks
unclog956603unclo_g
unclogs1036803unclogs
unclose91111643unclose
uncloud1046433uncloud
unco66021403un__co
uncocked17248753uncocked
uncoil8811853uncoil
uncool8610113uncool
uncorks1337443uncorks
uncos74117033unco_s
uncoy104111413unco_y
undo55620163undo__
undocked16277633undocked
undoer73113043undoer
undoes73917403undoes
undone7914253undone
unfold10179703unfold
unfond10149113unfond
unfrocks1753843unfrocks
unglove1136103unglove
ungot61718063ungo_t
unholy1238163unholy
unhood1039233unhood
unhooks1436413unhooks
unhusk1334263unhusk
union54519793unio_n
unions64216753unions
unkink9308713unkink
unlaced102913733unlaced
unlaces92513623unlaces
unlade72714153unlade
unlaid7311753unlaid
unlash938793unlash
unlatch1245053unlatch
unlay84613703unl_ay
unlays93810493unlays
unlead73312373unlead
unled64021073unl_ed
unless62413073unless
unlet54133333unl_et
unlicked15248263unlicked
unlike102614063unlike
unlinks11307403unlinks
unlit55025463unl_it
unlive92712333unlive
unloads8278523unloads
unlobed10219743unlobed
unlocking1636073unlocking
unloose797863unloose
unloved112310533unloved
unmask1265903unmask
unmold9148313unmold
unmoor836313unmoor
unmown11296093unmown
unpacks1576093unpacks
unpicks1545183unpicks
unrobe82611673unrobe
unroll61210073unroll
unroof9410193unroof
unroot6315553unroot
unrove92511683unrove
unsold71410513unsold
unsoncy1245513unsoncy
unsown9328433unsown
unstack1337373unstack
unstick1338123unstick
unstuck1345023unstuck
unsunk1036333unsunk
untacks1357503untacks
unto45824283unto__
untold7149683untold
untorn63012343untorn
untrack1338703untrack
untucks1334673untucks
unvocal1245233unvocal
unvoice12126153unvoice
unwon84512343unwo_n
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
uplink12388713uplink
upload9257783upload
uptick1436763uptick
veloce11310133veloce
warlock1636293warlock
wedlock1744553wedlock
winnock1643893winnock
yapock17365383yapock
yock135924613__yock
ziplock2454413ziplock

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 Filter1786911127160.406440125.6
2DLD Change Limit1127162455.95318934.3
3Display Results2452450.0803062.5
 (SQL Overall)1786912456.43927751.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.