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

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

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.

48 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
dysfunctions	21	5	213	(None)
disfunctions	18	5	452	1	disfunctions
dysfunction	20	5	225	1	dysfunction_
disfunction	17	5	471	2	disfunction_
disjunctions	22	5	407	2	disjunctions
dysfunctional	22	6	180	2	dysfunctional
misfunctions	19	5	371	2	misfunctions
cofunctions	18	4	501	3	_cofunctions
disjunction	21	5	409	3	disjunction_
distinctions	15	5	732	3	distinctions
functions	14	3	774	3	___functions
malfunctions	19	5	266	3	malfunctions
misfunction	18	5	394	3	misfunction_
adjunctions	21	4	314	4	_adjunctions
cofunction	17	4	525	4	_cofunction_
compunctions	20	14	569	4	compunctions
conjunctions	23	4	538	4	conjunctions
deductions	14	6	713	4	d_edu_ctions
defections	16	15	1020	4	d_ef_ections
definitions	15	4	560	4	d_efinitions
deflections	17	18	732	4	d_eflections
designations	14	5	694	4	designations
destinations	13	4	1266	4	destinations
destructions	15	4	725	4	destructions
diffractions	21	5	327	4	diffractions
difunctional	18	12	336	4	d_ifunctional
disaffections	22	5	304	4	disaffections
disjunctives	25	13	287	4	disjunctives
disputations	15	10	617	4	disputations
disruptions	14	12	568	4	disru_ptions
dissections	14	19	826	4	dis_sections
dissentions	12	16	804	4	dissen_tions
distentions	12	17	884	4	disten_tions
distinction	14	4	732	4	distinction_
distractions	15	4	875	4	distractions
disunions	10	5	597	4	dis_un__ions
expunctions	22	4	363	4	_expunctions
function	13	3	784	4	___function_
hyperfunctions	27	6	266	4	hyperfunctions
injunctions	20	4	488	4	_injunctions
inunctions	12	4	675	4	__inunctions
junctions	18	3	594	4	___junctions
malfunction	18	5	280	4	malfunction_
misfunctioned	21	6	171	4	misfunctioned
sanctions	11	3	887	4	__s_anctions
subjunctions	23	5	346	4	subjunctions
suctions	10	30	1290	4	__s_u_ctions
unctions	10	3	973	4	____unctions

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	124790	0.153	1167915.0
2	DLD Change Limit	124790	48	6.143	20314.2
3	Display Results	48	48	0.030	1600.0
	(SQL Overall)	178691	48	6.326	28247.1