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

101 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
earlocks143569(None) 
earlock1336921earlock_
oarlocks1445101oarlocks
warlocks1735361warlocks
armlocks1643962_armlocks
charlocks2044072charlocks
daglocks1643992daglocks
deadlocks1743802deadlocks
earlobes1056142earlobes
elflocks1742742elflocks
hairlocks1863772hairlocks
headlocks1944462headlocks
oarlock1336122oarlock_
padlocks1755472padlocks
warlock1636292warlock_
armlock1544313_armlock_
arracks1387733_arracks
bannocks1644353bannocks
barlows12259973barlo_ws
barracks1636883barracks
bawcocks21113443bawcocks
bedrocks1745333bedr_ocks
blocks144513943__blocks
bollocks1636503bollocks
brocks145214153_br_ocks
bullocks1636293bullocks
burdocks1744033burdocks
caprocks1835943caprocks
caracks152211563car_acks
cariocas1239663cariocas
carjacks2345573carjacks
carloads1138393carloads
carracks1637713carracks
cassocks1645033cassocks
charlock1944393charlock_
clocks144916233__clocks
crocks145118423_cr_ocks
daglock1544263daglock_
deadlock1644233deadlock_
defrocks1844113defr_ocks
dornocks1544093dornocks
dreadlocks1852193dreadlocks
earlaps936393earl_aps
earldoms1144223earldoms
earless74316073earl_ess
earlobe946543earlo_be
earls56127513earl___s
earmarks1444793earmarks
earworms1346783earworms
elflock1642973elflock_
fetlocks1744713fetlocks
firelocks1844233firelocks
flocks154713533__flocks
forelocks1844743forelocks
frocks154111213_fr_ocks
garlicky1842123garlicky
garlics1038013garlic_s
gavelocks1942793gavelocks
gorcocks1743423gorcocks
gunlocks1544683gunlocks
haddocks1984903haddocks
hairlock1754023hairlock_
hammocks2164343hammocks
harlots103413293harlo_ts
hassocks1744693hassocks
havelocks2143263havelocks
haycocks2244113haycocks
headlock1844813headlock_
hemlocks1944993hemlocks
hillocks1736063hillocks
killocks1354793killocks
lavrocks1743663lavrocks
locks115126923___locks
mammocks1763893mammocks
mattocks1644983mattocks
mullocks1645033mullocks
paddocks1894323paddocks
padlock1665813padlock_
parlors9312913parlo_rs
parlours1036153parlours
parlous9414293parlo_us
peacocks1844993pea_cocks
pollocks1656473pollocks
relocks134411293_relocks
rocks114626413__r_ocks
rowlocks1744353rowlocks
schlocks19245693schlocks
seacocks1645643sea_cocks
sherlocks1843953sherlocks
shlocks16317183_shlocks
shylocks2044153shylocks
tarocs84615663tar_oc_s
taroks106115283tar_o_ks
trocks123614633_tr_ocks
unblocks1644523unblocks
unlocks1337063_unlocks
warlords1245303warlords
warworks1877063warworks
wedlocks1844393wedlocks
yapocks18354723ya_pocks
yearbooks1842573yearbooks

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 Limit1461621017.25020160.3
3Display Results1011010.0303366.7
 (SQL Overall)1786911017.70323197.6
 
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.