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

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

79 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
insurgences	14	5	462	(None)
insurgence	13	5	500	1	insurgence_
insurgencies	15	5	358	1	insurgencies
incurrences	15	5	533	2	incurrences
indulgences	15	19	403	2	indulgences
insurances	12	4	685	2	insur_ances
insurgency	16	5	346	2	insurgenc_y
insurgents	11	4	439	2	insurgen_ts
resurgences	14	4	500	2	resurgences
esuriences	12	10	530	3	_esuriences
incurrence	14	5	573	3	incurrence_
indigences	14	22	732	3	in_digences
indulgence	14	9	415	3	indulgence_
inferences	15	4	1034	3	infer_ences
inherences	15	6	896	3	inher_ences
insistences	13	5	558	3	insistences
insolences	12	4	711	3	ins_olences
insurance	11	4	744	3	insur_ance_
insurgent	10	4	654	3	insurgen__t
insurgently	15	5	380	3	insurgently
resurgence	13	4	549	3	resurgence_
assurances	12	4	469	4	assur_ances
coinsurances	16	5	301	4	coinsur_ances
concurrences	15	5	440	4	concurrences
convergences	20	14	625	4	convergences
divergences	18	7	449	4	divergences
divulgences	18	5	245	4	divulgences
effulgences	20	6	212	4	effulgences
emergences	15	10	595	4	_emergences
endurances	13	4	493	4	endur_ances
esurience	11	12	600	4	_esurience_
esuriencies	13	5	382	4	_esuriencies
fourpences	17	4	398	4	_fourpences
imprudences	18	5	329	4	imprudences
impudences	17	4	444	4	impu_dences
incidences	15	4	713	4	in_cidences
incipiences	17	5	516	4	incipiences
incumbencies	20	5	317	4	incumbencies
indigence	13	24	788	4	in_digence_
indigencies	15	5	576	4	in_digencies
indigenes	11	22	899	4	in_digen_es
indolences	13	4	657	4	in_dolences
inductances	16	6	351	4	inductances
inelegances	14	5	326	4	inelegances
inference	14	4	1102	4	infer_ence_
influences	15	4	565	4	in_fluences
ingenues	9	4	710	4	in___genues
inherence	14	4	926	4	inher_ence_
inherencies	16	5	647	4	inher_encies
innocences	14	10	607	4	in_nocences
insentiences	14	5	546	4	insentiences
inshrines	12	4	653	4	inshr_in_es
insistence	12	4	600	4	insistence_
insistencies	14	5	405	4	insistencies
insolence	11	4	719	4	ins_olence_
insolvencies	17	5	293	4	insolvencies
insouciances	16	5	253	4	insouciances
instances	11	4	874	4	ins__tances
insurants	9	4	764	4	insur_an_ts
insureds	9	27	761	4	insur_e__ds
insurers	8	37	1013	4	insur_e__rs
insures	7	31	1726	4	insur____es
intervenes	13	10	1264	4	interven_es
intrenches	15	4	581	4	in_tr_enches
intumesces	14	5	307	4	intu_mesces
invariances	16	5	387	4	invariances
isogenies	10	19	881	4	i_s_ogenies
issuances	11	4	464	4	issu__ances
mergences	14	13	755	4	__mergences
occurrences	14	5	277	4	occurrences
pruriences	14	4	470	4	_pruriences
recurrences	15	4	486	4	recurrences
refulgences	17	5	335	4	refulgences
reinsurances	14	5	281	4	reinsur_ances
subgenres	12	4	553	4	__subgenres
surgeries	10	3	1136	4	__surgeries
turgencies	13	4	551	4	__turgencies
urgencies	12	5	664	4	___urgencies
vergences	15	12	806	4	__vergences

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.153	1167915.0
2	DLD Change Limit	148819	79	9.440	15764.7
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	9.623	18569.2