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 “sparklets” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
sparklets1527584(None) 
sparklers15315641sparklers
sparkles143210491sparkle_s
sparklet143110591sparklet_
partlets102811512_partlets
scarlets10178572scar_lets
spackles16319952spackle_s
sparkers144111312spark_ers
sparkiest15188092sparkiest
sparkle133710212sparkle__
sparkled15317732sparkle_d
sparkler14317982sparkle_r
sparkliest1644572sparkliest
starlets81610082star_lets
anklets114310413__anklets
armlets94610063__armlets
asparkle1443843asparkle__
auklets11298573__auklets
barkless14318023_barkless
darkles124011933_darkle_s
epaulets1043733epa_ulets
harslets1137833_harslets
markets133314033_mark_ets
martlets103310483_martlets
packets155114773_pack_ets
palets85122313_pa__lets
pallets93919303_pa_llets
parakeets1545103_parakeets
parapets1239763_parapets
pargets105215193_par_gets
parkers133816873_park_ers
parles86334403_par_le_s
parleys125212373_par_leys
parolees104313973_parolees
paroles95025883_parole_s
parquets1936413_parquets
parsleys1335083_parsleys
partlet92720363_partlet_
sallets73719653s_a_llets
samlets93813553s_a_mlets
sarkiest123615063s_arkiest
sarsnets836783s_arsnets
scarless10189053scar_less
scarlet91516943scar_let_
shacklers18336033shacklers
shackles173010593shackle_s
sharkers154011053shark_ers
snarkiest13207633snarkiest
snarlers8298753snar_lers
spaceless1335733spaceless
spackle15369573spackle__
spackled17297803spackle_d
spales84728103spa__le_s
spallers102910733spa_llers
spangles1138893spangle_s
spankers14369863spank_ers
spanless10247363spa_nless
sparables13167163sparable_s
spareness1139863spareness
sparers94519613spar__ers
spares84834553spar__e_s
sparest94616423spar__est
spargers11389733spar_gers
sparges104016343spar_ge_s
sparked143513143spark_e_d
sparker133914363spark_e_r
sparkier14298033sparkie_r
sparklier1554363sparklier
sparkling16226353sparkling
sparkly16348133sparkl__y
sparkplugs19111063sparkplugs
sparks124616363spark___s
sparriest11198783sparriest
sparsest1048813spar_sest
spatzles1935303spatzle_s
speckles16268133speckle_s
spikelets1553393spikelets
sporules1037703sporule_s
sprawlers1433893sprawlers
spurtles1037783spurtle_s
stackless1555933stackless
stalkless1333723stalkless
starets73515923star__ets
starkers123712393stark_ers
starkest1239723stark_est
starkness1335963starkness
starless81610843star_less
starlet71620123star_let_
startlers9236743startlers
startles82111963startle_s
sterlets8169273ster_lets
tartlets8289663_tartlets
varlets10411573_var_lets

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641937.31320325.6
3Display Results93930.0462021.7
 (SQL Overall)178691937.51523777.9
 
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.