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

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

79 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
hagadic	14	4	586	(None)
haggadic	16	4	307	1	haggadic
agamic	11	31	1056	2	_agamic
agaric	9	35	1363	2	_agaric
aggadic	12	5	481	2	aggadic
faradic	13	3	769	2	faradic
hagadist	13	4	760	2	hagadist
halakic	16	5	666	2	halakic
hexadic	20	4	541	2	hexadic
vanadic	13	3	674	2	vanadic
acidic	11	36	1213	3	_acidic
again	6	52	1812	3	_aga_in
agamid	10	37	1069	3	_agamid
agapeic	12	4	471	3	_agapeic
agarics	10	31	994	3	_agarics
agnatic	10	3	1097	3	_agnatic
agonic	9	35	1514	3	_agonic
agravic	13	4	589	3	_agravic
amidic	11	40	1287	3	_amidic
anodic	9	28	1313	3	_anodic
arabic	10	3	1273	3	_arabic
asdic	8	38	1409	3	_a_sdic
atavic	11	18	929	3	_atavic
ataxic	15	16	920	3	_ataxic
balladic	13	4	533	3	balladic
bardic	11	3	1292	3	ba_rdic
dryadic	14	4	362	3	dryadic
dyadic	13	3	609	3	_dyadic
ergodic	11	4	550	3	ergodic
fanatic	12	6	1069	3	fanatic
faradaic	14	4	365	3	faradaic
fatidic	13	4	572	3	fatidic
gadi	6	63	2972	3	__gadi_
gadid	8	55	1738	3	__gadid
gadis	7	48	2529	3	__gadis
gamic	10	39	1620	3	__gamic
gonadic	11	7	721	3	gonadic
hadarim	13	11	745	3	hadarim
haematic	15	13	1021	3	haematic
haemic	13	32	1008	3	ha_emic
hagadists	14	4	507	3	hagadists
hagdon	11	8	828	3	hag_don
haggada	13	5	364	3	haggad_a
haggadah	17	6	259	3	haggadah
haggadas	14	6	363	3	haggadas
haggadist	15	4	384	3	haggadist
haggadot	14	4	406	3	haggadot
haggis	11	20	951	3	hag_gis
hagride	12	3	755	3	hagride
halachic	18	6	565	3	halachic
halakhic	20	4	331	3	halakhic
hamada	12	3	992	3	hamad_a
hamadas	13	3	967	3	hamadas
haptic	13	5	1189	3	ha_ptic
hazanim	21	6	462	3	hazanim
hegari	10	3	952	3	hegari_
hegaris	11	3	1043	3	hegaris
hematic	14	18	1674	3	hematic
hepatic	14	17	1277	3	hepatic
heraldic	14	4	516	3	heraldic
herdic	12	31	1230	3	h_erdic
jalapic	18	4	454	3	jalapic
maenadic	13	4	461	3	maenadic
magic	10	58	1865	3	mag__ic
magmatic	15	4	839	3	magmatic
manganic	13	4	699	3	manganic
margaric	13	4	606	3	margaric
monadic	12	6	888	3	monadic
nomadic	12	4	803	3	nomadic
octadic	12	4	571	3	octadic
organic	10	3	831	3	organic
paladin	10	10	1177	3	paladin
palladic	13	4	611	3	palladic
parodic	12	23	1172	3	parodic
saccadic	12	4	417	3	saccadic
satanic	9	3	993	3	satanic
shamanic	15	4	656	3	shamanic
thalamic	15	4	555	3	thalamic
triadic	10	3	783	3	triadic

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.406	440125.6
2	DLD Change Limit	134027	79	7.000	19146.7
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	7.436	24030.5