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

Here are the results of your fuzzy-string dictionary search for “hexagons” with Change Limit: [1] [2] [3] [4]

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.

67 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
hexagons	19	4	394	(None)
hexagon	18	4	382	1	hexagon_
decagons	12	3	589	2	decagons
flexagons	20	4	167	2	flexagons
hemagogs	15	4	428	2	hemagogs
heptagons	15	4	345	2	heptagons
hexagonal	20	6	266	2	hexagonal
hexapods	21	4	340	2	hexapods
agons	6	64	2378	3	___agons
beacons	11	4	1073	3	be_acons
celadons	11	3	700	3	celadons
deacons	10	3	1039	3	de_acons
decagon	11	3	586	3	decagon_
demagogs	13	4	388	3	demagogs
dragons	9	3	838	3	_dragons
epigons	10	4	818	3	_epigons
etalons	7	3	907	3	_etalons
examens	16	3	719	3	_examens
exogens	15	3	688	3	_exogens
exons	12	58	1334	3	_ex__ons
flagons	11	3	797	3	_flagons
flexagon	19	4	206	3	flexagon_
hagdons	12	5	852	3	h__agdons
halons	9	57	2071	3	h__alons
heavens	13	43	930	3	he_avens
hegemons	14	4	489	3	hegemons
helicons	13	3	761	3	helicons
hellions	11	3	1003	3	hellions
hemagog	14	4	407	3	hemago_g
hematins	13	17	1468	3	hematins
heparins	13	3	1012	3	heparins
heptagon	14	4	357	3	heptagon_
herons	9	48	2054	3	he__rons
hexades	18	37	870	3	hexa_des
hexads	17	46	820	3	hexa__ds
hexagram	21	4	368	3	hexagram
hexagrams	22	4	309	3	hexagrams
hexamine	20	4	687	3	hexamine
hexamines	21	4	620	3	hexamines
hexane	16	37	953	3	hexa__ne
hexanes	17	31	946	3	hexa_nes
hexaplas	20	4	352	3	hexaplas
hexapod	20	4	365	3	hexapo_d
hexapody	24	4	231	3	hexapody
hexone	16	28	923	3	hex__one
hexones	17	29	914	3	hex__ones
hexosans	18	4	412	3	hexosans
lexicons	17	4	389	3	lexicons
megatons	11	27	970	3	megatons
menazons	19	4	573	3	menazons
negatons	9	29	927	3	negatons
nonagons	9	4	722	3	nonagons
octagons	11	4	449	3	octagons
paragons	11	3	1151	3	paragons
pedagogs	13	12	379	3	pedagogs
pentagons	12	4	615	3	pentagons
perigons	11	3	1008	3	perigons
reagins	8	42	1564	3	re_agins
reasons	7	25	1494	3	re_asons
seasons	7	26	1423	3	se_asons
sextons	14	37	1041	3	sex_tons
tetragons	10	4	535	3	tetragons
vexations	19	3	775	3	vexations
wagons	10	39	1121	3	__wagons
weakons	14	28	780	3	we_akons
weapons	12	27	860	3	we_apons
weasons	10	23	1058	3	we_asons

Search took 10 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	146162	0.486	367677.0
2	DLD Change Limit	146162	67	9.063	16127.3
3	Display Results	67	67	0.013	5153.8
	(SQL Overall)	178691	67	9.562	18687.6