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

190 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
scarcest1216917(None) 
scariest101615951scariest
scaliest101714402scaliest
scantest101710182scantest
scarce104013632scarce__
scarcely1534312scarcely
scarcer113911372scarce_r
scaredest1246632scaredest
scares85033002scar_es_
scarless10189052scarless
scarlet91516942scarle_t
scarlets10178572scarlets
scarriest11188402scarriest
scarves124511622scarves_
searest73322022sear_est
sharpest1339152sharpest
smartest10310182smartest
sparest94616432spar_est
sparsest1048822sparsest
starkest1239722starkest
acerbest1245463acerbest
arrest63722633__arrest
barest85327693_bar_est
cagiest102916433_cagiest
cakiest133215663_cakiest
calces104420053_calces_
calmest11312343_calmest
carcase11312743_carcase
carcass11310513_carcass
carcel105018673_carce_l
carcels114516063_carcels
cares77369183_car_es_
caress85720263_car_ess
caret75360563_car_e_t
carets85330773_car_ets
carices114220953_carices_
caries85147623_caries_
carles85435083_carles_
carless95118493_carless
carnet84732873_carne_t
carnets93918403_carnets
carpet104530093_carpe_t
carpets113915333_carpets
carses85233653_carses_
cartes86239473_cartes_
carves115128453_carves_
chariest13315513chariest
chicest14209943_chicest
coarsest1039163coarsest
crest74632693_c_r_est
curtest9713963_curtest
darkest122512623_darkest
dearest83618673dear_est
dwarfest1543473dwarfest
earnest7318733_earnest
ecartes94212563ecartes_
farces115223323_farces_
fiercest13216143fiercest
glariest92012533glariest
hardest113118413_hardest
harvest132112753_harvest
hoariest11312883hoariest
hoarsest1137133hoarsest
largest83715103_largest
leariest83117853leariest
narcist9512443_narcist
nearest73415843near_est
peartest10311303peartest
rarest65725483_rar_est
rearrest8311603rearrest
sacrist9315423sacr_ist
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617993s_agiest
saices84221803s_aices_
saltest71916513s_altest
sanest64426693s_a_nest
sarcasm1136693s_arcasm
sarcenet10413313s_arcenet
sarees65329943s_arees_
sarges75128593s_arges_
sarkiest123615073s_arkiest
sarment9318763s_arment
sauces84919503s_auces_
sauciest10310983s_auciest
sayest94217743s_a_yest
scabbiest1534923scabbiest
scabies11613333scabies_
scales84529313sca_les_
scandent1148493scandent
scantiest112611013scantiest
scapes105122263sca_pes_
scarabs1137293scarabs_
scarceness1444763scarceness
scarcity1545093scarcity
scare75334463scar_e__
scared95227293scar_e_d
scarer84524613scar_e_r
scarers94618513scar_ers
scarey115016983scar_e_y
scarfed134711183scarfe_d
scarfer124511083scarfe_r
scarfers13408463scarfers
scarfs114714683scar_fs_
scarier94017873scarie_r
scariness11310183scariness
scariose1037593scariose
scarped124314403scarpe_d
scarper114814823scarpe_r
scarpers124712513scarpers
scarphs14437413scarphs_
scarps104718603scar_ps_
scarred104512633scarre_d
scars75433533scar__s_
scart76139773scar___t
scarted104816123scarte_d
scarts85321493scar_ts_
scathes124515713scathes_
scattiest11268373scattiest
sconces113811453sconces_
scorches15189153scorches_
scores84725923scor_es_
scrapes116217663scrapes_
screes85023973sc_rees_
scries85226823sc_ries_
scurfiest14236863scurfiest
scurviest14266123scurviest
seamiest102715423seamiest
seances93015343seances_
searches132112903searches_
securest1058583secur_est
serest64831613s_er_est
shadiest121711283shadiest
shakiest151910943shakiest
shaliest111415063shaliest
shares95236413shar_es_
shortest11310783shortest
slackest14289403slackest
slatiest82616273slatiest
smallest1039403smallest
smarmiest1335913smarmiest
smeariest1138123smeariest
snakiest122110553snakiest
snares65329033snar_es_
snarkiest13207643snarkiest
snarliest91810213snarliest
soapiest102412853soapiest
sorest65028003s_or_est
sorriest8413883sorriest
sources9312173sources_
sourest7515713sour_est
spaces104722633spa_ces_
spaciest122310903spaciest
spares84834553spar_es_
sparges104016343sparges_
sparkiest15188103sparkiest
sparriest11198793sparriest
spiriest102513463spiriest
spriest92718653s_priest
sprucest12295783sprucest
spryest12247813s_pryest
squarest17338223squar_est
stablest103312943stablest
stagiest91613413stagiest
staidest939803staidest
stalest73720173sta_lest
stances93715963stances_
stanchest14218213stanchest
starches131912913starches_
starchiest1547193starchiest
stardust946093stardust
stares66038753star_es_
starets73515923star_ets
starless81610843starless
starlet71620123starle_t
starlets81610083starlets
starriest9159773starriest
starves104614553starves_
sternest8314433sternest
suavest10310623sua_vest
sugariest1038143sugariest
surest65026763s_ur_est
swankest15105933swankest
tartest72517533_tartest
teariest82417263teariest
wariest105122503_wariest
warmest123113033_warmest
weariest112914793weariest
yarest95018913_yar_est

Search took 9 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.420425454.8
2DLD Change Limit1461621907.83018666.9
3Display Results1901900.0762500.0
 (SQL Overall)1786911908.32621461.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.