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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

89 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
eddy	9	39	1209	(None)
eddo	6	34	1180	1	eddo
edgy	9	47	1352	1	edgy
neddy	10	47	987	1	neddy
teddy	10	48	949	1	teddy
add	5	101	3236	2	add_
adds	6	76	2245	2	adds
baddy	12	50	1602	2	baddy
beady	11	47	1992	2	beady
bendy	11	50	1725	2	bendy
biddy	12	46	1269	2	biddy
body	10	74	2567	2	body
buddy	12	48	1263	2	buddy
caddy	12	54	1402	2	caddy
cuddy	12	51	1197	2	cuddy
daddy	11	62	1256	2	daddy
day	7	62	5411	2	_day
deedy	10	43	1589	2	deedy
defy	11	49	2126	2	defy
demy	10	54	2285	2	demy
deny	8	60	2712	2	deny
dewy	11	54	1902	2	dewy
dexy	15	61	1855	2	dexy
dey	7	72	4337	2	_dey
didy	9	91	2150	2	didy
dry	7	65	2603	2	_dry
duddy	11	49	1103	2	duddy
easy	7	62	2449	2	easy
ed	3	86	4518	2	e_d_
edge	6	57	1966	2	edge
edh	7	69	2156	2	e_dh
edhs	8	62	1210	2	edhs
edify	12	30	856	2	edify
edit	5	49	3486	2	edit
eds	4	66	3892	2	e_ds
eely	7	77	2521	2	eely
eery	7	61	2962	2	eery
eggy	9	66	1185	2	eggy
eide	5	58	3223	2	eide
eld	4	67	3379	2	eld_
elds	5	63	2485	2	elds
elmy	9	56	1679	2	elmy
emmy	11	60	1324	2	emmy
emyd	10	4	707	2	emyd
end	4	68	3435	2	end_
ends	5	65	2852	2	ends
envy	10	4	1125	2	envy
espy	9	6	937	2	espy
eyry	10	63	1588	2	eyry
faddy	13	55	1162	2	faddy
fuddy	13	52	1115	2	fuddy
giddy	11	58	1020	2	giddy
heady	12	51	1726	2	heady
hedgy	13	45	1074	2	hedgy
idly	8	56	1732	2	idly
kiddy	14	49	1027	2	kiddy
lady	8	65	2715	2	lady
leady	9	56	1860	2	leady
ledgy	10	57	1201	2	ledgy
middy	12	48	1259	2	middy
muddy	12	38	1223	2	muddy
needy	9	46	1469	2	needy
nerdy	9	50	1470	2	nerdy
noddy	10	54	1120	2	noddy
odd	5	77	2545	2	odd_
oddly	10	3	716	2	oddly
odds	6	89	1992	2	odds
oldy	8	53	1684	2	oldy
paddy	12	59	1359	2	paddy
perdy	11	54	1732	2	perdy
ready	9	48	2150	2	ready
redd	6	63	2317	2	redd_
redds	7	46	1783	2	redds
redly	9	42	1719	2	redly
redry	9	43	1436	2	redry
reedy	9	100	2028	2	reedy
ruddy	10	45	1175	2	ruddy
sedgy	10	45	1278	2	sedgy
seedy	9	48	2153	2	seedy
soddy	10	42	1070	2	soddy
tidy	8	68	2241	2	tidy
toddy	10	68	1242	2	toddy
tody	8	63	2721	2	tody
undy	8	50	1516	2	undy
waddy	13	53	1299	2	waddy
wady	11	53	2499	2	wady
wedgy	13	47	979	2	wedgy
weedy	12	51	1500	2	weedy
widdy	13	61	1218	2	widdy

Search took 1 second 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	29872	0.060	2978183.3
2	DLD Change Limit	29872	89	0.893	33451.3
3	Display Results	89	89	0.013	6846.2
	(SQL Overall)	178691	89	0.966	184980.3