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 “padlocks” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
padlocks175547(None) 
paddocks1894321paddocks
padlock1665811padlock_
daglocks1643992daglocks
deadlocks1743802deadlocks
earlocks1435692earlocks
haddocks1984902haddocks
headlocks1944462headlocks
oarlocks1445102oarlocks
paddock17104732paddock_
padlocked1942432padlocked
padouks1434872pad_ouks
piddocks1893652piddocks
pollocks1656472pollocks
warlocks1735362warlocks
wedlocks1844392wedlocks
armlocks1643963armlocks
bannocks1644353bannocks
bawcocks21113443bawcocks
bedrocks1745333bedrocks
blocks144513943__blocks
bollocks1636503bollocks
bullocks1636293bullocks
caprocks1835943caprocks
cassocks1645033cassocks
charlocks2044073charlocks
clocks144916233__clocks
daglock1544263daglock_
deadlock1644233deadlock_
docks126022313__d_ocks
dreadlocks1852193dreadlocks
earlock1336923earlock_
elflocks1742743elflocks
fetlocks1744713fetlocks
flocks154713533__flocks
gadzooks23112933gadzooks
gavelocks1942793gavelocks
gridlocks1742683gridlocks
gunlocks1544683gunlocks
haddock1885583haddock_
hairlocks1863773hairlocks
hammocks2164343hammocks
hassocks1744693hassocks
havelocks2143263havelocks
haycocks2244113haycocks
headlock1844813headlock_
hemlocks1944993hemlocks
hillocks1736063hillocks
killocks1354793killocks
lavrocks1743663lavrocks
locks115126923___locks
mammocks1763893mammocks
mattocks1644983mattocks
mudrocks1743993mudrocks
mullocks1645033mullocks
oarlock1336123oarlock_
packs135528933pa___cks
padauks1443943pad_auks
paddocked2042083paddocked
padles95221123padl__es
padlocking2043023padlocking
padouk1336683pad_ouk_
padrones112711043padrones
palaces114216453pa_laces
pallors9314363pallo_rs
palooka1344503pa_looka
palookas1443843pa_lookas
parlors9312913parlo_rs
parlours1036153parlours
parlous9414293parlo_us
pavlovas1642423pavlovas
paybacks2145493paybacks
payloads1445293payloads
peacocks1844993peacocks
petcocks1844583petcocks
picklocks1843433picklocks
piddock17103653piddock_
placks144414153p__lacks
plonks124210423p__lonks
plucks14379733p__lucks
pocks135022963p___ocks
pollacks1656373pollacks
pollock1546843pollock_
potlucks1643303potlucks
redocks14409933red_ocks
relocks134411293_relocks
roadblocks1952023roadblocks
rowlocks1744353rowlocks
ruddocks1643043ruddocks
schlocks19245693schlocks
shaddocks2043083shaddocks
shlocks16317183_shlocks
shylocks2044153shylocks
unblocks1644523unblocks
undocks1436163und_ocks
unlocks1337063_unlocks
warlock1636293warlock_
wedlock1744553wedlock_
yapocks18354723ya_pocks

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 Filter1786911461620.423422437.4
2DLD Change Limit146162996.71621763.3
3Display Results99990.0333000.0
 (SQL Overall)178691997.17224915.1
 
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.