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

190 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
speckle1529755(None) 
spackle15369571spackle
speckled17255831speckled
speckles16268131speckles
deckle1312012452_deckle
freckle16106642freckle
heckle153112092_heckle
keckle11359422_keckle
pickle144215652_pickle
shackle16409542shackle
sickle124418322s_ickle
spackled17297802spackled
spackles16319952spackles
sparkle133710212sparkle
specie10412222spec_ie
speck135115652speck__
specked16329012specked
specks144312702speck_s
spectre11297772spectre
specula11187422specula
spicule11269932spicule
stickle132410972stickle
suckle124015962s_uckle
asparkle1443843asparkle
brickle15279933brickle
buckle144815193_buckle
cackle143416923_cackle
chuckle1836443chuckle
cockle143913573_cockle
crackle153611253crackle
decile94619213_decile
deckel134911043_deckel
deckles143312803_deckles
feckly18335963_feckly
fickle153912973_fickle
freckled18104443freckled
freckles17126383freckles
freckly19124593freckly
grackle14338893grackle
hackle154916813_hackle
heckled17318463_heckled
heckler16278573_heckler
heckles163711383_heckles
huckle153913073_huckle
keckled13376503_keckled
keckles12318763_keckles
kenspeckle175833kenspeckle
knuckle1254233knuckle
mackle143716433_mackle
meikle1236653_meikle
mickle143715133_mickle
muckle143413583_muckle
nickle123814483_nickle
opercele1244593opercele
opercule1245283opercule
packly17228333_packly
pebble1238003_pebble
peck125730683_peck__
pecked155019103_pecked
pecker144615363_pecker
peckier153910523_peckier
pecks135724433_peck_s
pecky165515093_peck_y
peddle103512823_peddle
peke105926203_pe_k_e
pekoe114612363_pe_koe
pele65539553_pe__le
penile82219603_penile
penuckle1643263_penuckle
people10310193_people
percale11314093_percale
pestle83215843_pestle
pettle84116053_pettle
pickled164011883_pickled
pickles153215443_pickles
prickle153611013prickle
rackle123917293_rackle
ruckle124414583_ruckle
saccule1136743saccule
scale74629143s__cale
secede93311993s_ecede
sectile9311973s_ectile
secure8513533s_ecure
sedile73517233s_edile
seeable91113943seeable
selkie102811693s_elkie
selle54428313s_e_lle
semple103212753s_emple
senile63420213s_enile
settle63915663s_ettle
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shekel1338383she_kel
sickee124622223s_ickee
sickie123715743s_ickie
sickled144713433s_ickled
sickles133417543s_ickles
sickly153110483s_ickly
slackly1635263slackly
sleekly14325193sleekly
slickly1635853slickly
sneck114713663sneck__
snecks124410033sneck_s
socle7419573s_oc_le
space95325673spac__e
spaetzle1942243spaetzle
spake114322743sp_ak_e
spale74929213sp__ale
spangle1038403spangle
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparkly16348133sparkly
spatzle1834583spatzle
speak114618673speak__
speakable1745373speakable
speaker133311213speaker
speaks125114583speak_s
spec85821973spec___
specced14266703specced
special11310303special
specialer1344733specialer
specials1238033specials
speciate12209583speciate
species11314133species
specify1764993specify
specimen1444423specimen
specking17359733specking
speckling18235583speckling
specs96916673spec__s
spectacle1544083spectacle
spectate12248833spectate
specter113111733specter
spectra11275833spectra
spectres12268683spectres
specular12217623specular
speculate13239193speculate
speculum1474193speculum
speel74420763spe_el_
speeled103712453spe_eled
speels85116393spe_els
speil75618643spe_il_
speiled104412123spe_iled
speils84116223spe_ils
speise84614253spe_ise
spell75020303spe__ll
spelled103714743spe_lled
speller95415153spe_ller
spells84617683spe_lls
spelt75430193spe__lt
spence103813793spe_nce
spense83912433spe_nse
spherule1343843spherule
spicae104313703spic_ae
spicate113214193spicate
spice95528813spic__e
spicily1438653spicily
spick134519073spick__
spicks144814993spick_s
spicula11259303spicula
spiculae12218613spiculae
spicules12219803spicules
spike114922843sp_ik_e
spile75230083sp__ile
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
splake1259783splak_e
spoke114818663sp_ok_e
sporule937273sporule
sprinkle1434893sprinkle
spunkie13215303spunkie
spurtle937453spurtle
steeple937323steeple
stele55026843ste__le
sterile7316603sterile
stickled15298973stickled
stickler14259573stickler
stickles142512103stickles
strickle1467793strickle
suckled144212513s_uckled
suckler133413103s_uckler
suckles134516743s_uckles
tackle123815733_tackle
tickle124616743_tickle
trickle133613443trickle
truckle13358863truckle
upscale11136323upscale

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271906.73619897.1
3Display Results1901900.0762500.0
 (SQL Overall)1786911907.21824756.3
 
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.