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

Here are the results of your fuzzy-string dictionary search for “poignancies” 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
poignancies	16	5	270	(None)
poignances	15	4	344	1	poignanc_es
poignance	14	4	359	2	poignanc_e_
pregnancies	16	4	456	2	pregnancies
benignancies	17	5	199	3	benignancies
cotenancies	15	4	507	3	cotenancies
dominancies	16	5	395	3	dominancies
malignancies	17	5	173	3	malignancies
piquancies	23	4	323	3	p_iquancies
pliancies	13	4	667	3	pli__ancies
poignancy	17	5	248	3	poignanc__y
regnancies	13	4	541	3	_regnancies
stagnancies	14	5	265	3	stagnancies
coagencies	15	4	562	4	coag_encies
cofinances	17	4	530	4	cofinanc_es
cogencies	14	4	810	4	co_g_encies
consonancies	16	5	392	4	consonancies
constancies	15	4	664	4	constancies
dominances	15	4	568	4	dominanc_es
dormancies	15	6	541	4	do_rmancies
elegancies	13	4	501	4	eleg_ancies
eminencies	14	4	593	4	emi_nencies
exigencies	20	4	526	4	exig_encies
finances	13	3	865	4	_fi_nanc_es
financier	14	4	371	4	_fi_nancier
financiers	15	4	238	4	_fi_nanciers
flagrancies	17	5	296	4	flagrancies
flippancies	20	5	175	4	flippancies
fragrancies	17	5	330	4	fragrancies
infancies	14	4	697	4	__infancies
malignances	16	5	264	4	malignanc_es
mordancies	15	4	470	4	mo_rdancies
nancies	9	35	1684	4	____nancies
opponencies	17	5	269	4	opponencies
ordnances	12	4	475	4	_ordnanc_es
organdies	11	8	721	4	_org_andies
peccancies	15	4	493	4	p_eccancies
penances	12	3	1244	4	p__enanc_es
petulancies	15	5	350	4	petulancies
pinnaces	12	26	886	4	p_inna_c_es
pinnacles	13	27	604	4	p_inna_cles
pinnies	9	33	1844	4	p_i_n_n_ies
piquances	22	4	405	4	p_iquanc_es
piracies	12	3	1264	4	p_i_ra_cies
pittances	13	4	570	4	p_ittanc_es
plangencies	16	5	379	4	plangencies
poignant	11	4	574	4	poignan___t
poignantly	16	5	222	4	poignan_tly
portances	13	4	983	4	po_rtanc_es
postulancies	16	5	262	4	postulancies
potencies	13	6	930	4	po__tencies
primacies	15	4	845	4	pri_ma_cies
privacies	16	4	680	4	pri_va_cies
provenances	18	5	453	4	provenanc_es
puissances	14	4	330	4	puissanc_es
pungencies	15	4	472	4	pung_encies
pyromancies	20	5	487	4	pyromancies
repugnancies	17	5	208	4	repugnancies
sergeancies	14	4	439	4	sergeancies
sonances	10	3	1026	4	so__nanc_es
stagnances	13	4	334	4	stagnanc_es
tenancies	11	4	917	4	__tenancies
vagrancies	16	4	417	4	_vagrancies
vibrancies	17	4	441	4	_vibrancies
voidances	15	4	447	4	voi_danc_es

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	148819	0.720	248181.9
2	DLD Change Limit	148819	65	8.170	18215.3
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	8.923	20025.9