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

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

78 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
magmatic	15	4	840	(None)
acmatic	13	3	1170	2	_acmatic
agnatic	10	3	1097	2	_agnatic
dalmatic	13	4	869	2	dalmatic
dogmatic	14	4	763	2	dogmatic
haematic	15	13	1022	2	haematic
magmata	12	3	746	2	magmat_a
magnetic	13	4	923	2	magnetic
mammati	10	39	837	2	mammati_
miasmatic	15	4	563	2	miasmatic
pragmatic	16	4	764	2	pragmatic
agamic	11	31	1056	3	_ag_amic
agaric	9	35	1364	3	_ag_aric
aggadic	12	5	481	3	_aggadic
agravic	13	4	589	3	_agravic
aquatic	18	3	811	3	_aquatic
aromatic	12	3	1564	3	aromatic
astatic	9	5	1419	3	_astatic
aviatic	12	3	924	3	_aviatic
basmati	11	4	823	3	basmati_
basmatis	12	4	734	3	basmatis
bregmatic	16	4	407	3	bregmatic
caryatic	15	4	850	3	caryatic
climatic	14	4	873	3	climatic
comatic	13	18	1694	3	_comatic
dalmatics	14	4	553	3	dalmatics
dogmatics	15	4	488	3	dogmatics
dramatic	13	6	943	3	dramatic
enigmatic	14	4	613	3	enigmatic
fanatic	12	6	1070	3	fa_natic
gametic	12	3	1000	3	ga_metic
haematics	16	15	703	3	haematics
haematin	13	14	889	3	haematin
hagadic	14	4	586	3	hag_adic
haggadic	16	4	307	3	haggadic
hematic	14	18	1675	3	_hematic
imagistic	14	4	511	3	imagistic
judgmatic	22	5	237	3	judgmatic
maenadic	13	4	461	3	maenadic
magic	10	58	1866	3	mag___ic
magma	10	45	1357	3	magma___
magmas	11	55	1250	3	magma__s
magnate	10	5	1270	3	magnat_e
magnates	11	5	1161	3	magnates
magnesic	13	4	575	3	magnesic
magnetics	14	4	716	3	magnetics
magnific	16	5	421	3	magnific
maieutic	12	4	387	3	maieutic
majestic	19	4	491	3	majestic
mammate	10	44	1127	3	mammat_e
mammatus	11	4	423	3	mammatus
mammitis	11	4	559	3	mammitis
mandalic	13	4	780	3	mandalic
manganic	13	4	699	3	manganic
mannitic	12	4	801	3	mannitic
mantic	10	41	2090	3	ma__ntic
margaric	13	4	607	3	margaric
marlitic	12	3	834	3	marlitic
mastic	10	31	1917	3	ma__stic
mastitic	12	4	826	3	mastitic
mathematic	19	4	627	3	mathematic
mimetic	13	3	865	3	m_imetic
nematic	11	17	1400	3	_nematic
neumatic	12	5	853	3	neumatic
osmatic	11	17	999	3	_osmatic
plasmatic	15	4	722	3	plasmatic
pragmatics	17	4	575	3	pragmatics
rhematic	15	18	893	3	rhematic
sabbatic	14	4	532	3	sabbatic
sematic	11	17	1688	3	_sematic
somatic	11	19	1647	3	_somatic
stigmatic	14	4	573	3	stigmatic
stomatic	12	3	1200	3	stomatic
tagmemic	15	4	271	3	tagmemic
thematic	15	20	1149	3	thematic
traumatic	13	4	669	3	traumatic
zeugmatic	23	4	263	3	zeugmatic
zygomatic	26	4	483	3	zygomatic

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.436	409841.7
2	DLD Change Limit	146162	78	7.296	20033.2
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.762	23021.3