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

Here are the results of your fuzzy-string dictionary search for “heronry” with Change Limit: [1] [2] [3] [4]

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.

85 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
heronry	13	4	604	(None)
felonry	13	29	484	2	felonry
helotry	13	4	565	2	helotry
henry	11	40	1447	2	he__nry
heron	8	50	2550	2	heron__
herons	9	48	2054	2	heron_s
herry	11	49	2247	2	her__ry
aeronomy	13	4	644	3	aeronomy
almonry	12	10	473	3	almonry
barony	11	59	1530	3	baron_y
berry	10	45	2177	3	ber__ry
betony	11	42	1158	3	beton_y
beworry	15	4	374	3	beworry
bronzy	20	30	671	3	_bronzy
canonry	12	3	592	3	canonry
cherry	14	48	1076	3	cher__ry
coronary	13	4	769	3	coronary
crony	10	59	1867	3	_cron_y
deaconry	14	4	332	3	deaconry
derry	9	47	2137	3	der__ry
ebony	10	45	1151	3	_ebon_y
felony	12	37	1032	3	felon_y
fernery	13	3	581	3	fernery
ferny	11	58	1618	3	fer_n_y
ferry	11	60	2080	3	fer__ry
harlotry	14	4	340	3	harlotry
harmony	15	3	817	3	harmon_y
harry	11	53	2295	3	har__ry
hedonic	13	3	904	3	hedonic
hellery	13	32	921	3	hellery
hennery	13	3	530	3	hennery
henrys	12	36	610	3	he__nrys
heraldry	15	4	280	3	heraldry
herby	13	47	1531	3	her__by
herder	10	45	1646	3	herder_
herders	11	39	1412	3	herders
hereby	14	46	833	3	her_eby
hereon	9	39	1436	3	hereon__
heresy	12	50	1123	3	her_esy
hermitry	16	4	445	3	hermitry
hern	7	61	3489	3	her_n__
hernia	9	3	1229	3	her_nia
herns	8	48	2558	3	her_n_s
hero	7	46	3578	3	hero___
heroes	9	49	2382	3	hero_es
heroic	11	35	1692	3	hero_ic
heroics	12	29	1200	3	heroics
heroin	9	44	2059	3	hero_in
heroine	10	35	1748	3	heroine
heroines	11	29	1657	3	heroines
heroins	10	35	1801	3	heroins
heroism	12	3	1101	3	heroism
heroize	19	32	1096	3	heroize
heronries	12	4	848	3	heronries
heros	8	49	3086	3	hero__s
herstory	14	4	669	3	herstory
hexone	16	28	923	3	hexon_e
hexones	17	29	914	3	hexones
hoary	11	45	1676	3	h__oary
honey	11	56	2991	3	h__oney
honky	15	62	1852	3	h__onky
horary	12	3	1038	3	hor_ary
horny	11	56	1962	3	hor_n_y
hurry	11	49	1718	3	hur__ry
irony	8	50	1590	3	_iron_y
jerry	15	50	1618	3	jer__ry
kerry	12	49	1609	3	ker__ry
lemony	11	41	955	3	lemon_y
masonry	12	4	412	3	masonry
memory	13	3	880	3	memo_ry
mercery	14	39	762	3	mercery
mercury	14	36	489	3	mercury
merry	10	47	2148	3	mer__ry
peony	10	57	1756	3	pe_on_y
perjury	19	24	425	3	perjury
peroxy	18	3	825	3	pero_xy
perry	10	52	2271	3	per__ry
serry	8	48	2412	3	ser__ry
sherry	12	45	1041	3	sher__ry
ternary	10	3	834	3	ternary
terry	8	47	2187	3	ter__ry
theory	12	109	836	3	the_o_ry
weaponry	16	4	202	3	weaponry
wherry	15	47	733	3	wher__ry
zedoary	20	4	321	3	zedoary

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	134027	0.403	443402.0
2	DLD Change Limit	134027	85	7.830	17117.1
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	8.263	21625.4