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

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

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
ergodic	11	4	550	(None)
ergotic	10	4	972	1	ergotic
argotic	10	3	1028	2	argotic
erotic	8	26	2027	2	er_otic
periodic	13	4	843	2	periodic
rhodic	12	22	723	2	_rhodic
aerobic	11	3	1021	3	aer_obic
aggadic	12	5	481	3	aggadic
agonic	9	35	1514	3	_agonic
anodic	9	28	1313	3	_anodic
aperiodic	14	4	406	3	aperiodic
arkosic	13	4	606	3	arkosic
bromic	12	24	1269	3	br_omic
cerotic	11	4	1506	3	cer_otic
cryonic	14	3	783	3	cryonic
dipodic	13	9	759	3	dipodic
druidic	11	4	353	3	druidic
dryadic	14	4	363	3	dryadic
ecbolic	13	4	562	3	ecbolic
echoic	13	3	904	3	echo_ic
ectopic	13	3	815	3	ectopic
eidolic	10	4	706	3	eidolic
embolic	13	4	742	3	embolic
emodin	9	3	1035	3	e_modin
enolic	8	4	1335	3	e_nolic
entopic	11	4	995	3	entopic
epigonic	13	4	672	3	epigonic
episodic	13	4	425	3	episodic
erethic	12	5	772	3	erethic
ergastic	11	10	662	3	ergastic
ergo	5	64	2015	3	ergo___
ergodicity	17	5	299	3	ergodic~~ity~~
ergogenic	13	4	549	3	ergogenic
ergonomic	14	4	421	3	ergonomic
ergot	6	54	2289	3	ergo__t
ergotism	11	4	627	3	ergotism
ergots	7	45	1237	3	ergo_ts
eristic	9	8	1409	3	eristic
erode	6	45	2099	3	er_od_e
eroded	8	43	1358	3	er_oded
erodes	7	48	1988	3	er_odes
eroding	9	3	1427	3	er_oding
erogenic	11	11	1054	3	erogenic
erotica	9	28	1151	3	er_otica
erotics	9	19	1415	3	er_otics
erratic	9	3	1112	3	erratic
eugenic	10	3	860	3	eugenic
exergonic	19	4	351	3	exergonic
exonic	15	32	1141	3	e_xonic
exotic	15	31	1265	3	e_xotic
frolic	11	4	920	3	fr_olic
geodic	10	4	800	3	_geodic
hagadic	14	4	586	3	hagadic
heraldic	14	4	516	3	heraldic
herdic	12	31	1230	3	her__dic
heroic	11	35	1692	3	her_o_ic
iodic	8	48	1675	3	__iodic
iridic	9	32	874	3	ir_idic
ironic	8	3	1377	3	ir_onic
melodic	12	3	854	3	melodic
meropic	13	3	1026	3	mer_opic
methodic	16	5	692	3	methodic
monodic	12	6	978	3	monodic
odic	7	49	2057	3	___odic
organic	10	3	831	3	organic
orgic	8	3	1182	3	org__ic
parodic	12	23	1172	3	parodic
periodid	12	4	816	3	periodid
periotic	12	3	1344	3	periotic
prosodic	13	4	769	3	prosodic
rhotic	11	27	1123	3	_rhotic
sermonic	12	4	888	3	sermonic
sodic	8	49	1749	3	__sodic
synodic	13	4	736	3	synodic
triadic	10	3	783	3	triadic
tripodic	13	4	533	3	tripodic
tropic	10	30	1419	3	tr_opic
veridic	13	3	814	3	ver_idic
xerotic	16	4	1086	3	xer_otic
zygotic	22	5	466	3	zygotic

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	80	7.296	18369.9
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	7.735	23101.6