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

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

82 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
geeked	12	45	1016	(None)
gecked	14	69	1193	1	gecked
gleeked	13	34	633	1	gleeked
keeked	10	48	1012	1	keeked
peeked	13	43	1458	1	peeked
reeked	11	37	1764	1	reeked
beaked	13	59	1949	2	beaked
becked	15	54	1776	2	becked
beefed	12	35	1087	2	beefed
beeped	11	53	1345	2	beeped
cheeked	17	39	966	2	cheeked
cleeked	14	35	773	2	cleeked
decked	14	52	1762	2	decked
deeded	9	46	1554	2	deeded
deemed	10	47	1306	2	deemed
deked	11	57	1853	2	_deked
eked	9	67	1802	2	__eked
feezed	19	43	999	2	feezed
gawked	15	46	876	2	gawked
geared	8	53	1774	2	geared
geed	6	54	3550	2	g_e_ed
geek	9	53	2702	2	geek__
geekier	12	28	639	2	geekier
geeks	10	49	1584	2	geek_s
geeky	13	47	1073	2	geek_y
geese	6	43	1600	2	geese_
geezer	16	27	801	2	geezer
gelded	9	45	1211	2	gelded
gelled	8	47	1889	2	gelled
gemmed	12	32	957	2	gemmed
gleed	7	53	2057	2	gle_ed
gleeted	9	37	932	2	gleeted
gleyed	11	47	815	2	gleyed
greed	7	51	2569	2	gre_ed
greened	9	31	1126	2	greened
greeted	9	31	1138	2	greeted
greyed	11	46	1060	2	greyed
heeded	11	42	1576	2	heeded
heeled	10	40	1842	2	heeled
heezed	19	42	1051	2	heezed
jeeped	16	46	984	2	jeeped
jeered	14	39	1279	2	jeered
jerked	18	47	959	2	jerked
kecked	12	51	1317	2	kecked
keeled	11	44	1427	2	keeled
keened	11	40	1363	2	keened
leaked	11	42	1770	2	leaked
leered	7	38	1622	2	leered
lekked	10	39	563	2	lekked
meeker	12	35	998	2	meeker
necked	13	47	1507	2	necked
needed	8	41	1444	2	needed
peaked	13	61	1740	2	peaked
pecked	15	50	1910	2	pecked
peeled	9	41	1971	2	peeled
peened	9	43	1816	2	peened
peeped	11	39	1539	2	peeped
peered	9	38	1949	2	peered
peeved	12	41	1289	2	peeved
perked	13	46	1769	2	perked
recked	13	48	2180	2	recked
reeded	8	40	2256	2	reeded
reefed	10	38	1658	2	reefed
reeker	10	37	1559	2	reeker
reeled	7	47	2553	2	reeled
reeved	10	41	1871	2	reeved
seeded	8	45	2046	2	seeded
seeker	10	36	1536	2	seeker
seeled	7	39	2209	2	seeled
seemed	9	51	1761	2	seemed
seeped	9	43	1752	2	seeped
sleeked	12	35	1088	2	sleeked
smeeked	14	28	722	2	smeeked
steeked	12	40	1047	2	steeked
teemed	9	51	1487	2	teemed
veered	10	36	1274	2	veered
weeded	11	39	1487	2	weeded
weekend	15	3	339	2	weekend
weened	10	40	1373	2	weened
weeted	10	39	1379	2	weeted
yerked	14	50	937	2	yerked
yeuked	14	45	623	2	yeuked

Search took 3 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.360	496363.9
2	DLD Change Limit	82551	82	2.483	33246.5
3	Display Results	82	82	0.016	5125.0
	(SQL Overall)	178691	82	2.859	62501.2