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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
stomatic	12	3	1200	(None)
somatic	11	19	1647	1	s_omatic
stromatic	13	4	1021	1	stromatic
aromatic	12	3	1564	2	aromatic
asthmatic	16	4	758	2	asthmatic
automatic	13	4	1039	2	automatic
comatic	13	18	1694	2	_comatic
sematic	11	17	1688	2	s_ematic
somitic	11	15	1263	2	s_omitic
static	8	31	1868	2	st__atic
stemmatic	15	4	601	2	stemmatic
stigmatic	14	4	573	2	stigmatic
stomachic	18	5	392	2	stomachic
stomata	9	3	853	2	stomat_a
stomatal	10	4	583	2	stomatal
stomate	9	3	1312	2	stomat_e
stomates	10	3	1334	2	stomates
strumatic	13	4	577	2	strumatic
acmatic	13	3	1170	3	_acmatic
anosmatic	13	4	773	3	anosmatic
aromatics	13	4	1090	3	aromatics
astatic	9	5	1419	3	ast__atic
asthmatics	17	4	533	3	asthmatics
astigmatic	15	4	485	3	astigmatic
astomatal	11	4	498	3	astomatal
atomic	10	41	1560	3	atom__ic
atomistic	13	4	777	3	atomistic
automatics	14	4	778	3	automatics
axiomatic	20	4	699	3	axiomatic
chromatic	18	4	1234	3	chromatic
climatic	14	4	873	3	climatic
comatik	15	13	972	3	_comatik
cometic	13	12	1572	3	_cometic
dalmatic	13	4	869	3	dalmatic
dogmatic	14	4	763	3	dogmatic
dramatic	13	6	943	3	dramatic
geomantic	14	4	598	3	geomantic
haematic	15	13	1022	3	haematic
hematic	14	18	1675	3	_hematic
idiomatic	14	4	603	3	idiomatic
komatik	12	13	520	3	_komatik
magmatic	15	4	840	3	magmatic
nematic	11	17	1400	3	_nematic
neumatic	12	5	853	3	neumatic
nomadic	12	4	803	3	_nomadic
onomastic	13	4	681	3	onomastic
osmatic	11	17	999	3	_osmatic
ostomate	10	4	957	3	ostomat_e
ostomates	11	4	934	3	ostomates
protatic	12	3	1475	3	protatic
psoatic	11	3	930	3	pso_atic
ptomain	11	4	696	3	ptoma_in
ptomainic	15	4	310	3	ptomainic
ptotic	10	27	1337	3	pto__tic
rhematic	15	18	893	3	rhematic
romantic	12	4	924	3	_romantic
sabbatic	14	4	532	3	sabbatic
schematic	18	4	784	3	schematic
sciatic	11	9	1017	3	s_ciatic
semantic	12	4	955	3	s_emantic
shamanic	15	4	657	3	shamanic
sodomitic	14	4	545	3	sodomitic
solatia	7	3	1225	3	s_olatia
somata	8	3	1238	3	s_omat_a
sonantic	10	4	827	3	s_onantic
soritic	9	14	1443	3	s_oritic
spermatic	15	4	871	3	spermatic
sporadic	13	4	505	3	sporadic
statice	9	26	1403	3	st__atice
statics	9	33	1453	3	st__atics
statin	6	39	2147	3	st__atin
stearic	9	3	942	3	st_earic
stenotic	10	4	808	3	stenotic
stigmatics	15	4	394	3	stigmatics
stoai	5	54	1787	3	sto_a_i_
stoat	5	71	3595	3	sto_at__
stoats	6	51	1748	3	sto_at_s
stochastic	17	5	405	3	stochastic
stoic	7	3	1725	3	sto___ic
stolonic	10	4	758	3	stolonic
stoma	7	59	1827	3	stoma___
stomach	14	3	603	3	stoma_ch
stomachics	19	5	307	3	stomachics
stomachs	15	4	495	3	stomachs
stomachy	18	4	382	3	stomachy
stomal	8	52	1331	3	stoma__l
stomas	8	48	1632	3	stoma__s
stomatitis	12	5	475	3	stomatitis
stomatous	11	4	607	3	stomatous
stotin	6	32	1506	3	sto__tin
strati	6	35	1890	3	st_rati_
stromata	10	4	759	3	stromat_a
strontic	10	4	812	3	strontic
stylitic	13	5	634	3	stylitic
styptic	14	4	545	3	st_yptic
sylvatic	16	4	535	3	sylvatic
symptomatic	22	5	423	3	s~~ymp~~tomatic
systematic	17	5	528	3	systematic
thematic	15	20	1149	3	thematic
tomato	8	3	1345	3	_tomat_o
tomtit	8	4	1385	3	_tom_tit
tonetic	9	3	1343	3	_tonetic
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	103	7.406	19735.6
3	Display Results	103	103	0.046	2239.1
	(SQL Overall)	178691	103	7.888	22653.5