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

527 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
pertest931704(None) 
peartest10311301peartest
pretest9517631pretest
aeriest73924052aeriest
alertest8310172alertest
certes84623082certes_
curtest9713962curtest
deftest112611712deftest
detest74122842de_test
eeriest73620672eeriest
featest102715112featest
leftest10269462leftest
merest84725112mer_est
neatest72516002neatest
peatiest103118802peatiest
peltast9310512peltast
percent113520602percent
percept133112522percept
peres76246642per_es_
perfect141010832perfect
perkiest143313242perkiest
perpent112318812perpent
perses85428062perses_
persist9315852persist
perter84422282perte_r
pertness10310092pertness
pervert12315582pervert
pestiest103018412pestiest
pettiest103113962pettiest
portent93619642portent
prest75736352p_r_est
pretests10310012pretests
pretext1639662pretext
priest84125422p_riest
protest9317532protest
purest84021932pur_est
purtiest102414112purtiest
retest64028452re_test
serest64831612ser_est
tartest72517532tartest
tersest71713992tersest
veriest103719132veriest
wettest10239362wettest
acerbest1245463acerbest
acutest94410603acutest
adeptest1145453adeptest
aerates74627493aerates_
aeries64737783aeries_
airest63825263air_est
airiest74221013airiest
aperient10715153aperient
aperies9423203aperies_
aptest82917513_aptest
aretes64425353aretes_
arrest63722633_arrest
artiest73121993_artiest
artist64125543_artist
attest62618613_attest
barest85327693bar_est
beeriest104013403beeriest
behest11314613be_hest
bequest1837823bequest
berates94126873berates_
bereft114317303ber_eft
beret74946363ber_e_t
berets85822523berets_
bermes106023003bermes_
berths114712423berths_
cartes86239473cartes_
cerates95428253cerates_
ceres75540013cer_es_
cerites94823433cerites_
cermet10321153cerme_t
cermets1139713cermets
cetes75731103ce_tes_
chertiest1438793chertiest
contest93523233contest
crest74632693_cr_est
curtesy1265833curtesy
cutest85820143_cutest
daftest11248943daftest
darkest122512623darkest
deadest93014883deadest
deafest112911513deafest
dearest83618673dearest
deepest10310443deepest
deffest14308803deffest
densest83112473densest
dentist8316743dentist
derates84028893derates_
detect94217403de_tect
detent73624483de_tent
detests83711743de_tests
devest104418703de_vest
dewiest11312343dewiest
direst75024243dir_est
dirtiest93014203dirtiest
drest65530343_dr_est
driest74722753_driest
dryest104811123_dryest
earnest7318733earnest
eeliest73516473eeliest
egest65222343_e_gest
eldest72912683_eldest
erect74129333_er_ect
ernes55224813_ernes_
erses55826803_erses_
erst47436433_er__st
extent132714913_extent
farthest1499863farthest
fastest102413723fastest
fattest102913063fattest
fellest10313753fellest
feres86038183fer_es_
ferment12315573ferment
ferniest1132214153ferniest
ferret93021173ferre_t
ferrets103111393ferrets
fervent13310063fervent
fetes85630143fe_tes_
fewest12311663fe_west
feyest12311403fe_yest
fiercest13216143fiercest
fieriest112112243fieriest
firmest1239273firmest
fittest102510803fittest
fleetest1136723fleetest
forest94926743for_est
fortes95327183fortes_
freest95318283_freest
furthest1496863furthest
geest64829613ge__est
gentes75324163gentes_
gentlest93410573gentlest
gerent73223093ger_ent
germiest11249913germiest
gestes75721393gestes_
goriest82218743goriest
greatest939863greatest
greyest11348343greyest
hardest113118413hardest
harvest132112753harvest
heartiest12311103heartiest
heftiest1439183heftiest
heppest14228143heppest
herbiest1339993herbiest
hereat93527413her_eat
heres86245903her_es_
heresy125011233her_esy
heroes94923823heroes_
herpes115517323herpes_
hertzes1938303hertzes_
hottest10411383hottest
hypertext2455133hypertext
iratest7312483iratest
jerkiest19328113jerkiest
jetes124922843je_tes_
jettiest15359593jettiest
justest1449893justest
keenest11410963keenest
kentes105118653kentes_
kermes124616133kermes_
kermess13396223kermess
kernes104717533kernes_
largest83715103largest
latest63822703_latest
leanest7415863leanest
leariest83117843leariest
leeriest83112883leeriest
leftist10279353leftist
lewdest1136283lewdest
meanest9315703meanest
meatiest102816793meatiest
meekest1336893meekest
merces105720743merces_
merdes94518603merdes_
meres75143573mer_es_
merges94122493merges_
merles85322763merles_
merriest10311473merriest
mesteso937133mesteso
metes74736213me_tes_
metres85121563metres_
metrist9317063metrist
miriest93619823miriest
mirkest13309723mirkest
mostest9314793mostest
murkest133110203murkest
mutest84218053_mutest
nearest73415843nearest
nerdiest92511163nerdiest
nerts55924983nert_s_
nerves94216193nerves_
nerviest11188833nerviest
nettiest83112433nettiest
newest9314213ne_west
obtest81213013_obtest
oftest91212003_oftest
oneriest8313443oneriest
openest9312913ope_nest
operates10515413operates_
paciest112917803paciest
palest83926223p_alest
paliest93021603paliest
parent83230423par_ent
pares77164483par_es_
parges94529543parges_
parget94529393parge_t
pargets105215193pargets
paries84742513paries_
parles86334403parles_
parses85534703parses_
parted94228683parte_d
parties93230863parties_
partlet92720363partlet
partlets102811513partlets
parts77743373part_s_
pastes85233913pastes_
pastiest103319543pastiest
patent84524923p_atent
pates76047893p_ates_
peaces106324083peaces_
peages94321853peages_
peakiest143512993peakiest
pearliest1139353pearliest
pearter9412743pearte_r
peartness1137773peartness
peases85229473peases_
peats76140193peat_s_
peckiest162711393peckiest
pectase112410363pectase
pecten102711103pecte_n
pectens11189203pectens
pedes85327293pe_des_
peeress939503peeress
peeries93623023peeries_
peerless1037513peerless
pees65257373pe__es_
peetweet1344973peetweet
peeves113814873peeves_
pegless1038053pegless
peises84125043peises_
pekes114623563pe_kes_
pekoes124410423pekoes_
peles75738083pe_les_
pelites93821993pelites_
pellet83326553pelle_t
pellets94014783pellets
pelmet103419243pelme_t
pelmets11309693pelmets
peltasts1035703peltasts
pelted94617763pelte_d
pelter83321623pelte_r
pelters93720313pelters
peltless10267373peltless
pelts76128813pelt_s_
pelves114514663pelves_
penates93321603penates_
pendent10314723pendent
penes75839223pe_nes_
penitent10413503penitent
pentene9313793pentene
pentose9311593pentose
peones83821043peones_
peppiest11278563peppiest
percents122713373percents
percepts14247643percepts
perches143717953perches_
percuss1137163percuss
perdues103511333perdues_
perdus93711273perdus_
pere66450263per_e__
perea75026443per_e_a
pereia85217983per_eia
pereon83517453per_eon
perfecta15115203perfecta
perfectest1744813perfectest
perfecto15105743perfecto
perfects15107353perfects
perfuse1247663perfuse
periapt11313413periapt
peridot10514243peridot
perils84121853perils_
peris75537073per_is_
perish114619063per_ish
peritus9311803peritus_
perked134617693perke_d
perkish16258823perkish
perks115325803per_ks_
perlites10316363perlites_
permeant12310913permeant
permease1246503permease
permeate12311613permeate
permed115217353perme_d
permit10321683per_mit
permits11314003permits
perms95524513per_ms_
permutes1238713permutes_
perpend12259353perpend
perpents122312043perpents
perps95521483per_ps_
perries93226603perries_
persalt9315413persalt
perse75429523per__se
persists1049183persists
pert66759323per___t
pertain92714963pertain
pertinent11412273pertinent
pertly115312553pert_ly
perturb1146003perturb
perukes133210113perukes_
peruse84016843per_use
perused103112193perused
peruser93511373peruser
peruses94018163peruses
perverse1336103perverse
perverts1337533perverts
pervs105117373per_vs_
peskiest142610163peskiest
pest65555293p___est
pester84827593peste_r
pesters93827093pesters
pestles93217693pestles_
pestos84719083pestos_
pests75933273pest_s_
peter74427593pe_te_r
peters86624593pe_ters
petit74332653pe_t_it
petites93820203petites_
petrel83111533petre_l
petrels9279373petrels
pets66248333pe_t_s_
petted94121523pette_d
petter83924773pette_r
petters93722363petters
pettish1238283pettish
pettles93916483pettles_
pewees11311393pewees_
pewter114013673pewte_r
pewters124113353pewters
peyotes1238483peyotes_
phattest1336913phattest
pierces113411193pierces_
pietist9414033pietist
piniest93121133piniest
pinkest132812623pinkest
pipiest113114493pipiest
pirates93020333pirates_
pistes85325633pistes_
plates85432243plates_
platiest103216083platiest
poetess938933poetess
pokiest133314913pokiest
politest10312943politest
pontes83627853pontes_
poorest9312773poorest
pores75849033por_es_
porkiest143513713porkiest
porniest103214313porniest
porrect1159743porrect
ported94223243porte_d
portend103411193portend
portents103512823portents
porter84224413porte_r
porters93722703porters
portless10310643portless
portliest11310183portliest
portress1038323portress
ports75934593port_s_
poshest12312423poshest
posttest10410233posttest
potent84223353p_otent
pottiest102815973pottiest
poutiest103016793poutiest
poxiest163412253poxiest
prates84633163prates_
precast11314853precast
precent113520263precent
precept133112513precept
precess11310863precess
prees75937173p_rees_
prefect141011073prefect
preheat12413893preheat
prelect111013833prelect
premeet11615153premeet
presa74319043p_r_esa
prese75228383p_r_ese
present94022733present
preset84430983p_r_eset
presets94216423presets
press75425953p_r_ess
presto84216203p_r_esto
prests84021263p_r_ests
pretaste10139523pretaste
preteen939873preteen
pretell938243pretell
pretend104011013pretend
pretense10199823pretense
preterit10315843preterit
preterm11310163preterm
pretested12149113pretested
pretexts1735603pretexts
pretreat10311923pretreat
prettiest1199803prettiest
prevent124016553prevent
prexes154915953prexes_
prezes173614693prezes_
pries74339533p_ries_
priests93810863p_riests
prost75434103p_r_ost
protect11313633protect
protests10310493protests
protist9320223protist
prowest12311533prowest
puniest92918093puniest
punkest132611693punkest
purees84721683purees_
purges94421763purges_
purist85525053pur_ist
purplest12249133purplest
purses84826373purses_
pursiest102812123pursiest
pyres105523883pyr_es_
pyrites12812203pyrites_
rarest65725483rar_est
realest73322433realest
rearrest8311603rearrest
reddest9311953reddest
reest54938093__reest
remotest103310723remotest
renest64529713re_nest
rentes65431193rentes_
request16311023request
rerent63832453rer_ent
rest46459843__r_est
retests73813853re_tests
retreat7317533retreat
revest94623603re_vest
saltest71916513saltest
searest73322023searest
secretest1147033secretest
sedatest9249393sedatest
septet8921133septe_t
septets998953septets
serenest82717623serenest
seres55448893ser_es_
serges74225973serges_
series64540973series_
serpent92916283serpent
serves94423653serves_
sestet6826203seste_t
sestets7911473sestets
sexiest142112223sexiest
sextet13916873sexte_t
sextets1497143sextets
shortest11310783shortest
smartest10310183smartest
softest10310603softest
sorest65028003sor_est
sparest94616423spar_est
sparsest1048813sparsest
spheriest1438373spheriest
spiriest102513453spiriest
sportiest111711023sportiest
spriest92718643spriest
spryest12247813spryest
sternest8314433sternest
subtest9513963subtest
superbest1349963superbest
surest65026763sur_est
sveltest1135873sveltest
sweetest1137173sweetest
tartiest82718313tartiest
tautest72612443tautest
teariest82417263teariest
tempest1139223tempest
tensest72713313tensest
tentiest82115613tentiest
terces83921413terces_
tercet83624913terce_t
tercets93512443tercets
ternes65422903ternes_
terret63425623terre_t
terrets72913583terrets
test48651623___test
testes65125823testes_
testiest82715223testiest
tortes64826053tortes_
tritest7315273tritest
truest64816193_truest
unrest62918853unr_est
urtext1337433_urtext
vastest102911513vastest
verges104320183verges_
verist93823893ver_ist
verites103822263verites_
vermes115019143vermes_
verses94223763verses_
verset94327323verse_t
versets103913103versets
verst84429373ver__st
verstes104014283verstes_
vertex1637373verte_x
verts85724733vert_s_
vertus94613603vertus_
verves124617883verves_
vervet124619063verve_t
vervets13419753vervets
wariest105122503wariest
warmest123113033warmest
wartiest113614643wartiest
wattest102412153wattest
weakest1439003weakest
weariest112914793weariest
weest85026773we__est
weirdest1244433weirdest
wergelt1138583wergelt
whitest133710113whitest
wiriest103816853wiriest
wrest84925433_wr_est
wriest94419713_wriest
wryest12429113_wryest
yarest95018913yar_est
yentes95517603yentes_
yperites13310153yperites_
zeroes154314343zeroes_
zestiest173011103zestiest

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 Filter1786911340270.406440125.6
2DLD Change Limit1340275277.36018210.2
3Display Results5275270.1862833.3
 (SQL Overall)1786915277.95222471.2
 
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.