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

Here are the results of your fuzzy-string dictionary search for “medical” with Change Limit: [1] [2] [3]

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.

54 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
medical	12	3	1251	(None)
medial	9	38	1986	1	medi_al
medicals	13	4	936	1	medicals
metical	11	3	1536	1	metical
edictal	10	4	699	2	_edictal
epical	10	4	1339	2	_epical
helical	12	3	1115	2	helical
lexical	16	3	736	2	lexical
magical	12	3	978	2	magical
medal	8	62	2132	2	med__al
media	8	47	2171	2	medi_a_
mediacy	15	3	614	2	mediacy
mediad	10	43	1371	2	medi_ad
mediae	9	42	1741	2	medi_ae
medials	10	39	1473	2	medi_als
median	9	41	1754	2	medi_an
medias	9	36	2078	2	medi_as
medic	10	46	1965	2	medic__
medicable	16	4	750	2	medicable
medicaid	14	4	577	2	medicaid
medically	17	3	1010	2	medically
medicant	13	9	1082	2	medicant
medicare	13	4	748	2	medicare
medicate	13	5	1324	2	medicate
medicinal	14	4	507	2	medicinal
medick	15	40	1013	2	medic_k
medicks	16	36	841	2	medicks
medico	11	37	1116	2	medic_o
medicos	12	33	983	2	medicos
medics	11	41	1535	2	medic_s
medieval	14	4	394	2	medieval
medigap	13	7	462	2	medigap
medina	9	41	1409	2	medina_
medinas	10	34	1146	2	medinas
medivac	15	5	469	2	medivac
medusal	10	3	518	2	medusal
menial	8	42	2303	2	meni_al
meniscal	12	4	618	2	meniscal
mescal	10	41	1348	2	me_scal
mesial	8	48	1808	2	mesi_al
meticals	12	3	1076	2	meticals
metrical	12	3	1158	2	metrical
mezcal	19	36	785	2	me_zcal
mimical	13	3	923	2	mimical
modica	11	3	1006	2	modica_
musical	11	3	955	2	musical
nodical	10	4	986	2	nodical
oedipal	10	4	517	2	oedipal
pedicab	14	4	669	2	pedicab
pedicel	12	3	781	2	pedicel
pedocal	12	3	789	2	pedocal
radical	10	33	1279	2	radical
redial	7	49	2311	2	redi_al
vesical	12	15	981	2	vesical

Search took 5 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	54	3.860	27894.0
3	Display Results	54	54	0.013	4153.8
	(SQL Overall)	178691	54	4.013	44528.0