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

101 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
sparklier155436(None) 
sparkier14298031spark_ier
sparkler14317981sparkl_er
darklier1335012_darklier
sarkier113413312s_ark_ier
snarkier12336512snark_ier
snarlier8278182snar_lier
spanglier1244192spanglier
sparker133914362spark__er
sparkle133710212sparkl_e_
sparkled15317732sparkl_ed
sparklers15315642sparkl_ers
sparkles143210492sparkl_es
sparklet143110592sparkl_et
sparkliest1644572sparkliest
sparkling16226352sparkling
sparrier10329142spar_rier
sprawlier1443292sprawlier
asparkle1443843asparkl_e_
barkier133814483_bark_ier
clerklier1542183clerklier
cracklier1744823cracklier
earlier72612743_ear_lier
espalier1036363espa__lier
gnarlier9255163gnar_lier
hacklier1737133_hacklier
larkier113711523_lark_ier
marblier1256343_marblier
marlier92614773_mar_lier
nearlier836793near_lier
palier85023563_pa__lier
pallier94417163_pa_llier
parker124121373_park__er
parklike1337493_parklike
parrier93717653_par_rier
parslied1137823_parslied
partier93520713_par_tier
pawkier16236613_pawk_ier
pearlier1037323pear_lier
perkier133813123_perk_ier
porkier133712343_pork_ier
portlier1038373_portlier
sallier73320423s_a_llier
scalier94316913sca__lier
scarier94017873scar__ier
scarifier1446653scarifier
scarrier10298453scar_rier
scrawlier1443903scrawlier
shackler17317973shackl_er
shakier143411153sha_k_ier
shalier103116423sha__lier
shapelier1444463shapelier
sharker144313813shark__er
sharklike1543933sharklike
sicklier1457213s_icklier
skankier11184883skank_ier
smarmier1235033smar_mier
smirkier1444433smirk_ier
snakier112810003sna_k_ier
snarler73610633snar_l_er
spacier114011633spa__cier
spackle15369573spackl_e_
spackled17297803spackl_ed
spackles16319953spackl_es
spackling18266503spackling
spaller92713473spa__ller
spanker133612353spank__er
sparer84524963spar___er
sparger103613083spar__ger
sparked143513143spark__ed
sparkers144111313spark__ers
sparkiest15188093spark_iest
sparkily1735023spark_ily
sparking152812543spark_ing
sparkish17276973spark_ish
sparklets15275843sparklets
sparkly16348133sparkl__y
sparlike1437673spar_like
sparling112714533spar_ling
sparser94311483spar__ser
spikier13369983sp_ik_ier
spindlier1253873spindlier
spirier93214073spir__ier
spookier14175493spook_ier
sportier102010053spor_tier
sprawler1334653sprawl_er
sprier84119063sp_r__ier
sprucier1254793sp_rucier
spunkier14235823spunk_ier
spurrier10297693spur_rier
stalkier1257073stalk_ier
starchier1436643starchier
starker114114693stark__er
starrier8279463star_rier
startler8248793startl_er
statelier945653statelier
surlier72915443s_ur_lier
swankier15225503swank_ier
swarthier1543783swarthier
swirlier1135213swir_lier
weaklier1534263wea_klier

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411016.40623203.4
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.87525991.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.