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

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

82 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
hexadic	20	4	541	(None)
hagadic	14	4	586	2	hagadic
hematic	14	18	1674	2	hematic
hepatic	14	17	1277	2	hepatic
heraldic	14	4	516	2	heraldic
herdic	12	31	1230	2	he_rdic
hexad	16	49	1062	2	hexad__
hexade	17	43	890	2	hexad_e
hexades	18	37	870	2	hexades
hexads	17	46	819	2	hexad_s
hexylic	22	4	303	2	hexylic
aggadic	12	5	481	3	aggadic
ceramic	13	3	982	3	ceramic
dryadic	14	4	362	3	dryadic
dyadic	13	3	609	3	_dyadic
enatic	8	3	1756	3	_enatic
exilic	15	9	778	3	_exilic
exonic	15	32	1141	3	_exonic
exotic	15	31	1265	3	_exotic
faradic	13	3	769	3	faradic
geodic	10	4	800	3	ge_odic
gonadic	11	7	721	3	gonadic
haematic	15	13	1021	3	haematic
haggadic	16	4	307	3	haggadic
halakic	16	5	666	3	halakic
head	8	71	3717	3	he_ad__
headed	11	40	2047	3	he_aded
header	10	44	2254	3	he_ader
headier	11	32	1295	3	he_adier
headily	14	7	862	3	he_adily
heading	12	29	1911	3	he_ading
headpin	13	3	600	3	he_adpin
heads	9	51	2711	3	he_ad_s
heady	12	51	1726	3	he_ad_y
hebetic	14	3	863	3	hebetic
hectic	13	23	1152	3	he_ctic
hedonic	13	3	904	3	hedonic
hegari	10	3	952	3	hegari_
hegaris	11	3	1043	3	hegaris
hematics	15	17	1219	3	hematics
hematin	12	15	1602	3	hematin
hemic	12	57	1862	3	he__mic
heparin	12	4	1043	3	heparin
hepatica	15	17	759	3	hepatica
hepatics	15	19	893	3	hepatics
herdics	13	24	952	3	he_rdics
heretic	12	3	1483	3	heretic
heroic	11	35	1692	3	he_roic
hetaeric	13	4	676	3	hetaeric
hexagon	18	4	382	3	hexagon
hexamine	20	4	687	3	hexamine
hexane	16	37	953	3	hexa_ne
hexanes	17	31	946	3	hexanes
hexapla	19	4	334	3	hexapla
hexapod	20	4	365	3	hexapod
hexastich	24	4	334	3	hexastich
hexed	16	56	1576	3	hexed__
hieratic	13	4	922	3	hieratic
keramic	15	3	723	3	keramic
lexemic	18	4	428	3	lexemic
maenadic	13	4	461	3	maenadic
medic	10	46	1965	3	me__dic
melanic	11	3	1040	3	melanic
melodic	12	3	854	3	melodic
monadic	12	6	888	3	monadic
nematic	11	17	1399	3	nematic
nomadic	12	4	803	3	nomadic
octadic	12	4	571	3	octadic
oxalic	15	3	709	3	_oxalic
oxidic	16	3	594	3	_oxidic
pelagic	12	3	786	3	pelagic
rhematic	15	18	892	3	rhematic
sebacic	13	4	639	3	sebacic
sebasic	11	4	689	3	sebasic
sematic	11	17	1687	3	sematic
tetanic	9	8	1013	3	tetanic
tetradic	11	4	581	3	tetradic
thematic	15	20	1148	3	thematic
triadic	10	3	783	3	triadic
vanadic	13	3	674	3	vanadic
venatic	12	3	1152	3	venatic
veridic	13	3	814	3	veridic

Search took 8 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	134027	0.140	1276364.3
2	DLD Change Limit	134027	82	6.873	19500.5
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.046	25360.6