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 “warlocks” 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
warlocks173536(None) 
earlocks1435691earlocks
oarlocks1445101oarlocks
warlock1636291warlock_
armlocks1643962_armlocks
charlocks2044072charlocks
daglocks1643992daglocks
earlock1336922earlock_
hairlocks1863772hairlocks
oarlock1336122oarlock_
padlocks1755472padlocks
warlords1245302warlords
warworks1877062warworks
wedlocks1844392wedlocks
armlock1544313_armlock_
arracks1387733_arracks
bannocks1644353bannocks
barlows12259973barlo_ws
barracks1636883barracks
bawcocks21113443bawcocks
blocks144513943__blocks
bollocks1636503bollocks
brocks145214153_br_ocks
bullocks1636293bullocks
burdocks1744033burdocks
caprocks1835943caprocks
caracks152211563car_acks
cariocas1239663cariocas
carjacks2345573carjacks
carloads1138393carloads
carracks1637713carracks
cassocks1645033cassocks
charlock1944393charlock_
clocks144916233__clocks
crocks145118423_cr_ocks
daglock1544263daglock_
deadlocks1743803deadlocks
dornocks1544093dornocks
earlobes1056143earlobes
elflocks1742743elflocks
fetlocks1744713fetlocks
firelocks1844233firelocks
flocks154713533__flocks
forelocks1844743forelocks
frocks154111213_fr_ocks
garlicky1842123garlicky
garlics1038013garlic_s
gavelocks1942793gavelocks
gorcocks1743423gorcocks
gunlocks1544683gunlocks
haddocks1984903haddocks
hairlock1754023hairlock_
hammocks2164343hammocks
harlots103413293harlo_ts
hassocks1744693hassocks
havelocks2143263havelocks
haycocks2244113haycocks
headlocks1944463headlocks
hemlocks1944993hemlocks
hillocks1736063hillocks
killocks1354793killocks
lavrocks1743663lavrocks
locks115126923___locks
mammocks1763893mammocks
mattocks1644983mattocks
mullocks1645033mullocks
paddocks1894323paddocks
padlock1665813padlock_
parlors9312913parlo_rs
parlours1036153parlours
parlous9414293parlo_us
pollocks1656473pollocks
relocks134411293_relocks
rocks114626413__r_ocks
rowlocks1744353rowlocks
schlocks19245693schlocks
sherlocks1843953sherlocks
shlocks16317183_shlocks
shylocks2044153shylocks
tarocs84615663tar_oc_s
taroks106115283tar_o_ks
trocks123614633_tr_ocks
unblocks1644523unblocks
unlocks1337063_unlocks
wacks146626283wa___cks
waesucks1742553waesucks
walks126218503wa_l__ks
wallops123410413wallo_ps
wallows133613533wallo_ws
warks127932403war___ks
warless104015103warl_ess
warlike142410473warl_ike
warlord1136293warlo_rd
warwork1757583warwork_
waxworks25114723waxworks
wedlock1744553wedlock_
winnocks1743873winnocks
wracks154711113w_r_acks
wrecks15418883w_r_ecks
wricks154610623w_r_icks
yapocks18354723ya_pocks

Search took 10 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.420425454.8
2DLD Change Limit1461621018.97016294.5
3Display Results1011010.0303366.7
 (SQL Overall)1786911019.42018969.3
 
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.