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

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

70 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
methodic	16	5	691	(None)
cathodic	16	12	675	2	cathodic
kathodic	18	11	457	2	kathodic
melodic	12	3	854	2	me_lodic
meteoric	12	4	730	2	meteoric
method	12	3	902	2	method__
methodical	18	4	514	2	methodical
methodise	15	4	551	2	methodise
methodism	17	4	523	2	methodism
methodist	15	4	701	2	methodist
methodize	24	4	571	2	methodize
methods	13	3	888	2	method_s
methylic	18	4	600	2	methylic
metopic	13	3	976	2	met_opic
aetheric	13	4	1016	3	aetheric
ametropic	15	4	565	3	ametropic
anthodia	12	4	780	3	anthodia
benthonic	16	4	459	3	benthonic
catholic	15	15	838	3	catholic
chthonic	18	4	618	3	chthonic
echoic	13	3	904	3	_echo_ic
ergodic	11	4	550	3	_ergodic
etheric	12	3	1178	3	_etheric
ethic	10	15	1122	3	_eth__ic
ethnic	11	4	885	3	_eth_nic
ethylic	15	4	632	3	_ethylic
geodic	10	4	800	3	ge__odic
ketonic	13	4	992	3	ket_onic
ketotic	13	4	864	3	ket_otic
mechanic	17	4	761	3	mechanic
medic	10	46	1965	3	me___dic
mehndi	12	3	315	3	me_hndi_
mehndis	13	4	358	3	me_hndis
meiotic	11	4	1093	3	me_iotic
melodia	10	3	888	3	me_lodia
melodica	13	4	498	3	me_lodica
mephitic	17	4	714	3	mephitic
meropic	13	3	1026	3	me_ropic
mesonic	11	3	1009	3	me_sonic
metabolic	15	4	532	3	metabolic
metallic	12	4	764	3	metallic
metaphoric	19	5	595	3	metaphoric
metazoic	21	4	543	3	metazoic
methadon	14	4	452	3	methadon
methodised	17	5	378	3	methodised
methodises	16	4	546	3	methodises
methodisms	18	4	456	3	methodisms
methodistic	19	5	423	3	method~~ist~~ic
methodists	16	4	497	3	methodists
methodized	26	4	482	3	methodized
methodizes	25	4	558	3	methodizes
methoxide	22	4	417	3	methoxide
methoxy	22	4	394	3	metho_xy
methoxyl	23	4	273	3	methoxyl
metric	10	3	1467	3	met__ric
mitotic	11	3	971	3	mit_otic
monodic	12	6	978	3	m_onodic
motoric	11	3	1222	3	mot_oric
mythic	16	3	727	3	myth__ic
mythoi	14	41	713	3	mytho_i_
mythopeic	21	6	349	3	mythopeic
orthotic	13	4	821	3	orthotic
periodic	13	4	843	3	periodic
petrolic	12	4	969	3	petrolic
plethoric	16	4	465	3	plethoric
pythonic	18	4	755	3	pythonic
retrodict	12	4	750	3	retrodict
rhodic	12	22	723	3	__rhodic
tetradic	11	4	581	3	tetradic
thoric	11	43	1404	3	__thoric

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.406	440125.6
2	DLD Change Limit	146162	70	8.856	16504.3
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	9.295	19224.4