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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

120 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
headends	13	32	672	(None)
headend	12	39	836	1	headend_
deadens	9	34	1069	2	deaden_s
headbands	16	4	434	2	headbands
headed	11	40	2047	2	heade_d_
headers	11	38	1939	2	heade_rs
headings	13	35	1049	2	headings
headlands	14	4	490	2	headlands
headwinds	17	4	315	2	headwinds
heavens	13	43	930	2	heaven_s
leadens	8	36	1098	2	leaden_s
yearends	12	23	448	2	yearends
addends	10	35	605	3	_addends
amends	9	47	1328	3	__amends
beaded	10	49	2242	3	beade_d_
beaders	10	41	2018	3	beade_rs
beadings	12	37	1178	3	beadings
calends	10	3	952	3	_calends
cheapens	15	30	594	3	cheapen_s
deaden	8	37	1432	3	deaden__
deadened	11	3	723	3	deadened
deadener	10	3	674	3	deadener
deadeners	11	4	628	3	deadeners
deadeyes	13	4	456	3	deadeyes
deadheads	15	4	402	3	deadheads
deadness	10	3	923	3	deadness
deafens	11	31	725	3	deafen_s
decadents	13	4	639	3	decadents
defends	12	35	877	3	de_fends
deodands	11	4	460	3	deodands
depends	11	34	899	3	de_pends
descends	12	26	698	3	descends
emends	9	57	1143	3	_e_mends
expends	17	21	708	3	_expends
extends	15	22	711	3	_extends
haded	10	52	2762	3	h_ade_d_
hades	9	60	3511	3	h_ade__s
hands	9	53	2738	3	h_a__nds
hardens	11	38	1502	3	harden_s
havens	12	45	1404	3	h_aven_s
headband	15	4	484	3	headband_
header	10	44	2254	3	heade__r
headfuls	15	4	431	3	headfuls
headgears	14	4	315	3	headgears
headhunts	16	4	312	3	headhunts
headiness	13	25	1036	3	headiness
heading	12	29	1911	3	headin_g
headland	13	4	561	3	headland_
headless	12	28	986	3	headless
headlines	13	11	901	3	headlines
headmen	13	25	951	3	headmen__
headpins	14	3	610	3	headpins
headrests	13	24	502	3	headrests
heads	9	51	2711	3	hea___ds
headsets	12	3	605	3	headsets
headstands	15	4	385	3	headstands
headways	18	4	500	3	headways
headwind	16	4	387	3	headwind_
headwords	17	4	534	3	headwords
healed	10	51	2144	3	heale_d_
healers	10	43	1946	3	heale_rs
heaped	12	45	1690	3	heape_d_
heapers	12	36	1667	3	heape_rs
hearers	10	43	1978	3	heare_rs
hearings	12	36	1185	3	hearings
hearkens	15	33	669	3	hearken_s
heartens	11	30	1015	3	hearten_s
heated	10	45	2559	3	heate_d_
heaters	10	42	2522	3	heate_rs
heathens	14	32	1015	3	heathen_s
heaved	13	47	1786	3	heave_d_
heaven	12	39	1260	3	heaven__
heavenly	17	4	370	3	heavenly
heavers	13	37	1719	3	heave_rs
heaves	12	41	2030	3	heave__s
heders	10	41	1976	3	he_de_rs
heeded	11	42	1576	3	heede_d_
heeders	11	42	1374	3	heede_rs
heeds	9	54	2042	3	he__e_ds
herded	11	42	1564	3	herde_d_
herders	11	39	1412	3	herde_rs
hexades	18	37	870	3	hexade__s
heydeys	17	3	286	3	heyde_ys
hoddens	12	37	880	3	hodden_s
hoidens	11	32	908	3	hoiden_s
hoydens	14	34	740	3	hoyden_s
hyaenas	13	3	498	3	hya_enas
kalends	12	3	568	3	_kalends
ladens	7	45	1623	3	_laden_s
lagends	9	4	727	3	_lagends
leaded	8	42	2154	3	leade_d_
leaden	7	45	1522	3	leaden__
leadened	10	3	615	3	leadened
leadenly	12	4	473	3	leadenly
leaders	8	38	1960	3	leade_rs
leadings	10	35	1124	3	leadings
leavens	10	40	930	3	leaven_s
legends	9	3	607	3	le_gends
neatens	7	33	1040	3	neaten_s
peahens	12	30	757	3	peahen_s
pendents	11	3	941	3	pendents
perpends	13	22	775	3	perpends
readds	8	41	1164	3	read__ds
readers	8	38	2377	3	reade_rs
readings	10	35	1264	3	readings
reagents	9	5	962	3	reagents
reascends	12	4	429	3	reascends
reblends	11	3	529	3	reblends
reddens	9	25	978	3	redden_s
relends	8	40	1325	3	re_lends
remends	10	50	1303	3	re_mends
resends	8	35	1371	3	re_sends
seabeds	10	41	722	3	seabe_ds
seaweeds	12	10	445	3	seaweeds
weakens	14	36	706	3	weaken_s
weasands	12	4	456	3	weasands
weazands	21	4	333	3	weazands
weekends	16	4	273	3	weekends
wheatens	14	5	466	3	wheaten_s
yearend	11	28	570	3	yearend_

Search took 7 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	146162	0.423	422437.4
2	DLD Change Limit	146162	120	6.500	22486.5
3	Display Results	120	120	0.046	2608.7
	(SQL Overall)	178691	120	6.969	25640.8