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

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

113 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
gloves	10	41	1518	(None)
cloves	11	49	1882	1	cloves
globes	9	43	1454	1	globes
glove	9	45	1629	1	glove_
gloved	11	48	1187	1	gloved
glover	10	45	1353	1	glover
glovers	11	43	1088	1	glovers
glozes	16	43	1335	1	glozes
groves	10	43	1810	1	groves
loves	8	53	3201	1	_loves
aboves	11	45	1284	2	aboves
alcoves	12	9	787	2	alcoves
aloes	5	49	3367	2	alo_es
blokes	12	38	1388	2	blokes
claves	11	50	2006	2	claves
clones	8	45	2656	2	clones
closes	8	54	2559	2	closes
clove	10	56	1944	2	clove_
cloven	11	42	1151	2	cloven
clover	11	46	1712	2	clover
clovers	12	51	1466	2	clovers
clozes	17	49	1556	2	clozes
coves	10	55	3917	2	_coves
doves	9	47	2815	2	_doves
droves	10	51	1667	2	droves
elopes	8	59	1816	2	elopes
elves	8	51	1874	2	el_ves
floes	8	55	2814	2	flo_es
galores	8	26	1432	2	galores
geodes	8	4	1215	2	geodes
gives	9	53	2487	2	g_ives
glaces	9	42	1802	2	glaces
glades	8	48	2034	2	glades
glaives	11	34	783	2	glaives
glares	7	55	1886	2	glares
glazes	16	53	1564	2	glazes
glebes	9	55	1224	2	glebes
gledes	8	49	1513	2	gledes
glees	6	50	2759	2	gl_ees
glides	8	45	1886	2	glides
glimes	9	47	1752	2	glimes
gloams	9	52	1066	2	gloams
gloats	7	45	1542	2	gloats
globe	8	49	1701	2	globe_
globed	10	48	1176	2	globed
globs	8	56	1640	2	glo_bs
gloggs	9	3	503	2	gloggs
gloms	8	52	1978	2	glo_ms
glomus	9	46	809	2	glomus
glooms	9	62	1168	2	glooms
glops	8	56	1955	2	glo_ps
glories	8	19	1591	2	glories
gloss	6	43	1962	2	glo_ss
glosses	8	40	1412	2	glosses
glosts	7	45	1381	2	glosts
glouts	7	44	1471	2	glouts
glowed	11	49	1383	2	glowed
glower	10	51	1493	2	glower
glowers	11	34	1209	2	glowers
glows	9	55	1803	2	glo_ws
gloze	15	48	1598	2	gloze_
glozed	17	37	1122	2	glozed
glues	6	51	2568	2	gl_ues
glumes	9	45	1681	2	glumes
glutes	7	45	1767	2	glutes
gnomes	9	38	1297	2	gnomes
gnoses	7	65	1516	2	gnoses
goes	5	56	4409	2	g_o_es
gooses	7	57	2305	2	gooses
gores	6	57	4037	2	g_ores
goxes	13	50	1826	2	g_oxes
graves	10	46	2400	2	graves
grooves	11	36	880	2	grooves
gropes	9	52	2040	2	gropes
grove	9	52	1933	2	grove_
groved	11	44	1370	2	groved
grovel	10	43	1054	2	grovel
grovels	11	42	781	2	grovels
gyves	12	57	1155	2	g_yves
hooves	12	48	1548	2	hooves
laves	8	60	3915	2	_laves
lives	8	61	3319	2	_lives
loaves	9	48	1385	2	_loaves
lobes	7	53	3100	2	_lobes
lodes	6	64	3691	2	_lodes
loges	6	65	3420	2	_loges
lopes	7	64	3734	2	_lopes
lores	5	50	4540	2	_lores
loses	5	67	4201	2	_loses
love	7	52	3476	2	_love_
loved	9	50	2136	2	_loved
lover	8	55	2645	2	_lover
lovers	9	42	2343	2	_lovers
lowes	8	57	3246	2	_lowes
loxes	12	52	2747	2	_loxes
moves	10	61	2842	2	_moves
olives	9	43	1395	2	olives
plover	11	53	1261	2	plover
plovers	12	36	1183	2	plovers
pooves	11	39	1471	2	pooves
proves	11	43	2225	2	proves
roves	8	48	3448	2	_roves
shoves	12	49	1942	2	shoves
slaves	9	50	2302	2	slaves
sloes	5	47	2887	2	slo_es
slopes	8	48	2045	2	slopes
sloven	9	38	963	2	sloven
slovens	10	31	657	2	slovens
solves	9	50	1822	2	solves
stoves	9	38	1892	2	stoves
troves	9	47	1911	2	troves
ungloves	12	4	529	2	ungloves
wolves	12	45	1085	2	wolves

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.126	1418182.5
2	DLD Change Limit	82551	113	2.343	35233.0
3	Display Results	113	113	0.030	3766.7
	(SQL Overall)	178691	113	2.499	71505.0