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

532 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
parsecs1142992(None) 
parsec105914481parsec_
parsers94118151parsers
parses85534701parse_s
arses55733872_arse_s
carses85233652carse_s
marses84827112marse_s
parcels113712662parcels
pareos87023772par_eos
parers85530742par_ers
pares77164482par_e_s
pareses94718882pareses
paresis93315092paresis
pareus85420742par_eus
parges94529542parge_s
pargets105215192pargets
paries84742512parie_s
parises94827182parise_s
parkers133816872parkers
parles86334402parle_s
parleys125212372parleys
parrels94713492parrels
parse75236992parse__
parsed96323892parse_d
parser84822372parse_r
parsleys1335082parsleys
parsons93516872parsons
paseos88015812pa_seos
pases75346502pa_se_s
passels93913022passels
passers94717752passers
passes86030472passe_s
pausers94113222pausers
pauses84621472pause_s
perses85428062perse_s
prases84429022prase_s
pursers93916092pursers
purses84826372purse_s
sarsens7311392sarsens
alecs76620733_a_lecs
apres75426403apr_e_s
apses76823913_apse_s
arcs67834783_ar__cs
ardebs937013_ardebs
areas55935773_ar_eas
areca75618633_ar_eca
arecas84817443_ar_ecas
ares45871023_ar_e_s
ariels65119373_ariels
arises65233803_arise_s
arles56735743_arle_s
armers85520273_armers
armets84918353_armets
arpens84814823_arpens
arse46539273_arse__
arsenics1056763_arsenics
arseno6318913_arseno
arsis55722423_ars_is
arsons63917213_arsons
artels66216233_artels
asses55629283_asse_s
assess65710463_assess
assets65617663_assets
baases85218013baase_s
barbels114514433barbels
barbers114317503barbers
barbes104526233barbe_s
barbets114915843barbets
bardes95026933barde_s
bares75457133bar_e_s
bargees105415873bargees
barges94528253barge_s
barkers134318513barkers
barless94317003barless
barleys125011843barleys
barneys12569563barneys
barrels94514363barrels
barrens94414323barrens
barres84427553barre_s
barrets94917103barrets
barters94223053barters
baryes116218503barye_s
bases75644353ba_se_s
basics104915123ba_sics
basses85428303basse_s
bassets96414823bassets
birses84717733birse_s
burses84425513burse_s
carcels114516063carcels
carders104820353carders
careens94514703careens
careers95218783careers
carers85133963car_ers
cares77369183car_e_s
caress85720263car_ess
carets85330773car_ets
carices114220953carices
caries85147623carie_s
carles85435083carle_s
carless95118493carless
carnets93918403carnets
carneys124310543carneys
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carrels95117303carrels
carse74934333carse__
carsick1536343carsick
cartels94618123cartels
carters95327263carters
cartes86239473carte_s
carvels124914593carvels
carvers124817543carvers
carves115128453carve_s
cases75048383ca_se_s
causers94014793causers
causes88026473cause_s
causeys12387223causeys
coarsens10348123coarsens
corsacs1139013corsacs
corses84433463corse_s
corsets94819803corsets
cosecs105015213_cosecs
crases85532313crase_s
cursers94317163cursers
curses85328273curse_s
cusecs10509153_cusecs
daises74318983daise_s
damsels10126713damsels
darers75921873dar_ers
dares66146703dar_e_s
darics94314113dar_ics
darkens12409873darkens
darkeys15356533darkeys
darnels83710433darnels
darners83815773darners
darters84017613darters
dorsels84412583dorsels
dorsers83516303dorsers
earless74316073earless
earners74016453earners
easels65914553ea_sels
eases56041613ea_se_s
erasers74413943erasers
erases64425403erase_s
erses55826803_erse_s
farcers124713443farcers
farces115223323farce_s
fardels11389893fardels
farers95924053far_ers
fares85852873far_e_s
farfels13348213farfels
farles96025783farle_s
farmers124315263farmers
farness102912203farness
fasces114914543fa_sces
gardens93312093gardens
gargets94614573gargets
garlics1038013garlics
garners83815993garners
garnets84115413garnets
garrets84413623garrets
garters84218253garters
garveys14124463garveys
gases65633993ga_se_s
gassers84714633gassers
gasses75724783gasse_s
gorses74723293gorse_s
hansels104011663hansels
hanses95022633hanse_s
hardens113815023hardens
hareems12428203hareems
harems115513823har_ems
hares86255543har_e_s
harkens144112863harkens
harmers124116593harmers
harness102413933harness
harpers124916203harpers
harshens1437603harshens
harslets1137833harslets
hassels104311023hassels
hausens1077633hausens
hawsers13409483hawsers
hawses125113993hawse_s
hearses104414543hearse_s
hirsels10128353hirsels
hoarsens11306033hoarsens
horses94729353horse_s
jarveys20123413jarveys
jerseys1733243jerseys
kaisers11369273kaisers
karsts106012943kars_ts
kerseys1433993kerseys
lapsers93911053lapsers
lapses85217693lapse_s
larders83516943larders
larees65323113lar_ees
lares54852633lar_e_s
larges74824233large_s
largess8408913largess
larkers113014513larkers
lasers64925703la_sers
lases54944763la_se_s
lasses64827593lasse_s
manses84225513manse_s
marcels113212373marcels
marcs95726623mar__cs
mares76457633mar_e_s
marges94525713marge_s
markers133516103markers
markets133314033markets
marrers93414313marrers
marse76231153marse__
marshes123615373marshes
martens93714953martens
marvels123810093marvels
masers84623453ma_sers
masses85028713masse_s
morsels94112663morsels
narcs76122023nar__cs
nares55544153nar_e_s
nauseas735993nauseas
nursers74311833nursers
nurses63919353nurse_s
oarless73913373oarless
oases55330983oa_se_s
pacers105124543pa_cers
paces96741113pa_ce_s
packers153818893packers
packets155114773packets
pacs85842183pa___cs
padders113312873padders
padles95221123padle_s
padres95016983padre_s
paesans93312693paesans
pagers94423253pa_gers
pages85235073pa_ge_s
paisans93614753paisans
paisas84317493pais_as
paise75028333paise__
paisleys1333343paisleys
palaces114216463palaces
pales75753803pa_le_s
palets85122313pa_lets
pallets93919303pallets
palmers113513623palmers
palsies94420273palsies
palters94021683palters
pampers133615933pampers
pandect12310953pandect
pandects1335843pandects
panders103423733panders
panels84716523pa_nels
panes76148693pa_ne_s
pangens103112063pangens
panics103815363pa_nics
paniers94717333paniers
panners93621273panners
pannes85522853panne_s
pansies94521983pansies
panzers184012013panzers
papers105125323pa_pers
paraders113113113paraders
parades104121463parades
parados103816053parados
parae76335703parae__
paramos113213513paramos
parangs104314373parangs
parapets1239763parapets
paraphs1439313paraphs
paras76143043par__as
parasols1039263parasols
parcel103915473parce_l
parch125123003par__ch
parches143720003parches
pardahs13289673pardahs
pardee93922023parde_e
pardners11269193pardners
pardons103817623pardons
pards85634333par__ds
pare66760843par_e__
parecism1458533par_ecism
pared86946763par_e_d
parent83230423par_ent
parents93418123parents
pareo74632603par_e_o
parer75839903par_e_r
paretics122312443paretics
pareu74928743par_e_u
pareve114613013par_eve
parge85831853parge__
parged104922043parge_d
parget94529393parge_t
pargos95719043par_gos
pariahs123812343pariahs
parians93519733parians
parietes10714543parietes
parings104219213parings
paris75145943par__is
parishes13314753parishes
parkas125018023par_kas
parked134425143parke_d
parker124121373parke_r
parks116134463par__ks
parlays123910453parlays
parle75836163parle__
parled94626293parle_d
parley116718363parle_y
parlors9312913parlors
parlous9414293parlous
parodos103011753parodos
parolees104313983parolees
paroles95025883paroles
parols84722613par_ols
parous84024163par_ous
parquets1936413parquets
parrals94414573parrals
parred95024073parre_d
parrel84515983parre_l
parriers103612903parriers
parries93925843parries
parrots9312743parrots
parrs75928673par__rs
pars67560793par___s
parsing103819553parsing
parsley1247803parsley
parsnip1146323parsnip
parsnips1245533parsnips
parson83817903pars_on
partans94418283partans
parted94228683parte_d
partiers103514243partiers
parties93230863parties
partlets102811513partlets
partners102711133partners
partons94620513partons
parts77743373par__ts
partyers13277763partyers
paruras9310533paruras
parures9512693parures
parve109824853parve__
parvenu1247023parvenu
parvenus1335653parvenus
parvis116114803par_vis
parvises133911913parvise_s
parvos116614753par_vos
pase65346863pa_se__
paseo77022513pa_se_o
pashas115117063pa_shas
pashes115828393pa_shes
pass65239953pa_s__s
passe75525693passe__
passed94320943passe_d
passee84522023passe_e
passel85117003passe_l
passer84721033passe_r
passkeys1742323passkeys
passless10247223passless
passus83610293pa_ssus
pastas85422873pa_stas
pastels95215183pastels
pasters94531733pasters
pastes85233913pa_stes
pastis84924323pa_stis
pasts75936503pa_s_ts
patens84820863pa_tens
paters84935833pa_ters
pates76047893pa_te_s
patness92912283patness
patsies93919483patsies
pattens95414923pattens
patters94825193patters
patzers184210573patzers
paupers114311073paupers
pause75021833pause__
paused95114963pause_d
pauser84415963pause_r
pavers115021823pa_vers
paves104833923pa_ve_s
pavisers13387443pavisers
pavises125315493pavise_s
pawers114818783pa_wers
pawnees12298173pawnees
pawners124311073pawners
paxes144928423pa_xe_s
payees114812903pa_yees
payers114621823pa_yers
pearlers1039033pearlers
peases85229473pease_s
pecs84634103p___ecs
peises84125043peise_s
pensees9311203pensees
peres76246643per_e_s
perfect141010833perfect
perfects15107353perfects
perse75429523perse__
persons93717013persons
perusers10328803perusers
peruses94018163peruse_s
pharisees1444633pharisees
pharoses13310323pharose_s
phases114618403phase_s
phrases12711463phrase_s
physeds16344033physeds
physes14399783physe_s
physics17265963physics
pissers95014753pissers
pisses84525083pisse_s
pluses83618073pluse_s
poisers94214433poisers
poises84226543poise_s
pores75849033por_e_s
porkers134314933porkers
porrect1159743porrect
porters93722703porters
posers84223973p_osers
poses74642763p_ose_s
posses85128803posse_s
possess9419123possess
possets94212773possets
praisers103410833praisers
praises94121103praise_s
prances113618773prances
prase76128753prase__
praters94921653praters
prates84633163prate_s
praxes156215183praxe_s
prayers124212853prayers
precis103416703p_r_ecis
preens85020113p_reens
prees75937173p_r_ees
preps96220693p_r_eps
presets94216423presets
press75425953p_r_ess
prests84021263p_rests
preys105717783p_r_eys
prices104524543p_rices
priers84521193p_riers
pries74339533p_rie_s
prises84133173prise_s
proems104711163p_roems
prosect11313393prosect
prosects1239473prosects
prosers94219643prosers
proses84733473prose_s
pryers115012243p_ryers
ptoses83514673ptose_s
pulsers94213153pulsers
pulses83818663pulse_s
purees84721683pur_ees
purgers104714003purgers
purges94421763purge_s
purse76028893purse__
pursed95220883purse_d
purser85020473purse_r
pursuers10376523pursuers
pursues94111373pursues
purveys15615903purveys
puses75532203p_use_s
pusses84322843pusse_s
pyoses114314303pyose_s
pyres105523883pyr_e_s
raisers73617393raisers
raises64826543raise_s
rares55247443rar_e_s
rasers64526783ra_sers
rases55447213ra_se_s
recs65734183__r_ecs
sanseis73011603sanseis
sarees65329943sar_ees
sarges75128593sarge_s
saroses73619333sarose_s
sarsars73512143sarsars
sarsen6314233sarse_n
sarsnets836783sarsnets
sasses64124393sasse_s
secs65033893___secs
sparers94519613spar_ers
spares84834553spar_e_s
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
sparse84516343sparse__
sparsely1335123sparsely
sparser94311483sparse_r
sparsest1048823sparsest
tanrecs934823tanrecs
tares57456563tar_e_s
targes74524603targe_s
targets84314223targets
tarmacs1138323tarmacs
tarocs84615663tar_ocs
tarres64723043tarre_s
tarsals72512603tarsals
tarsias74013373tarsias
tarsiers8298533tarsiers
tarsus6310513tars_us
tassels74510853tassels
tasses64826763tasse_s
tassets75012773tassets
tawses94913193tawse_s
torses64727953torse_s
upases84112903upa_se_s
urases63723563urase_s
valses94514613valse_s
varices123313573varices
variers103712663variers
varies94330873varie_s
varlets10411573varlets
varuses10310623varuse_s
varves124414783varve_s
vases84626263va_se_s
versers103813523versers
verses94223763verse_s
versets103913103versets
wadsets1136443wadsets
wardens113711903wardens
warders113416813warders
wares88250583war_e_s
warless104015103warless
warmers124514293warmers
warners103315563warners
warpers123413583warpers
warrens103810893warrens
warsaws1335763warsaws
warslers11328073warslers
warsles103413643warsles
worsens104610263worsens
worses95522953worse_s
worsets105512843worsets
yarders113211593yarders
yarners104312203yarners

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.436409841.7
2DLD Change Limit1340275326.71619956.4
3Display Results5325320.1902800.0
 (SQL Overall)1786915327.34224338.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.