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

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

82 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
dynamic	15	4	581	(None)
adynamic	16	4	334	1	adynamic
dynamics	16	4	409	1	dynamics
adynamia	14	4	312	2	adynamia
dyadic	13	3	609	2	dy_adic
dynamical	17	4	389	2	dynamical
dynamism	16	4	373	2	dynamism
dynamist	14	4	534	2	dynamist
dynamite	14	4	481	2	dynamite
dynamitic	17	4	356	2	dynamitic
dynamo	12	7	416	2	dynam_o
dynamos	13	7	385	2	dynamos
dynastic	14	4	585	2	dynastic
syngamic	16	4	424	2	syngamic
undynamic	17	5	191	2	undynamic
adynamias	15	4	319	3	adynamias
agamic	11	31	1056	3	_agamic
agnatic	10	3	1097	3	agnatic
anaemic	11	4	990	3	_anaemic
anemic	10	27	1369	3	_anemic
anomic	10	25	1630	3	_anomic
biodynamic	20	5	222	3	~~bio~~dynamic
byname	13	25	636	3	bynam_e
bynames	14	25	624	3	bynames
ceramic	13	3	982	3	ceramic
cinnamic	14	4	360	3	cinnamic
cyanamid	16	4	422	3	cyanamid
cyanic	13	31	1077	3	cy_anic
cynic	12	47	1242	3	cyn__ic
daric	8	56	2311	3	d__aric
degami	10	27	901	3	degami_
degamis	11	26	844	3	degamis
demic	10	51	1919	3	d__emic
denari	7	109	1735	3	denari_
denarii	8	38	912	3	denarii
dermic	11	45	1191	3	d_ermic
dharmic	15	3	501	3	dharmic
diamin	9	3	1252	3	d_iamin
dibasic	12	4	603	3	dibasic
dineric	10	3	1097	3	dineric
dioramic	13	4	676	3	dioramic
disomic	12	3	876	3	disomic
domic	10	43	1724	3	d__omic
dryadic	14	4	362	3	dryadic
dunam	8	3	1373	3	dunam__
dunams	9	3	783	3	dunam_s
dunitic	10	4	814	3	dunitic
dyadics	14	5	347	3	dy_adics
dynamisms	17	4	337	3	dynamisms
dynamistic	18	5	334	3	dynam~~ist~~ic
dynamists	15	4	409	3	dynamists
dynamited	16	4	291	3	dynamited
dynamiter	15	4	295	3	dynamiter
dynamites	15	4	462	3	dynamites
dynast	10	8	822	3	dyna_st
dynasts	11	5	510	3	dynasts
dynasty	14	6	320	3	dynasty
dynein	10	3	556	3	dyn_ein
dysuric	13	4	452	3	dysuric
enatic	8	3	1756	3	_enatic
fanatic	12	6	1069	3	fanatic
gamic	10	39	1620	3	__gamic
genomic	12	3	792	3	genomic
gnomic	11	24	859	3	_gnomic
gonadic	11	7	721	3	gonadic
gynecic	15	8	435	3	gynecic
keramic	15	3	723	3	keramic
lunatic	9	3	875	3	lunatic
monadic	12	6	888	3	monadic
naric	7	68	2417	3	__naric
oghamic	15	4	404	3	oghamic
potamic	13	3	1085	3	potamic
pyaemic	16	4	587	3	pyaemic
pyemic	15	3	789	3	py_emic
pyramid	15	4	751	3	pyramid
synaptic	15	4	628	3	synaptic
syndic	12	3	730	3	syn_dic
synodic	13	4	736	3	synodic
tonemic	11	3	1017	3	tonemic
tsunamic	12	4	240	3	tsunamic
vanadic	13	3	674	3	vanadic
venatic	12	3	1152	3	venatic

Search took 7 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	134027	0.453	394461.4
2	DLD Change Limit	134027	82	6.440	20811.6
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	6.923	25811.2