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

Here are the results of your fuzzy-string dictionary search for “parliaments” 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.

67 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
parliaments	15	5	357	(None)
parliament	14	5	465	1	parliament_
paraments	13	5	1155	2	par__aments
aliments	10	3	1109	3	_a_li_ments
armaments	13	4	747	3	_ar_maments
hardiments	16	4	453	3	hardi_ments
parament	12	4	1539	3	par__ament_
paramenta	13	6	886	3	par__amenta
parchments	19	4	498	3	par_chments
parliamentary	20	9	161	3	parliamentary
affixments	25	4	307	4	_affixments
ailments	10	3	943	4	_a__ilments
alignments	13	4	463	4	_a_lignments
aliment	9	3	1670	4	_a_li_ment_
alinements	12	4	713	4	_a_linements
allotments	12	4	446	4	_allotments
apartments	14	4	570	4	apar__tments
arbitraments	16	15	261	4	_arbitraments
arguments	12	5	657	4	_ar_guments
armament	12	4	963	4	_ar_mament_
bailments	13	4	646	4	ba__ilments
calamints	13	4	805	4	ca_l_amints
derailments	14	4	610	4	derailments
filaments	14	4	665	4	_fil_aments
firmaments	17	4	429	4	fir_maments
garments	11	3	996	4	gar___ments
garnishments	18	7	333	4	garnishments
habiliments	18	5	255	4	habiliments
harassments	16	5	343	4	harassments
hardiment	15	4	606	4	hardi_ment_
laments	9	43	1485	4	___l_aments
ligaments	12	4	620	4	___ligaments
merriments	14	4	632	4	merri_ments
ornaments	11	4	663	4	_or_naments
orpiments	13	4	600	4	_orpi_ments
palliates	11	3	1103	4	palliate__s
parakeets	15	4	510	4	par__akeets
paramagnets	16	5	367	4	paramagnets
paramounts	14	4	389	4	par__amounts
parapets	12	3	976	4	par__ape_ts
parchment	18	4	691	4	par_chment_
parents	9	34	1812	4	par____ents
parians	9	35	1973	4	par_ia__n_s
parlante	10	3	969	4	parl_a__nte
parrakeets	16	5	236	4	par_rakeets
parturients	13	5	248	4	parturients
patients	10	8	876	4	pa_ti__ents
pavements	16	4	700	4	pa__vements
payments	15	3	694	4	pa___yments
pediments	14	4	834	4	p_edi_ments
percipients	17	5	366	4	percipients
permanents	14	5	545	4	per_manents
pigments	13	3	734	4	p___igments
portamenti	14	5	420	4	por_tamenti
portamento	14	6	379	4	por_tamento
predicaments	19	5	322	4	predicaments
prepayments	20	5	333	4	p_repayments
prevalents	15	9	497	4	p_revalents
raiments	10	3	990	4	__rai_ments
rearmaments	15	5	426	4	rear_maments
sacraments	14	4	585	4	sa_craments
salients	8	3	956	4	sa_li__ents
sarments	10	3	1196	4	sar___ments
valiants	11	3	779	4	va_lia__nts
variants	11	3	920	4	var_ia__nts
varments	13	3	906	4	var___ments
worriments	15	4	415	4	worri_ments

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.420	425454.8
2	DLD Change Limit	148819	67	9.190	16193.6
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	9.640	18536.4