Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “parcenaries” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

81 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
parcenaries	15	5	584	(None)
coparcenaries	19	7	170	2	coparcenaries
mercenaries	15	5	544	2	mercenaries
carpentries	15	4	479	3	carpentries
catenaries	12	4	866	3	ca_tenaries
decenaries	13	4	812	3	_decenaries
larcenies	11	4	753	3	larcen__ies
parcenary	16	4	390	3	parcenar__y
parceners	13	3	745	3	parcener__s
plenaries	11	4	1038	3	p__lenaries
wardenries	14	4	443	3	warden_ries
abhenries	14	4	450	4	_abhen_ries
accessaries	15	17	355	4	_accessaries
actuaries	11	4	756	4	_a_ctuaries
agentries	10	4	823	4	_a_gentries
ancestries	12	4	686	4	_ancestries
ancientries	13	5	451	4	_ancientries
archenemies	18	5	263	4	_archenemies
archeries	14	4	1122	4	_arc_heries
ardencies	12	4	785	4	_arden_cies
arsenates	9	7	937	4	_arsena_tes
arteries	8	3	2148	4	_arte__ries
barberries	14	4	623	4	barbe_rries
barretries	12	4	624	4	barre_tries
canaries	10	3	1894	4	___canaries
cartularies	13	4	537	4	cartularies
centenaries	13	4	648	4	centenaries
coronaries	12	4	1023	4	cor_onaries
decennaries	14	5	426	4	_decennaries
drearies	9	23	1341	4	_dr_e_aries
falconries	15	4	394	4	falcon_ries
granaries	10	15	988	4	_gr_anaries
greeneries	11	6	707	4	_greeneries
larceners	11	3	599	4	larcener__s
mercenarily	18	5	265	4	mercenarily
mercenariness	17	6	258	4	mercenariness
merceries	13	4	1004	4	merce__ries
millenaries	13	5	552	4	millenaries
nascencies	14	4	455	4	nascen_cies
ordinaries	11	4	625	4	_ordinaries
pageantries	14	5	298	4	pageantries
panfries	13	14	920	4	pa___nfries
pantries	10	18	1739	4	pa___ntries
papeteries	14	4	655	4	pa_peteries
parcener	12	3	847	4	parcen___er
paregorics	15	4	320	4	par_egorics
parentages	13	4	548	4	par_entages
parquetries	22	5	412	4	parquetries
parries	9	39	2584	4	par____ries
parsonages	13	25	566	4	parsona_ges
parterres	11	4	805	4	parte__rres
parvenues	14	4	464	4	parven__ues
patencies	13	4	917	4	pa_ten_cies
peccaries	15	4	853	4	p_ec_caries
penuries	10	3	1166	4	p___enuries
percentages	16	5	342	4	percentages
percentiles	15	4	620	4	percentiles
phrensies	14	4	574	4	phr_en_sies
piscaries	13	4	1007	4	pisc__aries
planetaries	13	4	594	4	planetaries
porcelains	14	4	438	4	porcela_ins
prebendaries	17	5	281	4	prebendaries
precharges	18	4	551	4	p_recharges
predries	11	27	1438	4	p_r_e_dries
prelacies	13	3	1005	4	p_r_elacies
prenames	12	3	1164	4	p_r_ena_mes
prepares	12	20	1416	4	p_r_epar_es
primaries	13	4	1083	4	p_r_imaries
proletaries	13	4	845	4	proletaries
purtenances	15	5	386	4	purtenances
reentries	9	3	1176	4	__reentries
sanctuaries	13	5	335	4	sanctuaries
scenarios	11	4	481	4	__scenarios
sceneries	11	4	939	4	__sceneries
secretaries	13	4	542	4	secretaries
septenaries	13	7	535	4	septenaries
sorceries	11	4	993	4	sorce__ries
ternaries	9	3	1164	4	ter__naries
traceries	11	3	1286	4	trace__ries
urinaries	9	4	920	4	_ur_inaries
varletries	13	4	603	4	varle_tries

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	148819	0.436	409841.7
2	DLD Change Limit	148819	81	9.266	16060.8
3	Display Results	81	81	0.046	1760.9
	(SQL Overall)	178691	81	9.748	18331.0