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

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

83 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
gloved	11	48	1187	(None)
globed	10	48	1176	1	globed
glove	9	45	1629	1	glove_
glover	10	45	1353	1	glover
gloves	10	41	1518	1	gloves
glowed	11	49	1383	1	glowed
glozed	17	37	1122	1	glozed
groved	11	44	1370	1	groved
loved	9	50	2136	1	_loved
alcoved	13	7	561	2	alcoved
beloved	13	18	839	2	beloved
blowed	12	50	1669	2	blowed
cloned	9	45	1880	2	cloned
closed	9	53	1796	2	closed
clove	10	56	1944	2	clove_
cloven	11	42	1151	2	cloven
clover	11	46	1712	2	clover
cloves	11	49	1882	2	cloves
cloyed	12	51	1156	2	cloyed
coved	11	50	2737	2	_coved
droved	11	46	1164	2	droved
eloped	9	59	1414	2	eloped
flowed	13	35	1376	2	flowed
galoped	11	13	807	2	galoped
gaoled	8	48	1450	2	gaoled
glaived	12	37	597	2	glaived
glared	8	47	1519	2	glared
glazed	17	47	1177	2	glazed
gled	6	56	3114	2	gl__ed
gleed	7	53	2057	2	gl_eed
gleyed	11	47	815	2	gleyed
glided	9	45	1390	2	glided
glimed	10	53	1228	2	glimed
gloated	9	35	1153	2	gloated
globe	8	49	1701	2	globe_
globes	9	43	1454	2	globes
glommed	13	26	544	2	glommed
gloomed	11	33	741	2	gloomed
glopped	13	34	761	2	glopped
gloried	9	16	951	2	gloried
glossed	9	44	1007	2	glossed
glouted	9	42	971	2	glouted
glovers	11	43	1088	2	glovers
glower	10	51	1493	2	glower
gloze	15	48	1598	2	gloze_
glozes	16	43	1335	2	glozes
glued	7	51	1836	2	gl_ued
golfed	11	56	976	2	golfed
goofed	11	49	1138	2	goofed
goosed	8	68	1703	2	goosed
gored	7	52	2708	2	g_ored
graved	11	48	1881	2	graved
grooved	12	34	725	2	grooved
groped	10	75	1505	2	groped
grove	9	52	1933	2	grove_
grovel	10	43	1054	2	grovel
groves	10	43	1810	2	groves
gyved	13	56	874	2	g_yved
hooved	13	47	1312	2	hooved
laved	9	50	2859	2	_laved
lived	9	55	2372	2	_lived
lobed	8	60	2213	2	_lobed
looed	6	46	2613	2	_looed
loped	8	51	2833	2	_loped
love	7	52	3476	2	_love_
lover	8	55	2645	2	_lover
loves	8	53	3201	2	_loves
lowed	9	52	3390	2	_lowed
loxed	13	50	1705	2	_loxed
moved	11	42	1815	2	_moved
plover	11	53	1261	2	plover
plowed	12	42	1320	2	plowed
ployed	12	43	1056	2	ployed
proved	12	50	1603	2	proved
roved	9	53	2355	2	_roved
shoved	13	42	1428	2	shoved
slaved	10	40	1704	2	slaved
sloped	9	42	1685	2	sloped
sloven	9	38	963	2	sloven
slowed	10	46	1707	2	slowed
solved	10	53	1293	2	solved
ungloved	13	3	560	2	ungloved
unloved	11	23	1053	2	unloved

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.330	541487.9
2	DLD Change Limit	82551	83	2.593	31836.1
3	Display Results	83	83	0.033	2515.2
	(SQL Overall)	178691	83	2.956	60450.3