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

248 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
shackler1731797(None) 
hackler163512351_hackler
shackle16409541shackle_
shackled18277601shackled
shacklers18336031shacklers
shackles173010591shackles
cackler153812572_cackler
chuckler1935552chuckler
hacker154822692_hack_er
hackle154916812_hackle_
hackled173312492_hackled
hacklers173710302_hacklers
hackles162917062_hackles
hacklier1737132_hacklier
heckler16278572_heckler
sacker125124842s_ack_er
shacked174015392shack_ed
shackoes17367852shackoes
shaker134319462sha_k_er
shakier143411152sha_kier
sharker144313812shark_er
shicker163914822shick_er
shocker163411432shock_er
shucker163710102shuck_er
slacker133915292slack_er
smacker153410582smack_er
snacker133112602snack_er
spackle15369572spackle_
spackled17297802spackled
spackles16319952spackles
sparkler14317982sparkler
stacker134416262stack_er
stickler14259572stickler
suckler133413092s_uckler
tackler134013322_tackler
whacker19368502whack_er
whackier2044672whackier
backer144525523_back_er
blacker154513513black_er
blackleg1734233blackleg
buckler154112033_buckler
cackle143416923_cackle_
cackled164613303_cackled
cacklers163710703_cacklers
cackles153717203_cackles
chalkier1736753chalkier
chandler14358373chandler
checker18329533check_er
chuckle1836443chuckle_
chuckled2045163chuckled
chucklers2034443chucklers
chuckles1936803chuckles
clacker153813773clack_er
cracker153114173crack_er
crackle153611253crackle_
crackled17428863crackled
crackles164111273crackles
cracklier1744823cracklier
dacker134920753_dack_er
fickler16348423_fickler
grackle14338893grackle_
grackles15309183grackles
hacked164923513_hack_ed
hackee154921833_hack_ee
hackees165014103_hackees
hackers164619043_hack_ers
hackie154615623_hackie_
hackies163418243_hackies
hackly18298733_hackl_y
hackmen1836713_hackmen
hackney1935123_hackney
haggler12328933_haggler
hailer94720343_ha_iler
haler85033523_ha__ler
handler113516163_handler
hanker134622093_hank_er
hauler95015123_ha_uler
hawker164812663_hawk_er
heckle153112093_heckle_
heckled17318463_heckled
hecklers17357123_hecklers
heckles163711383_heckles
hocker155118563_hock_er
huckle153913073_huckle_
huckles163612623_huckles
jacker194417583_jack_er
jackleg2135043_jackleg
knacker12307913knack_er
knuckler1383623knuckler
lacker125325623_lack_er
mackle143716433_mackle_
mackled164111923_mackled
mackles154415753_mackles
mickler153310233_mickler
packer144223403_pack_er
quackier23215373quackier
racker124824553_rack_er
rackle123917293_rackle_
sacked135525213s_ack_ed
sackers133820223s_ack_ers
saddler93811963s_addler
sailer63526103s_a_iler
saker95132023s_a_k_er
sampler113212013s_ampler
sarkier113413313s_arkier
scaler84321603s__caler
sealer63928963sea__ler
shabbier1535183shabbier
shack145321753shack___
shacking184014083shacking
shackling19286173shackling
shacko153810113shack__o
shackos16429023shack_os
shacks154817563shack__s
shader104218763sha__der
shadier113111153sha_dier
shadower1544863shadower
shaggier13116053shaggier
shake124726403sha_k_e_
shaken134113613sha_k_en
shakers144015563sha_k_ers
shakes135024593sha_k_es
shakoes144510023sha_koes
shale85332833sha__le_
shaled105023953sha__led
shales94731253sha__les
shaley123714993sha__ley
shalier103116423sha_lier
shamble14149263shamble_
shambled16156153shambled
shambles15159043shambles
shammer144613143sha_mmer
shanked153212123shank_ed
shapelier1444463shapelier
shaper114119933sha__per
sharer95025483sha__rer
sharked153613913shark_ed
sharkers154011053shark_ers
sharper124312703sha_rper
shatter103615703sha_tter
shauled1148793sha_uled
shaver123718913sha__ver
shawled1437773sha_wled
sheller103515883sh_eller
shickers173012823shick_ers
shikker13277023sh_ikker
shingler12268633shingler
shirker143711343shirk_er
shlockier1842583shlockier
shoaler102610083sh_oaler
shocked174611813shock_ed
shockers17319463shock_ers
shoveler14165583shoveler
shriller1136823shriller
shtickier1843163shtickier
shucked17389833shuck_ed
shuckers17388133shuck_ers
shuffler17306803shuffler
shuttler1164903shuttler
sicker124023903s_ick_er
sickle124418323s_ickle_
sickled144713433s_ickled
sickles133417543s_ickles
sicklier1457213s_icklier
skanker10268483skank_er
skankier11184883skankier
slacked143815453slack_ed
slacken13399933slack_en
slackener1543933slackener
slackers143812743slack_ers
slackly1635263slackl_y
slaker104219273sla_k_er
slicker133314533slick_er
smacked163710993smack_ed
smackers16318713smack_ers
smaller93410333sma_ller
snacked144013113snack_ed
snackers143010223snack_ers
snakier112810003sna_kier
snarkier12336513snarkier
snarler73610633sna_rler
snicker133012673snick_er
soaker105717533soa_k_er
spacer104917793spac__er
spacier114011633spac_ier
spaller92713473spa_ller
spanker133612353spank_er
sparker133914363spark_er
sparkier14298033sparkier
sparkle133710213sparkle_
sparkled15317733sparkled
sparklers15315643sparklers
sparkles143210493sparkles
sparklet143110593sparklet
sparklier1554363sparklier
speckle15297553speckle_
speckled17255833speckled
speckles16268133speckles
stabler94014933sta_bler
stacked143416123stack_ed
stackers143413563stack_ers
stackless1555933stackless
staler64025823sta__ler
stalker113912253stalk_er
stalkier1257073stalkier
stapler93913633sta_pler
starker114114693stark_er
startler8248793startler
sticker133515883stick_er
stickier14229763stickier
stickle132410973stickle_
stickled15298973stickled
sticklers15227393sticklers
stickles142512103stickles
stocker133713083stock_er
stockier14217253stockier
sucker124120663s_uck_er
suckier133613973s_uckier
suckle124015963s_uckle_
suckled144212513s_uckled
sucklers14379963s_ucklers
suckles134516743s_uckles
swacked173110523swack_ed
swanker14369483swank_er
swankier15225503swankier
tacker124224503_tack_er
tackier133712523_tackier
tackle123815733_tackle_
tackled143913193_tackled
tacklers143010773_tacklers
tackles133816523_tackles
thacked173810203thack_ed
thaler94613103tha__ler
thanker14309593thank_er
thicker163611023thick_er
thwacker2042873thwack_er
tickler133612653_tickler
tracker133515173track_er
truckler14297453truckler
unshackle1842763unshackle_
unshackled2042243unshackled
unshackles1941993unshackles
wacker154920123_wack_er
wackier16369733_wackier
whacked20458623whack_ed
whackers20326543whack_ers
whaler124611973wha__ler
whicker19359773whick_er

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 Limit1461622487.00020880.3
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.51623774.7
 
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.