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

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

80 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
gonef	9	52	2129	(None)
ganef	9	63	2246	1	ganef
gone	5	56	3904	1	gone_
gonefs	10	43	987	1	gonefs
goner	6	60	2516	1	goner
gonif	9	43	2092	1	gonif
gonof	9	52	1865	1	gonof
agone	6	59	2455	2	agone_
agones	7	57	1986	2	agones
bone	6	59	4932	2	bone_
boned	8	51	3324	2	boned
boner	7	51	3308	2	boner
bones	7	64	4653	2	bones
boney	10	52	2731	2	boney
cone	6	72	5696	2	cone_
coned	8	60	4005	2	coned
cones	7	64	5742	2	cones
coney	10	59	3288	2	coney
done	5	57	4791	2	done_
donee	6	69	3101	2	donee
gane	5	51	4530	2	gane_
ganefs	10	48	920	2	ganefs
ganev	9	55	1386	2	ganev
ganof	9	54	2036	2	ganof
gene	5	62	3722	2	gene_
genes	6	51	3309	2	genes
genet	6	60	3868	2	genet
godet	7	5	3004	2	godet
goer	5	68	2710	2	go_er
goes	5	56	4409	2	go_es
gofer	9	48	1428	2	gofer
golem	8	4	1611	2	golem
golf	8	57	3118	2	go_lf
gomer	8	52	2065	2	gomer
gonad	7	52	1605	2	gonad
goners	7	44	2017	2	goners
gong	6	68	2719	2	gon_g
gonged	9	71	1591	2	gonged
gongs	7	49	2161	2	gongs
gonia	6	41	1753	2	gonia
goniff	13	40	889	2	goniff
gonifs	10	43	1013	2	gonifs
gonofs	10	45	986	2	gonofs
gonzo	15	3	1024	2	gonzo
gooey	9	55	2286	2	gooey
goof	8	54	3687	2	go_of
gooney	10	66	1231	2	gooney
gore	5	57	4496	2	gore_
gored	7	52	2708	2	gored
gores	6	57	4037	2	gores
gowned	11	44	1013	2	gowned
goxes	13	50	1826	2	goxes
grief	9	53	1978	2	grief
hone	7	75	4932	2	hone_
honed	9	53	3226	2	honed
honer	8	53	3209	2	honer
hones	8	81	4449	2	hones
honey	11	56	2991	2	honey
jones	12	50	2818	2	jones
lone	4	58	4913	2	lone_
loner	5	54	3104	2	loner
money	10	48	2684	2	money
none	4	57	4317	2	none_
nones	5	56	3913	2	nones
nonet	5	45	4084	2	nonet
one	3	70	5091	2	_one_
ones	4	61	4653	2	_ones
pone	6	57	4753	2	pone_
pones	7	45	4704	2	pones
sone	4	66	4998	2	sone_
sones	5	54	4414	2	sones
tone	4	69	5374	2	tone_
toned	6	54	3534	2	toned
toner	5	53	3624	2	toner
tones	5	60	4866	2	tones
toney	8	60	2741	2	toney
zone	13	52	3108	2	zone_
zoned	15	40	2026	2	zoned
zoner	14	45	2034	2	zoner
zones	14	55	2804	2	zones

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.296	603685.8
2	DLD Change Limit	53800	80	1.656	32487.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	1.982	90156.9