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

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

89 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
semantic	12	4	955	(None)
semantics	13	4	682	1	semantics
sematic	11	17	1687	1	sema_tic
geomantic	14	4	598	2	geomantic
hematic	14	18	1674	2	hema_tic
mantic	10	41	2090	2	__mantic
nematic	11	17	1399	2	nema_tic
pedantic	13	4	658	2	pedantic
romantic	12	4	923	2	romantic
semantical	14	4	573	2	semantical
semiotic	12	7	1063	2	semiotic
somatic	11	19	1646	2	soma_tic
sonantic	10	4	827	2	sonantic
acmatic	13	3	1169	3	acma_tic
antic	7	57	2886	3	___antic
cantic	10	39	2054	3	__cantic
comatic	13	18	1693	3	coma_tic
demantoid	13	4	462	3	demantoid
dementia	11	5	782	3	dementia
demonic	12	3	1122	3	demon_ic
demotic	12	4	1234	3	dem_otic
deontic	10	3	888	3	de_ontic
elastic	9	30	1339	3	_elastic
emetic	10	6	1445	3	_em_etic
enatic	8	3	1756	3	_ena_tic
frantic	12	3	1036	3	_frantic
germanic	13	6	750	3	german_ic
gerontic	11	4	796	3	gerontic
gigantic	12	4	430	3	gigantic
haematic	15	13	1021	3	haema_tic
hematics	15	17	1219	3	hema_tics
hematin	12	15	1602	3	hema_tin
hematitic	16	4	719	3	hematitic
hepatic	14	17	1277	3	hepa_tic
lentic	8	35	1574	3	le__ntic
manic	9	46	2944	3	__man_ic
mantid	9	38	2038	3	__mantid
mantis	8	39	2603	3	__mantis
mantric	11	3	1134	3	__mantric
mastic	10	31	1917	3	__mastic
melanic	11	3	1040	3	melan_ic
melanitic	13	4	671	3	melanitic
melanotic	13	4	539	3	melanotic
neumatic	12	5	852	3	neuma_tic
osmatic	11	17	998	3	osma_tic
quantic	18	27	906	3	_quantic
rhematic	15	18	892	3	rhema_tic
romantics	13	4	678	3	romantics
santir	6	3	1525	3	s__antir
satanic	9	3	993	3	satan_ic
scandic	12	3	700	3	s_candic
schematic	18	4	784	3	schema_tic
sciatic	11	9	1017	3	scia_tic
sebacic	13	4	639	3	seba_cic
sebasic	11	4	689	3	seba_sic
secant	8	40	2329	3	secant__
secantly	13	4	598	3	secantly
secants	9	34	1389	3	secant_s
sejant	13	31	1448	3	sejant__
selenic	9	4	1066	3	selen_ic
selenitic	11	5	691	3	selenitic
semanteme	13	4	288	3	semanteme
semanticist	15	6	532	3	semantic~~ist~~
semeiotic	13	6	465	3	semeiotic
sememic	13	3	650	3	sem_emic
semiotics	13	7	691	3	semiotics
senti	5	62	2670	3	se__nti_
septic	10	27	1319	3	se__ptic
seraphic	15	4	663	3	seraphic
sermonic	12	4	888	3	sermon_ic
shamanic	15	4	656	3	shaman_ic
shanti	9	40	1409	3	s_hanti_
shantih	13	30	964	3	s_hantih
shantis	10	33	1310	3	s_hantis
smalti	8	41	1119	3	s_malti_
smartie	9	3	1017	3	s_martie
smectic	13	3	661	3	s_mectic
somitic	11	15	1263	3	som_itic
spastic	11	3	1038	3	s_pastic
spermatic	15	4	871	3	sperma_tic
stannic	9	3	666	3	s_tannic
static	8	31	1868	3	s_ta_tic
stemmatic	15	4	601	3	stemmatic
stomatic	12	3	1199	3	stoma_tic
strontic	10	4	810	3	strontic
synaptic	15	4	628	3	synaptic
tetanic	9	8	1013	3	tetan_ic
thematic	15	20	1148	3	thema_tic
venatic	12	3	1152	3	vena_tic

Search took 9 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.453	394461.4
2	DLD Change Limit	146162	89	8.220	17781.3
3	Display Results	89	89	0.046	1934.8
	(SQL Overall)	178691	89	8.719	20494.4