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

286 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
sparkles14321049(None) 
spackles16319951spackles
sparkle133710211sparkle_
sparkled15317731sparkled
sparkler14317981sparkler
sparklers15315641sparklers
sparklet143110591sparklet
sparklets15275841sparklets
asparkle1443842asparkle_
darkles124011932_darkles
parles86334402_par_les
paroles95025882_paroles
shackles173010592shackles
spackle15369572spackle_
spackled17297802spackled
spales84728102spa__les
spangles1138892spangles
sparables13167162sparables
spares84834552spar__es
sparges104016342spar_ges
sparked143513142spark_ed
sparker133914362spark_er
sparkers144111312sparkers
sparkier14298032sparkier
sparkiest15188092sparkiest
sparklier1554362sparklier
sparkliest1644572sparkliest
sparkly16348132sparkl_y
sparks124616362spark__s
spatzles1935302spatzles
speckles16268132speckles
sporules1037702sporules
spurtles1037782spurtles
startles82111962startles
ankles104818383__ankles
argles75218483__argles
arles56735743__ar_les
barkless14318023_barkless
cackles153717203_cackles
carles85435083_car_les
crackles164111273crackles
crankles143510153crankles
darkies124015753_darkies
darkle113813943_darkle_
darkled13378723_darkled
dartles84014133_dartles
escaroles1145273escaroles
espanoles1143943espanoles
farles96025783_far_les
garbles104016923_garbles
gargles94214893_gargles
grackles15309183grackles
hackles162917063_hackles
mackles154415753_mackles
marbles114516653_marbles
outsparkles1791483outsparkles
paddles113515643_paddles
padles95221123_pa_dles
pales75753803_pa__les
papules112411573_papules
parables121613563_parables
parades104121463_parades
parcels113712663_parcels
parches143720003_parches
pares77164483_par__es
pareses94718883_pareses
parflesh1643743_parflesh
parges94529543_par_ges
paries84742513_par_ies
parises94827183_parises
parkades1538273_parkades
parkas125018023_park_as
parked134425143_park_ed
parker124121373_park_er
parkers133816873_parkers
parks116134463_park__s
parle75836163_par_le_
parled94626283_par_led
parley116718353_par_ley
parleys125212373_par_leys
parole84425253_parole_
paroled104217623_paroled
parolee94119633_parolee
parolees104313973_parolees
parols84722613_parol_s
parrels94713493_parrels
parries93925843_parries
parses85534703_par_ses
parsley1247793_parsley
parsleys1335083_parsleys
parties93230863_parties
partlet92720363_partlet
partlets102811513_partlets
parures9512693_parures
pickles153215443_pickles
porkies133416493_porkies
proles84627203_p_roles
purfles122511843_purfles
purples112712823_purples
rankles113114543_rankles
sables85026693s_a_bles
saddles95415743s_addles
safroles1136933safroles
sakes95540753s_a_k_es
sales56055593s_a__les
samples112815453s_amples
saprobes1237033saprobes
sarapes94617743s_arapes
sarees65329943s_ar_ees
sarges75128593s_ar_ges
sarkier113413313s_arkier
sarkiest123615063s_arkiest
sarks96632463s_ark__s
sarodes84216143s_arodes
saroses73619333s_aroses
scabbles14167983scabbles
scales84529313sca__les
scares85033003scar__es
scarless10189053scar_less
scarlet91516943scar_let
scarlets10178573scar_lets
scarves124511623scar_ves
searches132112903searches
separates11310743separates
shackle16409543shackle_
shackled18277603shackled
shackler17317973shackler
shacklers18336033shacklers
shackoes17367853shackoes
shakes135024593sha_k_es
shakoes144510023sha_koes
shales94731253sha__les
shambles15159043shambles
shares95236413shar__es
sharked153613913shark_ed
sharker144313813shark_er
sharkers154011053sharkers
sharks135019723shark__s
sharpies13411223sharpies
sickles133417543s_ickles
skatoles1236143skatoles
slakes104021883sla_k_es
smarties10312873smarties
snaffles14246043snaffles
snakes103919603sna_k_es
snares65329033snar__es
snarkier12336513snarkier
snarkiest13207633snarkiest
snarks104815733snark__s
snarled83612363snar_led
snarler73610633snar_ler
snarlers8298753snar_lers
snarls64016873snar_l_s
snorkels1234413snorkels
spaceless1335733spaceless
spaces104722633spa__ces
spades94222583spa__des
spadices1336093spadices
spadilles1244993spadilles
spadixes1834113spadixes
spadones1137253spadones
spaes76029973spa___es
spaetzles2042153spaetzles
spahees1238263spa_hees
spails84817823spa_il_s
spake114322743spa_k_e_
spale74929213spa__le_
spalled103113133spa_lled
spaller92713473spa_ller
spallers102910733spa_llers
spalls84217343spa__lls
spancels1245273spancels
spangle1038403spangle_
spangled1236153spangled
spaniels1045963spaniels
spanked143111733spank_ed
spanker133612353spank_er
spankers14369863spankers
spanks124514123spank__s
spanless10247363spa_nless
spansules1143613spansules
sparable121611983sparable_
spare75135563spar__e_
spared95427493spar__ed
sparely123410673sparel_y
spareness1139863spareness
sparer84524963spar__er
sparers94519613spar_ers
sparest94616423spar__est
sparge94216053spar_ge_
sparged113512763spar_ged
sparger103613083spar_ger
spargers11389733spargers
sparids103512123spar_ids
spark114920893spark___
sparkily1735023sparkily
sparking152812543sparking
sparkish17276973sparkish
sparkling16226353sparkling
sparkplug1881203sparkplug
sparkplugs19111063sparkplugs
sparky154511523spark__y
sparoids11218713sparoids
sparred104512863spar_red
sparrier10329143sparrier
sparriest11198783sparriest
sparrows1344803sparrows
spars75431543spar___s
sparse84516343spar_se_
sparsely1335123sparsely
sparser94311483spar_ser
sparsest1048813spar_sest
spates85028173spa__tes
spathes125116533spa_thes
spatulas1045473spatulas
spatzle1834583spatzle_
spavies123012943spa_vies
spazzes1735263spa_zzes
speckle15297553speckle_
speckled17255833speckled
spherules1443823spherules
spicules12219803spicules
spikes124520713sp_ik_es
spiles84227913sp__iles
spindles112710353spindles
spinules10249333spinules
spiracles1345663spiracles
spiraled1137733spiraled
spirals93212513spiral_s
spiremes12397623spiremes
spires84628113spir__es
spirulas10207203spirulas
spittles1038333spittles
splakes1349673splak_es
spokes124417213sp_ok_es
spores84726613spor__es
sporule937273sporule_
spraddles13194283spraddles
sprattles1174883sprattles
sprawled1434523sprawled
sprawler1334643sprawler
sprawlers1433893sprawlers
sprawls12176373sprawl_s
sprees85620643sp_r_ees
sprinkles1534923sprinkles
sprites94220333sp_rites
spruces113810503sp_ruces
sprues84515763sp_r_ues
spunkies14227583spunkies
spurges104111653spur_ges
spurries102311323spurries
spurtle937453spurtle_
stabiles10311403stabiles
stables93219073sta_bles
stackless1555933stackless
staddles10258693staddles
stakes103927293sta_k_es
stales65538293sta__les
stalkless1333723stalkless
staples93617213sta_ples
starches131912913starches
stares66038753star__es
starker114114693stark_er
starkers123712393starkers
starkest1239723stark_est
starkly14277033starkl_y
starkness1335963starkness
starless81610843star_less
starlet71620123star_let
starlets81610083star_lets
startle72511123startle_
startled9208563startled
startler8248793startler
startlers9236743startlers
starves104614553star_ves
stickles142512103stickles
strakes114218073strak_es
subrules1039723subrules
suckles134516743s_uckles
svarajes1843513svarajes
swaddles13296453swaddles
swales93920763swa__les
swarajes1843743swarajes
tackles133816523_tackles
warbles123215563_warbles
warsles103413643_warsles

Search took 9 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 Limit1461622867.82618676.5
3Display Results2862860.1102600.0
 (SQL Overall)1786912868.09222082.4
 
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.