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

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

65 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
pertinencies	16	5	457	(None)
pertinences	15	4	574	1	pertinenc_es
impertinencies	20	6	214	2	impertinencies
permanencies	18	5	356	2	permanencies
pertinence	14	4	583	2	pertinenc_e_
eminencies	14	4	593	3	_e_minencies
impertinences	19	5	359	3	impertinenc_es
permanences	17	5	449	3	permanenc_es
persistencies	17	5	256	3	persistencies
pertinency	17	5	416	3	pertinenc__y
pestilences	15	4	469	3	pestilenc_es
presidencies	17	5	448	3	presidencies
reticencies	15	4	568	3	re_ticencies
sentiencies	13	4	632	3	senti_encies
abstinences	15	5	290	4	abstinenc_es
astringencies	16	6	208	4	astringencies
continences	15	8	858	4	continenc_es
contingencies	18	5	352	4	contingencies
desinences	13	4	721	4	de_sinenc_es
eminences	13	4	740	4	_e_minenc_es
exigencies	20	4	526	4	_e_xigencies
fervencies	18	4	518	4	fer__vencies
imminencies	17	5	396	4	_imminencies
impermanencies	22	6	157	4	impermanencies
impertinence	18	5	364	4	impertinenc_e_
leniencies	12	4	619	4	le_ni_encies
patencies	13	4	917	4	p_at__encies
patiences	13	6	743	4	p_ati_enc_es
pendencies	15	4	702	4	pe__ndencies
penitences	14	4	797	4	pe_nitenc_es
percipiences	20	5	314	4	percipienc_es
perigynies	16	4	396	4	per_igyn_ies
perimetries	15	4	778	4	per_imetries
peripeties	14	4	839	4	per_ipe_ties
perkinesses	17	4	892	4	perkine_sses
permanence	16	5	486	4	permanenc_e_
persistences	16	5	386	4	persistenc_es
pertinacious	16	5	280	4	pertin_acious
pertinacities	17	5	453	4	pertinacities
pertinacity	18	5	410	4	pertin_acity
pertinent	11	4	1227	4	pertinen___t
pertinently	16	5	446	4	pertinen_tly
pertnesses	12	3	1031	4	pert_ne_sses
pestilence	14	5	454	4	pestilenc_e_
petrogenies	14	6	666	4	petrogen_ies
pettinesses	13	3	863	4	pettine_sses
petulancies	15	5	350	4	pe_tulancies
potencies	13	6	930	4	p_ot__encies
precedencies	19	5	372	4	precedencies
preeminences	18	8	352	4	preeminenc_es
prefinances	18	7	501	4	prefinanc_es
pregnancies	16	4	456	4	p_regnancies
prepotencies	18	8	429	4	prepotencies
pretences	13	23	1261	4	pret__enc_es
prominences	17	4	486	4	prominenc_es
pruriencies	15	5	361	4	p_ruriencies
purtenances	15	5	386	4	purtenanc_es
purulencies	15	5	357	4	pur_ulencies
renitencies	13	4	609	4	re_nitencies
residencies	14	4	597	4	re_sidencies
reticences	14	4	745	4	re_ticenc_es
retinenes	9	4	1037	4	re_tinen__es
sentiences	12	4	760	4	senti_enc_es
stridencies	14	5	403	4	str_idencies
stringencies	15	5	352	4	str_ingencies

Search took 9 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	124790	0.390	458182.1
2	DLD Change Limit	124790	65	7.826	15945.6
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	8.262	21628.1