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

71 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
sparkliest164458(None) 
sparkiest15188101spark_iest
darkliest1435162_darkliest
sarkiest123615072s_ark_iest
snarkiest13207642snark_iest
snarliest91810212snar_liest
spangliest1345162spangliest
sparkles143210492sparkl_es_
sparklet143110592sparkl_e_t
sparklets15275842sparkl_ets
sparklier1554362sparklie_r
sparriest11198792spar_riest
sprawliest1543582sprawliest
barkiest144115153_bark_iest
clerkliest1642793clerkliest
crackliest1844883crackliest
earliest82415243_ear_liest
gnarliest10186553gnar_liest
hackliest1836523_hackliest
larkiest123713323_lark_iest
marbliest1336763_marbliest
marliest102415183_mar_liest
nearliest949363near_liest
paliest93021613_pa__liest
palliest102814643_pa_lliest
pawkiest17277893_pawk_iest
pearliest1139363pear_liest
perkiest143313243_perk_iest
porkiest143513713_pork_iest
portliest11310183_portliest
scaliest101714403sca__liest
scariest101615953scar__iest
scarriest11188403scar_riest
scrawliest1553823scrawliest
shakiest151910943sha_k_iest
shaliest111415063sha__liest
shapeliest1544973shapeliest
sickliest1547523s_ickliest
skankiest12145713skank_iest
smarmiest1335913smar_miest
smirkiest1535193smirk_iest
snakiest122110553sna_k_iest
spaciest122310903spa__ciest
spackles16319953spackl_es_
sparest94616433spar___est
sparkier14298033spark_ie_r
sparkish17276973spark_i_sh
sparkle133710213sparkl_e__
sparkled15317733sparkl_e_d
sparkler14317983sparkl_e_r
sparklers15315643sparkl_ers
sparkling16226353sparkli_ng
sparsest1048823spar__sest
spikiest14259543sp_ik_iest
spindliest1344493spindliest
spiriest102513463spir__iest
spookiest15156403spook_iest
sportiest111711033spor_tiest
spriest92718653sp_r__iest
spruciest1345153sp_ruciest
spunkiest15166573spunk_iest
stalkiest1347913stalk_iest
starchiest1547193starchiest
starkest1239723stark__est
starriest9159773star_riest
stateliest1046363stateliest
surliest82416913s_ur_liest
swankiest16136213swank_iest
swarthiest1644753swarthiest
swirliest1236293swir_liest
weakliest1635853wea_kliest

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 Filter1786911406030.420425454.8
2DLD Change Limit140603715.65624859.1
3Display Results71710.0302366.7
 (SQL Overall)178691716.10629264.8
 
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.