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

104 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
shlocky1931450(None) 
schlocky22243381schlocky
shlock15378191shlock_
shlocks16317181shlocks
blocky17388352_blocky
flocky18468422_flocky
schlock18235872schlock_
schlocks19245692schlocks
shock144917032sh_ock_
shocks154414582sh_ocks
shticky19344472shticky
shylock1945052shylock_
shylocks2044152shylocks
stocky15369152s_tocky
block134917843_block_
blocks144513943_blocks
bullocky1943643bullocky
chock164316613ch_ock_
chocks174815313ch_ocks
choky175711223ch_o_ky
chucky20418003ch_ucky
clock134917983_clock_
clocks144916233_clocks
cocky164215933__cocky
colicky1835783colicky
flecky18387653_flecky
flock144717423_flock_
flocks154713533_flocks
hillocky2053403hillocky
hock136031303_h_ock_
hockey184813153_h_ockey
hocks144925493_h_ocks
honky156218523_h_onky
hooky155220263_h_ooky
kolacky1543203kolacky
lock106134363__lock_
locks115126923__locks
lucky145515013__lucky
mullocky1942813mullocky
plucky17406583_plucky
pocky165314603__pocky
relock124713523relock_
relocks134411293relocks
rocky144513853__rocky
shack145321753sh_ack_
shacko153810113sh_acko
shacks154817563sh_acks
shaky154616843sh__aky
sherlock1744243sherlock_
sherlocks1843953sherlocks
shlockier1842583shlockier
shlumpy1742863shlumpy
shmuck1734243shmuck_
shmucks1833943shmucks
shnook1366343shnook_
shnooks1485583shnooks
shoaly124010773sh_oaly
shocked174611813sh_ocked
shocker163411433sh_ocker
shoddy1434543sh_oddy
shoofly1634353shoofly
shook124920163sh_ook_
shooks134515633sh_ooks
shorty124313203sh_orty
showy145714013sh_o_wy
shrieky17364803shrieky
shtick15308023shtick_
shticks16356963shticks
shuck144314533sh_uck_
shucks154010413sh_ucks
shylocked2242203shylocked
silky125315823sil__ky
slack115021763s_lack_
slackly1635263s_lackly
slacks124416533s_lacks
sleeky13398963s_leeky
slick115520523s_lick_
slickly1635853s_lickly
slicks124816113s_licks
slinky13399103s_linky
slobby1334803s_lobby
sloppy1395303s_loppy
sloshy12366623s_loshy
slouchy15454843s_louchy
slowly1237153s_lowly
smock135311673s_mock_
smocks145710013s_mocks
smoky14388683s_mo_ky
smoochy17223863smoochy
sock105233213s__ock_
socko115215113s__ocko
socks114926083s__ocks
splotchy1841793splotchy
spooky15418093s_pooky
sticky154711343s_ticky
stock114417563s_tock_
stocks124715633s_tocks
sucky144415503s__ucky
sulky124715363sul__ky
talcky15294723tal_cky
unlock1248533unlock_
unlocks1337063unlocks
unlucky1643223unlucky
whacky21556493wh_acky

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271046.48620664.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911046.92225814.9
 
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.