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

103 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
knuckles138445(None) 
knuckle1254231knuckle_
knuckled1463561knuckled
knuckler1383621knuckler
knucklers1483041knucklers
buckles153416092_buckles
chuckles1936802chuckles
huckles163612622_huckles
keckles12318762k_eckles
knockless1442442knockless
knucklier1442302knucklier
knuckliest1542552knuckliest
knuckly1542472knuckl_y
muckles153413252_muckles
nickles133713822_nickles
penuckles1743242penuckles
ruckles133414602_ruckles
suckles134516742_suckles
truckles14319382truckles
unbuckles1743192unbuckles
ankles104818383an__kles
boucles113113003bouc_les
brickles162810283brickles
buckle144815193_buckle_
buckled164411883_buckled
buckler154112033_buckler
bucklers16349503_bucklers
buckoes153810393_buckoes
cackles153717203_cackles
chuckies1937703chuckies
chuckle1836443chuckle_
chuckled2045163chuckled
chuckler1935553chuckler
chucklers2034443chucklers
cockles153414643_cockles
crackles164111273crackles
deckles143312803_deckles
duckies143613813_duckies
freckles17126383freckles
grackles15309183grackles
hackles162917063_hackles
heckles163711383_heckles
huckle153913073_huckle_
inkles103515653in__kles
keckle11359423k_eckle_
keckled13376503k_eckled
knacked13287793knack_ed
knacker12307913knack_er
knackers13286843knackers
knacks11428543knack__s
knickers13306723knickers
knocked13236303knock_ed
knocker12296393knock_er
knockers13285733knockers
knocks11397443knock__s
knuckling1542753knuckling
knurled1244653knu_rled
knurls10396243knu_rl_s
luckies133313683_luckies
luckless14265893_luckless
mackles154415753_mackles
mickles153415003_mickles
muckle143413583_muckle_
neckless14236433_neckless
nickels13338653_nickels
nickle123814483_nickle_
nickled144010443_nickled
nubbles113412433_nubbles
nuclei857723_nuc_lei
nucleus956573_nuc_leus
nukes95418123_nu_k_es
numbles113814273_numbles
nuncles939843_nuncles
nuzzles15298123_nuzzles
penuchles1643763penuchles
penuckle1643263penuckle_
pickles153215443_pickles
prickles162511093prickles
ruckle124414583_ruckle_
ruckled144111033_ruckled
runkles114111943_runkles
shackles173010593shackles
sickles133417543_sickles
snuffles14318413snuffles
snuggles10306143snuggles
spackles16319953spackles
speckles16268133speckles
stickles142512103stickles
suckle124015963_suckle_
suckled144212513_suckled
suckler133413093_suckler
sucklers14379963_sucklers
suckless14288823_suckless
tackles133816523_tackles
tickles133416853_tickles
trickles143013763trickles
truckle13358863truckle_
truckled15327313truckled
truckler14297453truckler
trucklers15295583trucklers
unbuckle1643863unbuckle_
unbuckled1843633unbuckled
uncles8317163un_c_les

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621036.57622226.6
3Display Results1031030.0333121.2
 (SQL Overall)1786911036.76526414.0
 
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.