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

209 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
sparsest104881(None) 
sparest94616421spar_est
coarsest1039162coarsest
hoarsest1137132hoarsest
parses85534702_parses_
scarcest12169172scarcest
scariest101615942scariest
searest73322022sear_est
sharpest1339142sharpest
smartest10310182smartest
spaciest122310892spaciest
spares84834552spar_es_
sparges104016342sparges_
sparkiest15188092sparkiest
sparriest11198782sparriest
sparse84516342sparse__
sparsely1335122sparsely
sparser94311482sparse_r
spiriest102513452spiriest
spriest92718642sp_riest
spryest12247812sp_ryest
starkest1239722starkest
arrest63722633__arrest
arses55733873__arses_
asperses104111673asperses_
barest85327693_bar_est
basest84720493_ba_sest
carses85233653_carses_
chariest13315503chariest
crassest103411523crassest
darkest122512623_darkest
dearest83618673dear_est
dwarfest1543473dwarfest
earnest7318733_earnest
falsest10310013_falsest
glariest92012523glariest
hardest113118413_hardest
harshest14310193_harshest
harvest132112753_harvest
hearses104414533hearses_
hoariest11312883hoariest
largest83715103_largest
leariest83117843leariest
marses84827113_marses_
misparses1347653misparses_
nearest73415843near_est
opaquest1943223opaquest
paciest112917803_paciest
palest83926223_pa_lest
paliest93021603_paliest
parent83230423_par_ent
pares77164483_par_es_
pareses94718883_pareses_
parges94529543_parges_
parget94529393_parge_t
pargets105215193_pargets
paries84742513_paries_
parises94827183_parises_
parles86334403_parles_
parse75236993_parse__
parsec105914483_parse_c
parsecs11429923_parsecs
parsed96323893_parse_d
parser84822373_parse_r
parsers94118153_parsers
pases75346503_pa_ses_
passes86030473_passes_
pauses84621473_pauses_
peartest10311303peartest
perses85428063_perses_
persist9315853_persist
pertest9317043_pertest
prases84429023_prases_
prest75736353_p_r_est
priest84125423_p_riest
purest84021933_pur_est
purses84826373_purses_
pursiest102812123_pursiest
rarest65725483_rar_est
rearrest8311603rearrest
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617983s_agiest
saltest71916513s_altest
sanest64426693s_a_nest
sappiest122612573sappiest
sarees65329943s_arees_
sarges75128593s_arges_
sarkiest123615063s_arkiest
sarment9318763s_arment
saroses73619333s_aroses_
sarsen6314233s_arse_n
sarsenet8412943s_arsenet
sarsens7311393s_arsens
sarsnet7314813s_arsnet
sarsnets836783s_arsnets
sasses64124393s_asses_
sassiest83413613s_assiest
sayest94217743s_a_yest
scaliest101714393scaliest
scantest101710183scantest
scaredest1246633scaredest
scares85033003scar_es_
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
scarriest11188393scarriest
scarves124511623scarves_
seamiest102715413seamiest
serest64831613s_er_est
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415053shaliest
shares95236413shar_es_
shortest11310783shortest
slackest14289393slackest
slatiest82616263slatiest
smallest1039403smallest
smarmiest1335903smarmiest
smeariest1138113smeariest
snakiest122110543snakiest
snares65329033snar_es_
snarkiest13207633snarkiest
snarliest91810203snarliest
soapiest102412843soapiest
sorest65028003s_or_est
sorriest8413883sorriest
sourest7515713sour_est
spaces104722633spa_ces_
spades94222583spa_des_
spaes76029973spa__es_
spahees1238263spahees_
spales84728103spa_les_
spanless10247363spanless
spare75135563spar_e__
spared95427493spar_e_d
sparely123410673spar_ely
spareness1139863spareness
sparer84524963spar_e_r
sparers94519613spar_ers
sparge94216053sparge__
sparged113512763sparge_d
sparger103613083sparge_r
spargers11389733spargers
sparids103512123sparids_
sparked143513143sparke_d
sparker133914363sparke_r
sparkers144111313sparkers
sparkish17276973sparkish
sparkles143210493sparkles_
sparklet143110593sparklet
sparklets15275843sparklets
sparkliest1644573sparkliest
sparks124616363spar_ks_
sparred104512863sparre_d
spars75431543spar__s_
sparseness1245493sparseness
sparsity1345463sparsity
spasms10418973spa_sms_
spates85028173spa_tes_
spathes125116533spathes_
spavies123012943spavies_
spaviet123011923spavie_t
spazzes1735263spazzes_
speises93813933speises_
spenses92913573spenses_
spheriest1438373spheriest
spiciest122711603spiciest
spikiest14259533spikiest
spiniest102813223spiniest
spires84628113spir_es_
spores84726613spor_es_
sportiest111711023sportiest
spouses92912813spouses_
sprees85620643sp_rees_
sprent84522383sp_r_ent
sprucest12295783sprucest
sprues84515763sp_rues_
spumiest1238203spumiest
spurges104111653spurges_
squarest17338223squar_est
stablest103312943stablest
stagiest91613403stagiest
staidest939803staidest
stalest73720173sta_lest
stardust946093stardust
stares66038753star_es_
starets73515923star_ets
starless81610843starless
starlet71620123starle_t
starlets81610083starlets
starriest9159763starriest
starves104614553starves_
stases64225563sta_ses_
sternest8314433sternest
suavest10310623sua_vest
sugariest1038133sugariest
superbest1349963superbest
surest65026763s_ur_est
swankest15105933swankest
tartest72517533_tartest
teariest82417263teariest
tersest71713993_tersest
upases84112903upa_ses_
wariest105122503_wariest
warmest123113033_warmest
weariest112914793weariest
yarest95018913_yar_est

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622097.06320694.0
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.29524495.0
 
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.