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

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

59 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
oppositionists	18	13	286	(None)
oppositionist	17	14	381	1	oppositionist_
oppositions	15	7	512	3	opposition___s
abolitionists	15	13	422	4	_abolitionists
appositions	15	4	615	4	apposition___s
demolitionists	17	6	347	4	demolitionists
operationists	15	5	605	4	o_perationists
opportunists	16	6	188	4	oppo_rt_unists
oppositeness	16	5	343	4	opposit_enes_s
opposition	14	4	548	4	opposition____
oppositional	16	8	384	4	opposition__al
partitionists	15	5	476	4	_partitionists
positivists	16	5	419	4	__positi_vists
abolitionisms	17	15	385	5	_abolitionisms
abolitionist	14	14	513	5	_abolitionist_
abortionists	14	5	499	5	_abo_rtionists
adoptionists	15	5	393	5	_ado_ptionists
appositeness	16	5	327	5	apposit_enes_s
apposition	14	4	659	5	apposition____
appositional	16	8	394	5	apposition__al
associationists	17	18	307	5	associationists
coalitionists	15	8	394	5	_coalitionists
compositions	18	4	625	5	composition___s
contortionists	16	10	336	5	conto_rtionists
cooperationists	19	6	319	5	cooperationists
demolitionist	16	5	451	5	demolitionist_
depositions	14	11	768	5	deposition___s
devolutionists	18	14	441	5	devolutionists
elocutionists	15	5	431	5	_elocutionists
evolutionists	16	14	571	5	_evolutionists
exhibitionists	26	6	251	5	exhibitionists
expositions	20	4	684	5	exposition___s
extortionists	20	7	438	5	exto_rtionists
impositions	15	4	603	5	imposition___s
intuitionists	13	6	389	5	_intuitionists
isolationists	13	8	465	5	_isolationists
nutritionists	13	9	370	5	_nutritionists
operationisms	17	5	509	5	o_perationisms
operationist	14	5	794	5	o_perationist_
opportunisms	18	6	153	5	oppo_rt_unisms
opportunist	15	6	262	5	oppo_rt_unist_
oppositenesses	18	5	420	5	oppositenesses
ovipositions	17	5	356	5	oviposition___s
partitionist	14	5	626	5	_partitionist_
positioning	14	5	455	5	__positioni_ng
positions	11	8	1150	5	__position___s
positivisms	18	5	384	5	__positi_visms
positivist	15	6	568	5	__positi_vist_
positroniums	16	6	183	5	__positroniums
precisionists	17	5	463	5	_precisionists
prohibitionists	22	7	207	5	_prohibitionists
projectionists	25	9	411	5	_projectionists
protectionists	18	10	514	5	_protectionists
repositioning	16	5	367	5	repositioni_ng
repositions	13	11	1016	5	reposition___s
repudiationists	18	21	263	5	repudiationists
revolutionists	17	14	512	5	revolutionists
separationists	16	6	408	5	separationists
suppositions	16	5	489	5	supposition___s

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	95024	0.360	496363.9
2	DLD Change Limit	95024	59	6.140	15476.2
3	Display Results	59	59	0.046	1282.6
	(SQL Overall)	178691	59	6.546	27297.7