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

94 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
schlocks1924569(None) 
schlock18235871schlock_
schlocky22243381schlocky
shlocks16317181s_hlocks
chocks174815312_ch_ocks
clocks144916232_c_locks
schmucks2142762schmucks
schnooks1754242schnooks
schticks19193952schticks
shlock15378192s_hlock_
shlocky19314502s_hlocky
shocks154414582s_h_ocks
shylocks2044152shylocks
armlocks1643963armlocks
blocks144513943__blocks
bollocks1636503bollocks
bullocks1636293bullocks
charlocks2044073_charlocks
checks174912703_ch_ecks
chicks175317593_ch_icks
chock164316613_ch_ock_
chooks155312793_ch_ooks
chucks174812933_ch_ucks
clacks144516343_c_lacks
clicks145315113_c_licks
cloaks124411263_c_loaks
clock134917983_c_lock_
clonks125013473_c_lonks
clucks144512073_c_lucks
cocks135227163_c__ocks
crocks145118423_c_rocks
daglocks1643993daglocks
earlocks1435693earlocks
elflocks1742743elflocks
fetlocks1744713fetlocks
flocks154713533__flocks
gunlocks1544683gunlocks
hemlocks1944993hemlocks
hillocks1736063hillocks
hocks144925493__h_ocks
killocks1354793killocks
locks115126923___locks
matchlocks2352303matchlocks
mullocks1645033mullocks
oarlocks1445103oarlocks
padlocks1755473padlocks
picklocks1843433picklocks
pollocks1656473pollocks
relocks134411293_relocks
rowlocks1744353rowlocks
schlepps1762563schlepps
schleps1445483schl_eps
schlockier2141703schlockier
schlockiest2251963schlockiest
schlubs1443193schl_ubs
schlumps1742743schlumps
schmoes14308543schmo_es
schmoos14347513schmo_os
schmos13379153schmo__s
schmuck2043043schmuck_
schnecke1942603schnecke
schnook1654483schnook_
schnozes2244493schnozes
scholars1336683scholars
schools1249113sch_ools
schorls1248353sch_orls
schriks16185743sch_riks
schrods1337433schro_ds
schtick18194523schtick_
schtiks16184743sch_tiks
scoleces1237083scoleces
scolices1238733scolices
sculks123610263scul__ks
seacocks1645643seacocks
shacks154817563s_h_acks
sherlocks1843953sherlocks
shmucks1833943s_hmucks
shnooks1485583s_hnooks
shock144917033s_h_ock_
shooks134515633s_h_ooks
shticks16356963s_hticks
shucks154010413s_h_ucks
shylock1945053shylock_
slacks124416533s__lacks
slicks124816113s__licks
smocks145710013s__mocks
socks114926083s___ocks
stocks124715633s__tocks
subblocks1943003subblocks
sunblocks1743413sunblocks
unblocks1644523unblocks
unlocks1337063_unlocks
warlocks1735363warlocks
wedlocks1844393wedlocks

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 Limit146162947.43619656.0
3Display Results94940.0332848.5
 (SQL Overall)178691947.89222642.0
 
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.