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

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

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.

77 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
parclose	12	4	724	(None)
parcloses	13	4	796	1	parcloses
narcose	9	59	1038	2	narc_ose
papulose	12	4	453	2	papulose
paralyse	13	4	748	2	paralyse
amylose	12	3	719	3	_amylose
arenose	7	3	1137	3	_arenose
ariose	6	48	1872	3	_ar_iose
arkose	10	49	1134	3	_ar_kose
arose	5	58	3208	3	_ar__ose
callose	9	3	1366	3	ca_llose
carcase	11	3	1274	3	carc_ase
close	7	64	2522	3	___close
disclose	11	4	874	3	disclose
earlobe	9	4	654	3	ear_lobe
enclose	9	9	999	3	_enclose
farinose	11	3	646	3	farinose
foreclose	14	4	462	3	foreclose
hamulose	13	4	428	3	hamulose
hardnose	12	4	572	3	hardnose
inclose	9	9	1022	3	_inclose
lactose	9	6	949	3	la_ctose
marchese	15	35	891	3	marchese
narcos	8	67	1420	3	narc_os_
narcoses	10	39	1054	3	narc_oses
overclose	14	4	701	3	overclose
papillose	13	9	360	3	papillose
papoose	11	4	751	3	pa_poose
pappoose	11	4	380	3	pappoose
pappose	10	4	741	3	pa_ppose
paraclete	13	5	634	3	paraclete
paradise	11	21	1387	3	paradise
parados	10	38	1605	3	parados_
paradoses	12	25	1025	3	paradoses
paragoge	12	5	715	3	paragoge
paralysed	15	4	574	3	paralysed
paralyses	14	4	828	3	paralyses
paralyze	22	4	662	3	paralyze
paramos	11	32	1351	3	paramos_
parcels	11	37	1266	3	parcels_
parches	14	37	2000	3	parches_
parchesi	15	35	821	3	parchesi
parchisi	15	36	893	3	parchisi
pareos	8	70	2377	3	par_eos_
parflesh	16	4	374	3	parflesh
pargos	9	57	1904	3	par_gos_
parklike	13	3	749	3	parklike
parle	7	58	3616	3	par_l__e
parles	8	63	3440	3	par_les_
parlor	8	3	1267	3	par_lo_r
parlors	9	3	1291	3	par_lors
parlour	9	3	726	3	par_lour
parlous	9	4	1429	3	par_lous
parodos	10	30	1175	3	parodos_
parole	8	44	2525	3	par__ole
parolee	9	41	1964	3	parol_ee
parolees	10	43	1398	3	parolees
paroles	9	50	2588	3	paroles_
parols	8	47	2261	3	parol_s_
parse	7	52	3699	3	par___se
parvise	12	42	1169	3	par_vise
parvos	11	66	1475	3	par_vos_
pilose	8	45	1424	3	p__ilose
porose	8	48	1874	3	por__ose
practise	12	3	1014	3	practise
prechose	15	12	977	3	prechose
propose	11	27	1484	3	p_ropose
prose	7	58	3512	3	p_r__ose
purchase	15	4	529	3	purchase
purpose	11	3	738	3	pur_pose
pyranose	13	4	492	3	pyranose
ramulose	10	4	431	3	ramulose
sabulose	10	4	461	3	sabulose
surculose	11	4	377	3	surculose
talcose	9	3	814	3	talc_ose
unclose	9	11	1164	3	_unclose
varicose	13	4	670	3	varicose

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	77	6.843	21359.3
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.296	24491.6