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

436 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
tersest7171399(None) 
tensest72713311tensest
aeriest73924052aeriest
densest83112472densest
eeriest73620672eeriest
erses55826802_erses_
merest84725112mer_est
perses85428062perses_
persist9315852persist
pertest9317042pertest
serest64831612ser_est
sternest8314432sternest
tartest72517532tartest
teariest82417262teariest
teases65426272teases_
tempest1139222tempest
tenses64722552tenses_
terces83921412terces_
tercet83624912terce_t
tercets93512442tercets
ternes65422902ternes_
terret63425622terre_t
terrets72913582terrets
terse55026822terse__
tersely1038112tersely
terser67317822terse_r
torses64727952torses_
truest64816192t_ruest
veriest103719132veriest
verses94223762verses_
verset94327322verse_t
versets103913102versets
acerbest1245463acerbest
aeries64737783aeries_
airest63825263air_est
airiest74221013airiest
alertest8310173alertest
arrest63722633_arrest
arses55733873_arses_
barest85327693bar_est
basest84720493_basest
beeriest104013403beeriest
behest11314613be_hest
bequest1837823bequest
bereft114317303ber_eft
beret74946363ber_e_t
berets85822523ber_ets
bermes106023003bermes_
berseem1166463berseem
berserk1334913berserk
beses75830723be_ses_
beset76739133be_se_t
besets85718803be_sets
birses84717733birses_
burses84425513burses_
carses85233653carses_
ceases84427073ceases_
censes83721803censes_
ceres75540013cer_es_
cerises94722253cerises_
cermet10321153cerme_t
cermets1139713cermets
certes84623083certes_
ceruses93716233ceruses_
cesses84221363cesses_
closest94312533closest
coarsest1039163coarsest
corses84433463corses_
corset85636223corse_t
corsets94819803corsets
cresset93319943cresset
crest74632693_cr_est
curses85328273curses_
curtest9713963curtest
darkest122512623darkest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deepest10310443deepest
deffest14308803deffest
deftest112611713deftest
desert72725493de_sert
desist74818813de_sist
dessert82916453dessert
detest74122843de_test
devest104418703de_vest
dewiest11312343dewiest
direst75024243dir_est
drest65530343_dr_est
driest74722753_driest
dryest104811123_dryest
earnest7318733earnest
eases56041613_eases_
easiest72318773_easiest
eeliest73516473eeliest
egest65222343_e_gest
eldest72912683_eldest
erases64425403_erases_
erect74129333_er_ect
ernes55224813_ernes_
eroses65327053_eroses_
erst47436433_er__st
eses45336103_e_ses_
esses56422973_esses_
exsect1558503_exsect
exsert13414363_exsert
falsest10310013falsest
feases95422923feases_
featest102715113featest
fellest10313753fellest
feres86038183fer_es_
ferment12315573ferment
ferniest1132214153ferniest
ferret93021173ferre_t
ferrets103111393ferrets
fervent13310063fervent
fesses94820253fesses_
fewest12311663fe_west
feyest12311403fe_yest
fiercest13216143fiercest
fieriest112112243fieriest
firmest1239273firmest
forest94926743for_est
freest95318283_freest
freshest143010583freshest
geest64829623ge__est
gerent73223103ger_ent
germiest11249923germiest
goriest82218743goriest
gorses74723293gorses_
gorsiest92511133gorsiest
greyest11348343greyest
hardest113118413hardest
harshest14310193harshest
harvest132112753harvest
hearses104414533hearses_
heppest14228143heppest
herbiest1339993herbiest
hereat93527413her_eat
heres86245903her_es_
heresy125011233her_esy
heroes94923823heroes_
herpes115517323herpes_
herself1337623herself
hoarsest1137133hoarsest
horses94729343horses_
horsiest112513263horsiest
intensest949103intensest
interest8319183inter_est
intersect11412113intersect
jerkiest19328113jerkiest
jersey1636333jerse_y
jerseys1733243jerseys
jesses135215953jesses_
keenest11410963keenest
kermes124616133kermes_
kermess13396223kermess
kernes104717533kernes_
kersey1336793kerse_y
kerseys1433993kerseys
keyset13411533keyse_t
keysets1434343keysets
largest83715103largest
leanest7415863leanest
leariest83117843leariest
leases65428113leases_
leeriest83112883leeriest
leftest10269463leftest
lenses64620893lenses_
leses54930813le_ses_
lewdest1136283lewdest
loosest75811563loosest
marses84827113marses_
meanest9315703meanest
meekest1336893meekest
menses84222453menses_
merces105720743merces_
merdes94518603merdes_
meres75143573mer_es_
merges94122493merges_
merises93421423merises_
merles85322763merles_
merriest10311473merriest
messes84924343messes_
messiest103112423messiest
miriest93619823miriest
mirkest13309723mirkest
murkest133110203murkest
nearest73415843nearest
neatest72516003neatest
nerdiest92511163nerdiest
nerves94216193nerves_
nerviest11188833nerviest
nesses64718323nesses_
newest9314213ne_west
newsiest11107483newsiest
nurses63919353nurses_
oneriest8313443oneriest
overset102821473overse_t
oversets113114173oversets
parses85534703parses_
peartest10311303peartest
peases85229473peases_
peises84125043peises_
percent113520603percent
percept133112523percept
peres76246643per_es_
perfect141010833perfect
perkiest143313243perkiest
perpent112318813perpent
persalt9315413persalt
perse75429523perse__
persists1049183persists
peruses94018163peruses_
pervert12315583pervert
present94022733present
preset84430983prese_t
presets94216423presets
prest75736353_pr_est
pretest9517633pretest
priest84125423_priest
purest84021933pur_est
purses84826373purses_
pursiest102812123pursiest
rarest65725483rar_est
realest73322433realest
rearrest8311603rearrest
reddest9311953reddest
reest54938093__reest
renest64529713re_nest
request16311023request
rerent63832453rer_ent
rerises73525883rerises_
reseat64131493re_seat
resect84424703re_sect
resent63833623re_sent
reset55051863re_se_t
resets65427613re_sets
resist64524533re_sist
rest46459843__r_est
retest64028453re_test
reuses66025523reuses_
revest94623603re_vest
searest73322023searest
seises64026713seises_
senses63923943senses_
sepses84515883sepses_
serenest82717623serenest
seres55448893ser_es_
serges74225973serges_
series64540973series_
serpent92916283serpent
serves94423653serves_
sexiest142112223sexiest
sorest65028003sor_est
sparsest1048813sparsest
spriest92718643spriest
spryest12247813spryest
starkest1239723starkest
steepest1038123steepest
steres63929533ster_es_
sterlet71318473sterle_t
sterlets8169273sterlets
surest65026763sur_est
tallest7317093tallest
tamest85721293t_amest
tannest72617853tannest
tardiest93515243tardiest
tares57456563tar_es_
targes74524593targes_
target75028903targe_t
targets84314223targets
tarres64723043tarres_
tarriest83215003tarriest
tarsus6310513tarsus_
tartiest82718313tartiest
tasses64826763tasses_
tasset65925313tasse_t
tassets75012773tassets
tautest72612443tautest
tawses94913193tawses_
tearless848713tearless
tease55428713tease__
teased74721153tease_d
teasel63914983tease_l
teasels74311313teasels
teaser65421523tease_r
teasers75317243teasers
techiest1359833techiest
teeniest82112413teeniest
teensiest945833teensiest
tees45353583te__es_
teleost7410523teleost
teles54536003te_les_
teleses7313123teleses_
telnet6518833telne_t
telnets738373telnets
tempests1234443tempests
tenet55542213te_ne_t
tenets65518953te_nets
tennist72813113tennist
tense55225843tense__
tensed74817833tense_d
tensely1037363tensely
tenser64919433tense_r
tentiest82115613tentiest
tenues63816443tenues_
tepees84215243tepees_
terais64023513terais_
terce75721843terce__
tercel83612993terce_l
tercelet1049883tercelet
tercels94110363tercels
teredo7310783ter_edo
terete6319333ter_ete
termed94816703terme_d
termer85717253terme_r
termers95414503termers
termless1036233termless
terms75523473ter_ms_
terne56426153terne__
terns55226873ter_ns_
terpene92310863terpene
terras63516973terras_
terrases82111483terrases_
terreen7257573terreen
terrene72411033terrene
terries73425633terries_
territ63421373ter_rit
territs72714503territs
terseness948403terseness
tessera736333tessera
test48651623t___est
testes65125823testes_
testiest82715223testiest
tests56530193te_sts_
texases1437573texases_
thereat104315243ther_eat
theres96525473ther_es_
thermes126214613thermes_
theses96517973theses_
thewiest14196343thewiest
threat95020463thr_eat
threes97117323threes_
thresh12276863thr_esh
throes97518673throes_
thrust91911893thr_ust
thyrses1335023thyrses_
tidiest83514873tidiest
tierces93710453tierces_
tiniest73020123tiniest
tipsiest10228953tipsiest
tiredest938403tiredest
tires55437493tir_es_
tmeses85712243tmeses_
toniest73218903toniest
tores55352673tor_es_
tories65435883tories_
torment9316173torment
torrent7313413torrent
torse55833333torse__
torsks10549123torsks_
torsos64815733torsos_
tortes64826053tortes_
tosses65225393tosses_
touses64229673touses_
toweriest1246533toweriest
treat56240353t_r_eat
trees55835763t_rees_
tres46542903t_r_es_
tress55423163t_r_ess
tressed83714263tressed
tressel73010893tressel
tresses73719543tresses
tressiest937883tressiest
tressy9448553tres_sy
tret46653533t_r_e_t
trets55928023t_r_ets
trevet94818913treve_t
trevets10499973trevets
tries55742813t_ries_
trisect939733trisect
tritest7315273tritest
trues54925323t_rues_
trust55426853t_r_ust
tryst84716223t_r_yst
tsetses785453tsetses_
turfiest112410133turfiest
turgent8712393turgent
turret63121853turre_t
turrets73010673turrets
turves94212693turves_
tusses64921243tusses_
typiest1238203typiest
tyres84725233tyr_es_
unrest62918853unr_est
uteruses837183uteruses_
verges104320183verges_
verist93823893ver_ist
vermes115019143vermes_
versant10313833versant
verse84723583verse__
versed104515513verse_d
verser94516963verse_r
versers103813523versers
versos93812803versos_
verst84429373ver__st
verstes104014283verstes_
versts93914733versts_
versus94211143versus_
verves124617883verves_
vervet124619063verve_t
vervets13419753vervets
wariest105122503wariest
warmest123113033warmest
wateriest12312233wateriest
weakest1439003weakest
weariest112914793weariest
weest85026773we__est
weirdest1244433weirdest
wergelt1138583wergelt
wettest10239363wettest
wiriest103816853wiriest
wisest95016443_wisest
worses95522953worses_
worset96726583worse_t
worsets105512843worsets
wrest84925433_wr_est
wriest94419713_wriest
wryest12429113_wryest
xeroses143612823xeroses_
xeruses143010753xeruses_
yarest95018913yar_est
yeses85119323ye_ses_
yesses93615813yesses_
zeroes154314343zeroes_

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 Filter1786911340270.406440125.6
2DLD Change Limit1340274366.01622278.4
3Display Results4364360.1532849.7
 (SQL Overall)1786914366.57527177.3
 
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.