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

192 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
sternest831443(None) 
serenest82717622s_erenest
serest64831612s_er_est
starkest1239722starkest
steepest1038122steepest
steres63929532ster_es_
sterlet71318472sterle_t
sterlets8169272sterlets
sterner7411912sterne_r
sternmost1144322sternmost
sternness946092sternness
sternpost1144232sternpost
sterns64616762stern_s_
ternes65422902_ternes_
tersest71713992_tersest
acerbest1245463acerbest
aeriest73924053_aeriest
alertest8310173alertest
austerest948653auster_est
beeriest104013403beeriest
cleanest10310293cleanest
earnest7318733_earnest
eeriest73620673_eeriest
ernes55224813__ernes_
eterne6311723eterne__
eternise8119663eternise
evenest10312103eve_nest
externes1539833externes_
ferniest1132214153_ferniest
fiercest13216143fiercest
fieriest112112243fieriest
greenest9312623greenest
interest8319183inter_est
internes82721233internes_
internist9414883internist
keenest11410963_keenest
kernes104717533_kernes_
leanest7415863_leanest
leeriest83112883leeriest
liernes739623liernes_
meanest9315703_meanest
merest84725113_mer_est
modernest1248113modernest
oftenest1148863ofte_nest
oneriest8313443oneriest
openest9312913ope_nest
otherness1245513otherness
overneat112713643overneat
pertest9317043_pertest
renest64529713_re_nest
sanest64426693s__anest
sauternes947023sauternes_
scarcest12169173scarcest
scariest101615943scariest
scenes84520353sce_nes_
searest73322023s_earest
seediest92714053seediest
seepiest102412623seepiest
seeress7311573seer_ess
seines65029903s_eines_
sennet64224143s_enne_t
sennets73712583s_ennets
serenes73222903s_erenes_
seres55448893s_er_es_
serges74225973s_erges_
series64540973s_eries_
serines74229543s_erines_
serpent92916283s_erpent
serves94423653s_erves_
severest11310323sever_est
sexiest142112223s_exiest
sharpest1339143sharpest
sheeniest12158353sheeniest
sheerest11310083sheerest
sheerness1236273sheerness
sherbert1348793sherbert
sherbet12311383sherbe_t
sherbets1335213sherbets
shortest11310783shortest
skeanes113610713skeanes_
skenes104616633ske_nes_
skewness1533763skewness
sleekest1236153sleekest
smartest10310183smartest
smeariest1138113smeariest
sneeriest939313sneeriest
snellest839493snellest
soberest10310353sober_est
soberness1186463soberness
solemnest1148053solemnest
soonest7415593s_oonest
soreness8914793soreness
sorest65028003s_or_est
sorriest8413883sorriest
sourest7515713sour_est
sourness839543sourness
sparest94616423spar_est
sparsest1048813sparsest
spheriest1438373spheriest
spiriest102513453spiriest
spriest92718643s_priest
spryest12247813s_pryest
stablest103312943stablest
stagiest91613403stagiest
staidest939803staidest
stalest73720173st_alest
stanes64933403st_anes_
stardust946093stardust
stares66038753star_es_
starets73515923star_ets
starkness1335963starkness
starless81610843starless
starlet71620123starle_t
starlets81610083starlets
starnose8136693starnose
starriest9159763starriest
starves104614553starves_
steadiest1038513steadiest
steamiest1138403steamiest
stearines9311283stearines_
stedfast1243643stedfast
steeliest939643steeliest
steepness1145723steepness
steeves103410903steeves_
steins64818343stein_s_
steles63725663ste_les_
stemless1036653stemless
stemmiest1335143stemmiest
stenos63915773ste_nos_
stent55634513ste_n__t
stents65019453ste_nts_
steppes113110693steppes_
stere55328543ster_e__
stereo65317913ster_e_o
stereos74314973ster_eos
stern55319123stern___
sterna63712763stern__a
sternal73411913stern_al
sternite8310543sternite
sternites9310073sternites_
sternly1037853stern_ly
sternposts1252503sternposts
sternson844843sternson
sternum947733stern_um
sternums1045783sternums
sternway1443153sternway
sterols7313443sterols_
stiffest1435683stiffest
stillest8311073stillest
stirpes95011293stirpes_
stones65130033st_ones_
stoniest8413543stoniest
stores65533663stor_es_
stories7324273stories_
stormiest1137003stormiest
stoutest837613stoutest
strangest103210843strangest
street64125773st_r_eet
streets73312613st_reets
stress66616673st_r_ess
strongest10338293strongest
sturdiest10207393sturdiest
styrenes11116623styrenes_
superbest1349963superbest
sureness8912903sureness
surest65026763s_ur_est
sveltest1135873sveltest
sweetest1137173sweetest
swellest1137663swellest
swerves1377533swerves_
tannest72617853_tannest
tartest72517533_tartest
teariest82417263_teariest
teeniest82112413_teeniest
telnet6518833_telne_t
telnets738373_telnets
tempest1139223_tempest
tenet55542213_te_ne_t
tenets65518953_te_nets
tennist72813113_tennist
tensest72713313_tensest
terces83921413_terces_
tercet83624913_terce_t
tercets93512443_tercets
terne56426153_terne__
terns55226873_tern_s_
terret63425623_terre_t
terrets72913583_terrets
truest64816193_t_ruest
utterness946223utterness
veriest103719133_veriest
wateriest12312233wateriest

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.406440125.6
2DLD Change Limit1461621927.31319986.6
3Display Results1921920.0802400.0
 (SQL Overall)1786911927.79922912.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.