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

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

39 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
miasmatic	15	4	562	(None)
chiasmatic	19	5	434	2	chiasmatic
diastatic	12	4	593	2	diastatic
magmatic	15	4	839	2	m_agmatic
miasmata	12	4	450	2	miasmat_a
miasmic	13	3	574	2	miasm__ic
plasmatic	15	4	721	2	plasmatic
acmatic	13	3	1169	3	__acmatic
anosmatic	13	4	773	3	anosmatic
astatic	9	5	1419	3	__astatic
basmati	11	4	823	3	_basmati_
basmatis	12	4	734	3	_basmatis
cinematic	15	4	638	3	cinematic
dalmatic	13	4	868	3	_dalmatic
diastasic	12	4	402	3	diastasic
dramatic	13	6	942	3	dra_matic
haematic	15	13	1021	3	_haematic
kinematic	17	4	491	3	kinematic
kismetic	16	4	488	3	ki_smetic
mammati	10	39	837	3	m_ammati_
mastic	10	31	1917	3	m_as__tic
mastitic	12	4	826	3	m_astitic
melismatic	16	5	440	3	melismatic
metasomatic	17	5	395	3	metasomatic
metastatic	14	5	522	3	metastatic
miasma	10	9	756	3	miasma___
miasmal	11	7	674	3	miasma__l
miasmas	11	6	774	3	miasma__s
mimetic	13	3	865	3	mi__metic
mismatch	17	4	394	3	mi_smatch
mismate	11	14	1535	3	mi_smat_e
mismated	13	11	1133	3	mi_smated
mismates	12	11	1456	3	mi_smates
mismating	14	12	1182	3	mi_smating
numismatic	16	5	252	3	numi_smatic
osmatic	11	17	998	3	__osmatic
pragmatic	16	4	763	3	pragmatic
prismatic	15	4	716	3	prismatic
traumatic	13	4	668	3	traumatic

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	148641	0.420	425454.8
2	DLD Change Limit	148641	39	7.003	21225.3
3	Display Results	39	39	0.013	3000.0
	(SQL Overall)	178691	39	7.436	24030.5