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

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

55 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
resiliencies	14	5	372	(None)
resiliences	13	7	524	1	resilienc_es
residencies	14	4	597	2	resi_dencies
resilience	12	6	562	2	resilienc_e_
deficiencies	20	5	294	3	deficiencies
esuriencies	13	5	382	3	_esuriencies
presidencies	17	5	448	3	presi_dencies
redolencies	14	5	456	3	redol_encies
renitencies	13	4	609	3	reni_tencies
repellencies	16	6	307	3	repellencies
residences	13	6	823	3	resi_denc_es
resiliency	15	7	331	3	resilienc__y
reticencies	15	4	568	3	reti_cencies
saliencies	12	4	613	3	__saliencies
desinences	13	4	721	4	desi_nenc_es
ebulliencies	16	5	178	4	ebulliencies
efficiencies	22	5	252	4	efficiencies
eminencies	14	4	593	4	_emi_nencies
esuriences	12	10	530	4	_esurienc_es
exigencies	20	4	526	4	_exi_gencies
hesitancies	16	4	399	4	hesi_tancies
incipiencies	18	5	371	4	incipiencies
insistencies	14	5	405	4	insistencies
insolvencies	17	5	293	4	insolvencies
leniencies	12	4	619	4	le__niencies
nesciences	14	4	625	4	nes_cienc_es
persistencies	17	5	256	4	persistencies
pestilences	15	4	469	4	pestil_enc_es
presciences	17	12	727	4	pres_cienc_es
proficiencies	22	6	181	4	proficiencies
recencies	13	3	1225	4	re___cencies
recumbencies	20	6	293	4	recumbencies
redolences	13	7	680	4	redol_enc_es
refluences	15	4	551	4	re_fluenc_es
refulgences	17	5	335	4	refulgenc_es
regencies	12	4	928	4	re___gencies
reliances	11	3	962	4	re__lianc_es
renitences	12	4	844	4	reni_tenc_es
resentences	13	4	742	4	resentenc_es
residence	12	6	890	4	resi_denc_e_
resilient	9	4	1011	4	resilien___t
resiliently	14	5	363	4	resilien_tly
resilins	8	30	1337	4	resili_n___s
resinifies	13	4	691	4	resini__fies
resistances	13	4	537	4	resistanc_es
resolidifies	16	5	194	4	resolidifies
resplendencies	19	6	160	4	resplendencies
resplices	13	3	662	4	respli__c_es
resurgences	14	4	500	4	resurgenc_es
reticences	14	4	745	4	reti_cenc_es
saliences	11	10	806	4	__salienc_es
sapiencies	14	4	512	4	__sapiencies
sentiencies	13	4	632	4	se_ntiencies
silences	10	3	1007	4	__sil_enc_es
solvencies	15	4	480	4	__solvencies

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.406	440125.6
2	DLD Change Limit	124790	55	7.673	16263.5
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	8.109	22036.1