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

170 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
shackoes1736785(None) 
shackles173010591shackles
shackos16429021shacko_s
shakoes144510021sha_koes
hackees165014102_hackees
hackies163418242_hackies
hackles162917062_hackles
shacked174015392shack_ed
shackle16409542shackle_
shackled18277602shackled
shackler17317972shackler
shacklers18336032shacklers
shacko153810112shacko__
shacks154817562shack__s
shakes135024592sha_k_es
shakos134912192sha_ko_s
spackles16319952spackles
whackos19375262whacko_s
ackees124914583__ackees
ashcakes1753733ashcak_es
backhoes1938543_backhoes
buckoes153810393_buckoes
cackles153717203_cackles
chickees19258513chickees
chuckies1937703chuckies
chuckles1936803chuckles
crackles164111273crackles
geckoes14325793_geckoes
grackles15309183grackles
hacked164923513_hack_ed
hackee154921833_hack_ee
hacker154822693_hack_er
hackers164619043_hackers
hackie154615623_hackie_
hackle154916813_hackle_
hackled173312493_hackled
hackler163512353_hackler
hacklers173710303_hacklers
hackmen1836713_hackmen
hackney1935123_hackney
hackneys2033683_hackneys
hacks144928713_hack__s
hakes126034303_ha_k_es
halloes104021523_halloes
haloes94623863_ha_loes
hankies143617763_hankies
hawkies173311243_hawkies
heckles163711383_heckles
hickies163614743_hickies
huckles163612623_huckles
jackies202912623_jackies
mackles154415753_mackles
sacked135525213s_ack_ed
sacker125124843s_ack_er
sackers133820223s_ackers
sacks114228873s_ack__s
sacques18106863s_acques
sakes95540753s_a_k_es
salvoes102811313s_alvoes
shack145321753shack___
shacking184014083shacking
shades105924533sha__des
shadoofs1554233shadoofs
shadows1437193sha_dows
shahdoms1743773shahdoms
shake124726403sha_k_e_
shaken134113613sha_k_en
shaker134319463sha_k_er
shakers144015563sha_kers
shakier143411153sha_kier
shakiest151910933sha_kiest
shako125516093sha_ko__
shales94731253sha__les
shallops13288323shallops
shallots11319503shallots
shallows14388863shallows
shaloms1288983sha_loms
shambles15159043shambles
shames114726223sha__mes
shammes144312833sha_mmes
shammies15259683shammies
shammos14307203shammo_s
shamois123210423sha_mois
shamos114216983sha_mo_s
shamoys15367283sha_moys
shampoos1544603shampoos
shamuses1336153shamuses
shandies122714103shandies
shanked153212123shank_ed
shanks135315583shank__s
shannies113411253shannies
shanties113116583shanties
shapes115124943sha__pes
shares95236413sha__res
sharked153613913shark_ed
sharker144313813shark_er
sharkers154011053sharkers
sharks135019723shark__s
sharpies13411223sharpies
shaves125224933sha__ves
shavies134213203sha_vies
shicker163914823shick_er
shickers173012823shickers
shicksas1743523shicksas
shikses14116573sh_ikses
shmoes114612103sh__moes
shocked174611813shock_ed
shocker163411433shock_er
shockers17319463shockers
shocks154414583shock__s
shoes85429663sh___oes
shrikes144412393shrik_es
shucked17389833shuck_ed
shucker163710103shuck_er
shuckers17388133shuckers
shucks154010413shuck__s
sickees134514213s_ickees
sickies133717503s_ickies
sickles133417543s_ickles
sickos125112033s_icko_s
slacked143815453slack_ed
slacken13399933slack_en
slackens14367713slackens
slacker133915293slack_er
slackers143812743slackers
slackest14289393slack_est
slackness1535433slackness
slacks124416533slack__s
slakes104021883sla_k_es
smacked163710993smack_ed
smacker153410583smack_er
smackers16318713smackers
smacks144112323smack__s
snacked144013113snack_ed
snacker133112603snack_er
snackers143010223snackers
snacks124514553snack__s
snakes103919603sna_k_es
spaces104722633spac__es
spacious1237813spacious
spackle15369573spackle_
spackled17297803spackled
sparkles143210493sparkles
speckles16268133speckles
stacked143416123stack_ed
stacker134416263stack_er
stackers143413563stackers
stackless1555933stackless
stacks124317263stack__s
stackups1643313stackups
stactes91914633stac_tes
stakes103927293sta_k_es
stickies142211973stickies
stickles142512103stickles
stuccoes1254273stuccoes
suckles134516743s_uckles
swacked173110523swack_ed
tackles133816523_tackles
thacked173810203thack_ed
thacks154311923thack__s
unshackles1941993unshackles
wackes154717713_wack_es
wackos155210993_wacko_s
whacked20458623whack_ed
whacker19368503whack_er
whackers20326543whackers
whackier2044673whackier
whackiest2144983whackiest
whacko18477033whacko__
whacks184610483whack__s

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.453394461.4
2DLD Change Limit1461621706.53022383.2
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.04625360.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.