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

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

78 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
insectaries	13	5	488	(None)
nectaries	11	4	981	2	_n_ectaries
sectaries	11	3	1224	2	__sectaries
injectables	22	5	281	3	injectables
insectary	14	4	421	3	insectar__y
insecticides	17	5	259	3	insecticides
intestacies	13	5	530	3	intestacies
inventories	14	5	469	3	inventories
nectaried	12	4	544	3	_n_ectaried
nectarines	12	4	689	3	_n_ectarines
ancestries	12	4	686	4	ancest_ries
anticaries	12	4	1247	4	antic_aries
bisectrices	17	5	231	4	bisect_rices
dietaries	10	4	1066	4	_die_taries
directories	14	4	600	4	directories
dysenteries	15	5	427	4	dysenteries
electuaries	13	5	423	4	_electuaries
hectares	13	3	885	4	__hectar_es
incendiaries	15	5	269	4	incendiaries
indecencies	16	5	582	4	indecencies
indentures	11	4	486	4	indentur_es
inductances	16	6	351	4	inductances
industries	11	4	528	4	indust_ries
infantries	13	4	469	4	infant_ries
infecters	14	25	758	4	infecter__s
infectors	14	21	855	4	infector__s
infirmaries	16	5	299	4	infirmaries
injectable	21	4	700	4	injectable_
injectants	19	4	328	4	injecta_nts
injectors	18	21	672	4	injector__s
inscapes	12	3	781	4	ins_c_a_pes
inscribes	13	4	520	4	ins_c__ribes
insectan	10	4	538	4	insecta___n
insecticide	16	5	287	4	insecticide
insectile	11	4	711	4	insect__ile
insectivores	17	10	172	4	insectivores
insects	9	37	1084	4	insect____s
insecure	10	4	465	4	insec_ur_e_
insecurities	14	5	395	4	insecurities
insecurity	15	5	297	4	insec_urity
inserters	9	22	1028	4	inserter__s
insetters	9	18	713	4	insetter__s
insnares	8	5	808	4	ins__nar_es
inspectorates	17	6	168	4	inspectorates
inspectors	14	4	493	4	inspector__s
instances	11	4	874	4	ins__tances
instancies	12	4	661	4	ins__tancies
instarred	10	4	396	4	ins__tarred
instars	7	4	1113	4	ins__tar__s
instates	8	16	1583	4	ins__ta_tes
intermarries	14	5	485	4	intermarries
interties	9	3	2033	4	intert__ies
intestates	10	15	943	4	intesta_tes
invectives	18	8	589	4	invect_ives
inventoried	15	5	284	4	inventoried
invertases	13	4	578	4	inverta_ses
isocracies	14	4	497	4	i_socracies
isostacies	12	4	443	4	i_sostacies
isostasies	10	4	367	4	i_sostasies
mesenteries	13	4	589	4	mesenteries
misentries	12	4	782	4	misent_ries
nectarial	11	4	710	4	_n_ectarial
nectarine	11	4	698	4	_n_ectarine
nectarous	11	4	471	4	_n_ectarous
nectars	9	3	846	4	_n_ectar__s
nonsectarian	14	6	402	4	nonsectarian
notaries	8	3	1493	4	_n__otaries
peccaries	15	4	853	4	__peccaries
piscaries	13	4	1007	4	pis_c_aries
rectories	11	3	1464	4	__rectories
refectories	16	4	641	4	refectories
rosemaries	12	4	603	4	rose_maries
secretaries	13	4	542	4	__secretaries
sectarian	11	4	753	4	__sectarian
sectarians	12	4	583	4	__sectarians
sentries	8	13	1805	4	__sent_ries
sextarius	16	4	421	4	__sextarius
vasectomies	18	5	449	4	vasectomies

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.173	1032896.0
2	DLD Change Limit	148819	78	9.326	15957.4
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.545	18720.9