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

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

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.

56 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
dysfunctional	22	6	180	(None)
difunctional	18	12	337	2	d_ifunctional
dysfunction	20	5	225	2	dysfunction__
dysfunctions	21	5	213	2	dysfunction_s
bifunctional	19	13	286	3	_bifunctional
disfunction	17	5	472	3	disfunction__
disfunctions	18	5	452	3	disfunction_s
functional	15	11	667	3	___functional
nonfunctional	18	5	376	3	nonfunctional
conjunctional	24	5	416	4	conjunctional
definitional	16	5	303	4	d_efinitional
disjunction	21	5	409	4	disjunction__
disjunctions	22	5	407	4	disjunction_s
hyperfunctional	28	8	135	4	hyperfunctional
junctional	19	10	536	4	___junctional
misfunction	18	5	394	4	misfunction__
misfunctioned	21	6	171	4	misfunctioned
misfunctions	19	5	371	4	misfunction_s
suctional	11	4	768	4	__s_u_ctional
abstractional	17	5	326	5	abstractional
affectional	19	5	389	5	__affectional
bisectional	15	5	464	5	bis__ectional
cofunction	17	4	525	5	_cofunction__
cofunctions	18	4	501	5	_cofunction_s
declinational	16	5	292	5	declinational
dictional	12	6	861	5	d____ictional
diffusional	18	5	224	5	diffu__sional
directional	14	4	544	5	d__irectional
dispensational	17	6	250	5	dispensational
dispositional	16	5	374	5	dispositional
distinction	14	4	732	5	distinction__
distinctions	15	5	732	5	distinction_s
distortional	13	5	348	5	dis_tortional
factional	14	7	876	5	___f_actional
fictional	14	7	780	5	___f_ictional
fractional	15	4	713	5	___fractional
frictional	15	4	625	5	___frictional
function	13	3	784	5	___function__
functionally	20	5	497	5	___functionally
functionary	19	5	375	5	___functionary
functioned	16	4	399	5	___functioned
functions	14	3	774	5	___function_s
inflectional	17	5	438	5	_inflectional
instructional	15	5	509	5	instructional
malfunction	18	5	280	5	malfunction__
malfunctioned	21	6	134	5	malfunctioned
malfunctions	19	5	266	5	malfunction_s
misfunctioning	22	6	123	5	misfunctioning
multifunctional	22	7	150	5	multifunctional
nonfictional	17	5	485	5	nonf_ictional
postulational	15	5	391	5	postulational
productional	17	9	471	5	produ_ctional
reductional	14	5	459	5	_redu_ctional
reflectional	17	5	399	5	_reflectional
sectional	11	4	942	5	__s__ectional
subnational	13	5	457	5	__subnational

Search took 10 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	124790	0.390	458182.1
2	DLD Change Limit	124790	56	8.876	14059.3
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	9.296	19222.4