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

Here are the results of your fuzzy-string dictionary search for “geeky” 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.

73 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
geeky	13	47	1073	(None)
geek	9	53	2702	1	geek_
geeks	10	49	1584	1	geeks
reeky	12	54	1626	1	reeky
beaky	14	61	1802	2	beaky
beefy	13	53	1383	2	beefy
beery	10	52	2012	2	beery
cheeky	18	44	861	2	cheeky
deedy	10	43	1589	2	deedy
eek	7	79	3510	2	_eek_
eely	7	77	2521	2	_eely
eery	7	61	2962	2	_eery
gawky	16	56	999	2	gawky
geck	11	57	2199	2	geck_
gecko	12	45	1111	2	gecko
gecks	12	51	1709	2	gecks
gee	4	53	5920	2	gee__
geed	6	54	3550	2	gee_d
geeked	12	45	1016	2	geeked
gees	5	56	4788	2	gee_s
geese	6	43	1600	2	geese
geest	6	48	2961	2	geest
geez	14	64	2486	2	gee_z
gemmy	13	52	1105	2	gemmy
germy	11	51	1366	2	germy
gey	7	57	3830	2	g_e_y
gleek	10	53	1510	2	gleek_
gleeks	11	48	967	2	gleeks
gleety	10	47	919	2	gleety
gley	8	57	2465	2	gle_y
gooky	13	58	1803	2	gooky
greedy	11	51	885	2	greedy
greek	10	59	1594	2	greek_
greeny	10	48	1145	2	greeny
grey	8	56	2404	2	gre_y
gunky	13	55	1411	2	gunky
jerky	19	67	1242	2	jerky
keek	7	56	2497	2	keek_
keeks	8	47	1725	2	keeks
leaky	12	52	1772	2	leaky
leek	8	53	3173	2	leek_
leeks	9	53	1889	2	leeks
leery	8	59	1913	2	leery
meek	10	56	2483	2	meek_
meekly	15	3	519	2	meekly
needy	9	46	1469	2	needy
peaky	14	57	1815	2	peaky
pecky	16	55	1509	2	pecky
peek	10	60	3143	2	peek_
peeks	11	50	2111	2	peeks
peery	10	57	1944	2	peery
perky	14	53	1948	2	perky
pesky	14	59	1156	2	pesky
reedy	9	100	2029	2	reedy
reefy	11	42	1770	2	reefy
reek	8	52	3252	2	reek_
reeks	9	41	2403	2	reeks
rekey	12	40	1473	2	rekey
seedy	9	48	2153	2	seedy
seek	8	59	3548	2	seek_
seeks	9	47	2464	2	seeks
seely	8	45	2263	2	seely
seepy	10	47	1797	2	seepy
sleeky	13	39	896	2	sleeky
teeny	8	54	1788	2	teeny
veery	11	58	1625	2	veery
weedy	12	51	1500	2	weedy
week	11	64	2815	2	week_
weekly	16	3	531	2	weekly
weeks	12	50	1786	2	weeks
weeny	11	53	1616	2	weeny
weepy	13	42	1259	2	weepy
yeuky	15	54	703	2	yeuky

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.376	475242.0
2	DLD Change Limit	53800	73	1.453	37026.8
3	Display Results	73	73	0.013	5615.4
	(SQL Overall)	178691	73	1.842	97009.2