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

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

79 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
dramatic	13	6	942	(None)
dramatics	14	6	691	1	dramatics
aromatic	12	3	1563	2	aromatic
dalmatic	13	4	868	2	dalmatic
dogmatic	14	4	762	2	dogmatic
dramatise	12	4	731	2	dramatise
dramatist	12	5	842	2	dramatist
dramatize	21	4	789	2	dramatize
drastic	10	3	1087	2	dra_stic
pragmatic	16	4	763	2	pragmatic
traumatic	13	4	668	2	traumatic
undramatic	15	5	446	2	undramatic
acmatic	13	3	1169	3	_acmatic
adiabatic	14	4	351	3	adiabatic
anabatic	12	4	744	3	anabatic
aromatics	13	4	1089	3	aromatics
bregmatic	16	4	406	3	bregmatic
caryatic	15	4	849	3	caryatic
chromatic	18	4	1233	3	chromatic
climatic	14	4	872	3	climatic
comatic	13	18	1693	3	_comatic
dalmatics	14	4	552	3	dalmatics
demotic	12	4	1234	3	d_emotic
diabasic	13	4	509	3	diabasic
diabetic	13	4	654	3	diabetic
dialytic	14	4	680	3	dialytic
diametric	14	4	643	3	diametric
diastatic	12	4	593	3	diastatic
dogmatics	15	4	487	3	dogmatics
draconic	13	4	619	3	draconic
drama	8	51	1741	3	drama___
dramadies	13	4	480	3	dramadies
dramady	14	4	355	3	drama_dy
dramas	9	58	1465	3	drama__s
dramatised	14	5	488	3	dramatised
dramatises	13	5	676	3	dramatises
dramatists	13	6	571	3	dramatists
dramatized	23	4	652	3	dramatized
dramatizes	22	4	735	3	dramatizes
dramaturg	13	5	226	3	dramaturg
dramaturgic	17	5	145	3	dramat~~urg~~ic
drumstick	18	4	232	3	drumstick
dryadic	14	4	362	3	dr_yadic
dynamitic	17	4	356	3	dynamitic
eremitic	12	4	854	3	eremitic
erratic	9	3	1111	3	er_ratic
fanatic	12	6	1069	3	_fanatic
frantic	12	3	1036	3	fra_ntic
gametic	12	3	999	3	_gametic
granitic	11	6	862	3	granitic
haematic	15	13	1021	3	haematic
hematic	14	18	1674	3	_hematic
idiomatic	14	4	602	3	idiomatic
magmatic	15	4	839	3	magmatic
miasmatic	15	4	562	3	miasmatic
nematic	11	17	1399	3	_nematic
neumatic	12	5	852	3	neumatic
nondramatic	16	5	447	3	~~non~~dramatic
osmatic	11	17	998	3	_osmatic
plasmatic	15	4	721	3	plasmatic
practic	13	3	1224	3	pra_ctic
pragmatics	17	4	574	3	pragmatics
prelatic	12	3	1128	3	prelatic
prismatic	15	4	716	3	prismatic
protatic	12	3	1474	3	protatic
ramate	8	39	2168	3	_ramat_e
ramtil	8	3	1102	3	_ram_til
rhematic	15	18	892	3	rhematic
romantic	12	4	923	3	_romantic
sematic	11	17	1687	3	_sematic
shamanic	15	4	656	3	shamanic
somatic	11	19	1646	3	_somatic
stomatic	12	3	1199	3	stomatic
stromatic	13	4	1020	3	stromatic
strumatic	13	4	576	3	strumatic
thematic	15	20	1148	3	thematic
uralitic	10	15	845	3	uralitic
uranitic	10	14	868	3	uranitic
uratic	8	30	1635	3	ur__atic

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.156	1145455.1
2	DLD Change Limit	146162	79	7.466	19577.0
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	7.655	23343.0