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

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

101 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
ganef	9	63	2246	(None)
gane	5	51	4530	1	gane_
ganefs	10	48	920	1	ganefs
ganev	9	55	1386	1	ganev
ganof	9	54	2036	1	ganof
gonef	9	52	2129	1	gonef
alef	7	63	4069	2	_alef
ane	3	78	6695	2	_ane_
anes	4	52	5593	2	_anes
anew	7	66	2313	2	_anew
bane	6	52	5043	2	bane_
baned	8	54	3635	2	baned
banes	7	49	4558	2	banes
cane	6	66	5312	2	cane_
caned	8	58	3809	2	caned
caner	7	53	3477	2	caner
canes	7	53	5037	2	canes
fane	7	53	4357	2	fane_
fanes	8	46	3989	2	fanes
gae	4	64	5770	2	ga_e_
gaed	6	60	3151	2	ga_ed
gaen	5	73	2960	2	ga_en
gaes	5	63	4803	2	ga_es
gaff	11	48	2815	2	ga_ff
gaffe	12	41	1165	2	gaffe
gage	6	59	3610	2	gage_
gaged	8	55	2231	2	gaged
gager	7	47	2629	2	gager
gages	7	45	2997	2	gages
gained	8	46	1746	2	gained
gainer	7	41	1749	2	gainer
gale	5	63	4732	2	gale_
galea	6	47	2293	2	galea
gales	6	54	4248	2	gales
game	7	66	4432	2	game_
gamed	9	51	2639	2	gamed
gamer	8	49	2894	2	gamer
games	8	62	3855	2	games
gamey	11	53	2055	2	gamey
gan	4	80	6013	2	gan__
gander	8	43	2276	2	gander
ganevs	10	45	691	2	ganevs
gang	6	60	3197	2	gan_g
ganged	9	46	1919	2	ganged
ganger	8	37	2146	2	ganger
gangs	7	62	2257	2	gangs
ganja	13	14	1000	2	ganja
gannet	7	43	2185	2	gannet
ganofs	10	40	1029	2	ganofs
gape	7	51	3451	2	gape_
gaped	9	61	2353	2	gaped
gaper	8	61	2512	2	gaper
gapes	8	60	3082	2	gapes
garner	7	39	1700	2	garner
garnet	7	39	2841	2	garnet
gases	6	56	3399	2	gases
gate	5	57	4657	2	gate_
gated	7	53	2977	2	gated
gater	6	45	3365	2	gater
gates	6	59	3951	2	gates
gave	8	46	3405	2	gave_
gavel	9	58	1518	2	gavel
gayer	9	45	1919	2	gayer
gaze	14	50	3241	2	gaze_
gazed	16	55	2033	2	gazed
gazer	15	57	2007	2	gazer
gazes	15	54	2591	2	gazes
gene	5	62	3722	2	gene_
genes	6	51	3309	2	genes
genet	6	60	3868	2	genet
gone	5	56	3904	2	gone_
gonefs	10	43	987	2	gonefs
goner	6	60	2516	2	goner
gonif	9	43	2092	2	gonif
gonof	9	52	1865	2	gonof
grief	9	53	1978	2	grief
jane	11	50	3148	2	jane_
janes	12	49	2812	2	janes
kane	8	51	3397	2	kane_
kanes	9	55	2937	2	kanes
lane	4	51	5333	2	lane_
lanes	5	49	4679	2	lanes
mane	6	50	5203	2	mane_
maned	8	66	3410	2	maned
manes	7	66	4896	2	manes
pane	6	49	5029	2	pane_
paned	8	54	3718	2	paned
panel	7	60	2362	2	panel
panes	7	61	4869	2	panes
ranee	5	54	3810	2	ranee
sane	4	59	5434	2	sane_
saned	6	56	3627	2	saned
saner	5	43	3432	2	saner
sanes	5	56	4907	2	sanes
vane	7	55	3469	2	vane_
vaned	9	46	2242	2	vaned
vanes	8	51	3097	2	vanes
wane	7	63	4472	2	wane_
waned	9	58	3178	2	waned
wanes	8	50	4088	2	wanes
waney	11	51	2032	2	waney

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	101	1.766	30464.3
3	Display Results	101	101	0.030	3366.7
	(SQL Overall)	178691	101	1.889	94595.6