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
sparkliest164457(None) 
sparkiest15188091spark_iest
darkliest1435162_darkliest
sarkiest123615062s_ark_iest
snarkiest13207632snark_iest
snarliest91810202snar_liest
spangliest1345152spangliest
sparkles143210492sparkl_es_
sparklet143110592sparkl_e_t
sparklets15275842sparkl_ets
sparklier1554362sparklie_r
sparriest11198782spar_riest
sprawliest1543572sprawliest
barkiest144115153_bark_iest
clerkliest1642793clerkliest
crackliest1844883crackliest
earliest82415243_ear_liest
gnarliest10186553gnar_liest
hackliest1836523_hackliest
larkiest123713313_lark_iest
marbliest1336763_marbliest
marliest102415183_mar_liest
nearliest949363near_liest
paliest93021603_pa__liest
palliest102814633_pa_lliest
pawkiest17277883_pawk_iest
pearliest1139353pear_liest
perkiest143313243_perk_iest
porkiest143513713_pork_iest
portliest11310183_portliest
scaliest101714393sca__liest
scariest101615943scar__iest
scarriest11188393scar_riest
scrawliest1553813scrawliest
shakiest151910933sha_k_iest
shaliest111415053sha__liest
shapeliest1544963shapeliest
sickliest1547523s_ickliest
skankiest12145703skank_iest
smarmiest1335903smar_miest
smirkiest1535193smirk_iest
snakiest122110543sna_k_iest
spaciest122310893spa__ciest
spackles16319953spackl_es_
sparest94616423spar___est
sparkier14298033spark_ie_r
sparkish17276973spark_i_sh
sparkle133710213sparkl_e__
sparkled15317733sparkl_e_d
sparkler14317983sparkl_e_r
sparklers15315643sparkl_ers
sparkling16226353sparkli_ng
sparsest1048813spar__sest
spikiest14259533sp_ik_iest
spindliest1344483spindliest
spiriest102513453spir__iest
spookiest15156393spook_iest
sportiest111711023spor_tiest
spriest92718643sp_r__iest
spruciest1345143sp_ruciest
spunkiest15166563spunk_iest
stalkiest1347903stalk_iest
starchiest1547183starchiest
starkest1239723stark__est
starriest9159763star_riest
stateliest1046353stateliest
surliest82416913s_ur_liest
swankiest16136203swank_iest
swarthiest1644743swarthiest
swirliest1236293swir_liest
weakliest1635853wea_kliest

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 Filter1786911406030.1731032896.0
2DLD Change Limit140603716.97020172.6
3Display Results71710.0302366.7
 (SQL Overall)178691717.17324911.6
 
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.