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

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

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

102 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
deedy	10	43	1589	(None)
deed	6	53	4090	1	deed_
deeds	7	54	2376	1	deeds
needy	9	46	1469	1	needy
reedy	9	100	2028	1	reedy
seedy	9	48	2153	1	seedy
weedy	12	51	1500	1	weedy
beady	11	47	1992	2	beady
beedi	8	7	1166	2	beedi
beefy	13	53	1383	2	beefy
beery	10	52	2012	2	beery
bendy	11	50	1725	2	bendy
daddy	11	62	1256	2	daddy
dandy	10	44	1670	2	dandy
dead	6	54	3424	2	dead_
deadly	11	38	1147	2	deadly
deads	7	57	2691	2	deads
deary	9	58	2684	2	deary
decay	11	47	1848	2	decay
decoy	11	57	1631	2	decoy
decry	11	55	1435	2	decry
dee	4	76	6582	2	dee__
deeded	9	46	1554	2	deeded
deejay	17	3	452	2	deejay
deem	7	54	3289	2	dee_m
deems	8	54	2177	2	deems
deep	7	60	3188	2	dee_p
deeply	12	5	701	2	deeply
deeps	8	49	2177	2	deeps
deer	5	67	3902	2	dee_r
deers	6	49	3052	2	deers
dees	5	63	5663	2	dee_s
deet	5	73	5658	2	dee_t
deets	6	53	3024	2	deets
defy	11	49	2126	2	d_efy
deify	12	41	1276	2	deify
deity	9	43	1677	2	deity
deked	11	57	1853	2	deked_
delay	9	48	2063	2	delay
deled	7	53	2654	2	deled_
delly	9	60	2387	2	delly
demy	10	54	2285	2	d_emy
deny	8	60	2712	2	d_eny
deoxy	16	4	888	2	deoxy
deray	9	50	2418	2	deray
derby	11	47	1534	2	derby
derry	9	47	2137	2	derry
dewed	10	50	2030	2	dewed_
dewy	11	54	1902	2	d_ewy
dexy	15	61	1855	2	d_exy
dey	7	72	4337	2	d_e_y
didy	9	91	2150	2	d_idy
died	6	61	3785	2	died_
doody	10	55	1791	2	doody
dowdy	13	61	1254	2	dowdy
dreed	7	52	2284	2	dreed_
duddy	11	49	1103	2	duddy
dweeby	15	4	299	2	dweeby
dyed	9	67	2076	2	dyed_
eddy	9	39	1209	2	_eddy
eely	7	77	2521	2	_eely
eery	7	61	2962	2	_eery
feed	8	45	3890	2	feed_
feeds	9	49	2114	2	feeds
geed	6	54	3550	2	geed_
geeky	13	47	1073	2	geeky
greedy	11	51	884	2	greedy
heady	12	51	1726	2	heady
heed	8	64	3760	2	heed_
heeds	9	54	2042	2	heeds
jeed	12	54	2850	2	jeed_
leady	9	56	1860	2	leady
leery	8	59	1913	2	leery
meed	7	49	3470	2	meed_
meeds	8	49	2027	2	meeds
neddy	10	47	987	2	neddy
need	5	49	3415	2	need_
needs	6	57	1963	2	needs
nerdy	9	50	1470	2	nerdy
peed	7	62	3918	2	peed_
peery	10	57	1944	2	peery
perdy	11	54	1732	2	perdy
ready	9	48	2150	2	ready
reed	5	55	4962	2	reed_
reeds	6	54	3090	2	reeds
reefy	11	42	1770	2	reefy
reeky	12	54	1626	2	reeky
remedy	12	3	786	2	remedy
seed	5	55	4948	2	seed_
seeds	6	43	3006	2	seeds
seely	8	45	2263	2	seely
seepy	10	47	1797	2	seepy
speedy	12	184	1078	2	speedy
teddy	10	48	949	2	teddy
teed	5	54	3926	2	teed_
teeny	8	54	1788	2	teeny
tweedy	13	45	593	2	tweedy
veery	11	58	1625	2	veery
weed	8	56	3751	2	weed_
weeds	9	52	2221	2	weeds
weeny	11	53	1616	2	weeny
weepy	13	42	1259	2	weepy

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	102	1.720	31279.1
3	Display Results	102	102	0.030	3400.0
	(SQL Overall)	178691	102	1.843	96956.6