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

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

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.

100 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
henges	10	45	1646	(None)
hedges	11	50	1626	1	hedges
henge	9	48	1983	1	henge_
hinges	10	51	2103	1	hinges
venges	10	40	1515	1	venges
avenges	11	5	754	2	avenges
beiges	9	10	1441	2	beiges
benes	7	55	3623	2	ben_es
bennes	8	60	1901	2	bennes
binges	9	39	2312	2	binges
censes	8	37	2180	2	censes
changes	13	45	1758	2	changes
conges	9	49	2817	2	conges
denes	6	56	3972	2	den_es
dengues	9	3	818	2	dengues
denies	7	47	2964	2	denies
dinges	8	38	2542	2	dinges
edges	7	57	1874	2	_edges
engs	5	61	2139	2	_eng_s
fences	11	46	1711	2	fences
genes	6	51	3309	2	gen_es
genies	7	53	2494	2	genies
genres	7	55	1562	2	genres
gentes	7	53	2416	2	gentes
hances	11	56	2128	2	hances
hanged	11	42	2239	2	hanged
hanger	10	40	2325	2	hanger
hangers	11	31	2081	2	hangers
hangs	9	57	2672	2	hang_s
hanses	9	50	2263	2	hanses
heaves	12	41	2030	2	heaves
hebes	10	55	2167	2	he_bes
hedge	10	53	1735	2	hedge_
hedged	12	52	1181	2	hedged
hedger	11	49	1265	2	hedger
hedgers	12	43	1026	2	hedgers
heezes	18	42	1164	2	heezes
heinies	10	25	1454	2	heinies
helves	12	43	1606	2	helves
hemes	10	50	3108	2	he_mes
hence	10	49	2004	2	hence_
henley	12	3	748	2	henley
henleys	13	3	484	2	henleys
hennas	9	42	1180	2	hennas
henries	10	27	1828	2	henries
henrys	12	36	610	2	henrys
hens	7	56	4257	2	hen__s
hented	10	42	1875	2	hented
hents	8	73	3074	2	hen_ts
heres	8	62	4590	2	he_res
heroes	9	49	2382	2	heroes
herpes	11	55	1732	2	herpes
heughs	13	51	690	2	heughs
hexes	15	51	2304	2	he_xes
hinge	9	53	2345	2	hinge_
hinged	11	46	1892	2	hinged
hinger	10	47	2333	2	hinger
hingers	11	34	2021	2	hingers
hones	8	81	4449	2	hon_es
hongies	11	27	1647	2	hongies
hongs	9	51	2620	2	hong_s
hunger	10	40	1520	2	hunger
hungers	11	40	1330	2	hungers
kedges	12	48	1298	2	kedges
kentes	10	51	1865	2	kentes
ledges	8	49	1801	2	ledges
leges	6	44	2729	2	le_ges
lenes	5	47	3852	2	len_es
lenses	6	46	2089	2	lenses
longes	7	59	2557	2	longes
lunges	7	61	2342	2	lunges
manges	9	46	2894	2	manges
menages	10	36	1539	2	menages
menses	8	42	2245	2	menses
merges	9	41	2249	2	merges
nenes	5	53	2967	2	nen_es
peages	9	43	2185	2	peages
penes	7	58	3922	2	pen_es
pengos	9	46	1241	2	pengos
ranges	7	38	2692	2	ranges
reges	6	56	2879	2	re_ges
reneges	8	25	1359	2	reneges
rentes	6	54	3119	2	rentes
sedges	8	38	1781	2	sedges
senses	6	39	2394	2	senses
serges	7	42	2597	2	serges
singes	7	43	2685	2	singes
tenge	6	57	2044	2	tenge_
tenses	6	47	2255	2	tenses
tenues	6	38	1644	2	tenues
thenages	12	10	748	2	thenages
tinges	7	47	2233	2	tinges
veges	9	41	1887	2	ve_ges
venge	9	51	1799	2	venge_
venged	11	40	1199	2	venged
venues	9	51	1520	2	venues
verges	10	43	2018	2	verges
wedges	11	46	1458	2	wedges
whinges	14	36	1063	2	whinges
yentes	9	55	1760	2	yentes

Search took 4 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	82551	0.376	475242.0
2	DLD Change Limit	82551	100	2.890	28564.4
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	3.296	54214.5