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

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

77 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
leprotic	12	4	858	(None)
aprotic	11	27	1524	2	_aprotic
cerotic	11	4	1506	2	ce_rotic
diprotic	13	4	855	2	diprotic
erotic	8	26	2027	2	_e_rotic
leptonic	12	4	770	2	leptonic
leukotic	14	4	452	2	leukotic
necrotic	12	3	1004	2	necrotic
nephrotic	16	4	629	2	nephrotic
nepotic	11	3	1056	2	nep_otic
neurotic	10	3	969	2	neurotic
xerotic	16	4	1086	2	xe_rotic
acrotic	11	25	1554	3	_acrotic
aerobic	11	3	1021	3	ae_robic
aleuronic	11	4	469	3	aleuronic
aphotic	14	29	1312	3	_aphotic
demotic	12	4	1235	3	de_motic
despotic	13	4	653	3	despotic
dicrotic	13	4	888	3	dicrotic
epidotic	13	4	688	3	_epidotic
ergotic	10	4	972	3	_ergotic
erotica	9	28	1151	3	_e_rotica
erotics	9	19	1415	3	_e_rotics
erratic	9	3	1112	3	_erratic
euphotic	15	11	752	3	euphotic
exotic	15	31	1265	3	_e_xotic
ferritic	13	4	707	3	ferritic
fibrotic	15	4	572	3	fibrotic
fluorotic	14	4	398	3	fluorotic
gerontic	11	4	796	3	ge_rontic
hepatic	14	17	1277	3	hep_atic
heretic	12	3	1483	3	he_retic
heroic	11	35	1692	3	he_ro_ic
herpetic	15	4	777	3	herpetic
heterotic	14	4	902	3	heterotic
hidrotic	14	4	690	3	hidrotic
hypnotic	18	4	662	3	hypnotic
kenotic	13	5	971	3	ke_notic
ketotic	13	4	864	3	ke_totic
klephtic	19	4	287	3	klep_htic
kyphotic	22	4	577	3	kyphotic
lentic	8	35	1574	3	le__ntic
leporid	10	4	815	3	lep_orid
leprose	9	3	854	3	lepro_se
leprosies	11	4	680	3	leprosies
leprosy	12	4	422	3	lepro_sy
leprous	9	3	884	3	lepro_us
leptin	8	25	1233	3	lep__tin
leucitic	12	4	523	3	leucitic
leviratic	14	4	372	3	leviratic
litotic	9	3	924	3	l_itotic
lordotic	11	4	499	3	lordotic
lotic	7	64	2067	3	l___otic
meiotic	11	4	1093	3	me_iotic
mephitic	17	4	714	3	mephitic
meropic	13	3	1026	3	me_ropic
nephritic	16	4	590	3	nephritic
nephrotics	17	4	388	3	nephrotics
neritic	9	13	1433	3	ne_ritic
neuritic	10	4	859	3	neuritic
neuronic	10	4	901	3	neuronic
neurotics	11	4	736	3	neurotics
operatic	12	4	993	3	operatic
parotic	11	25	1804	3	_parotic
peptic	12	21	1315	3	pep__tic
peptonic	14	4	883	3	peptonic
periotic	12	3	1344	3	periotic
petrolic	12	4	969	3	petrolic
photic	13	33	1644	3	__photic
pleuritic	13	4	455	3	pleuritic
ptotic	10	27	1337	3	__ptotic
saprobic	14	4	526	3	saprobic
sclerotic	13	4	575	3	scle_rotic
semiotic	12	7	1063	3	semiotic
septic	10	27	1319	3	sep__tic
tephritic	16	4	530	3	tephritic
unerotic	10	4	919	3	unerotic

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	146162	0.406	440125.6
2	DLD Change Limit	146162	77	7.046	20744.0
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.482	23882.8