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

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

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
appositional	16	8	394	(None)
oppositional	16	8	384	1	oppositional
apparitional	16	5	276	2	apparitional
apposition	14	4	659	2	apposition__
appositions	15	4	615	2	apposition_s
depositional	15	5	462	2	depositional
expositional	21	5	394	2	expositional
positional	12	4	790	2	__positional
suppositional	17	6	306	2	suppositional
compositional	19	7	405	3	compositional
dispositional	16	5	374	3	dispositional
opposition	14	4	548	3	opposition__
oppositions	15	7	512	3	opposition_s
ovipositional	18	6	246	3	ovipositional
prepositional	17	5	519	3	prepositional
propositional	17	5	524	3	propositional
acquisitional	24	6	180	4	acquisitional
additional	12	4	464	4	a__dditional
apolitical	14	4	629	4	a_politi_cal
apparition	14	4	458	4	apparition__
apparitions	15	4	407	4	apparition_s
apportion	13	4	700	4	appo_rtion__
apportionable	19	6	220	4	appo_rtionable
apportioned	16	5	345	4	appo_rtioned
apportions	14	4	628	4	appo_rtion_s
appositive	17	4	484	4	appositi__ve
appositively	22	5	276	4	appositively
appositives	18	5	425	4	appositi_ves
aspirational	14	5	500	4	aspirational
associational	15	5	293	4	associational
attritional	11	5	424	4	a_ttritional
avocational	16	4	518	4	a_vocational
coitional	11	4	869	4	__co_itional
deposition	13	10	783	4	deposition__
depositions	14	11	768	4	deposition_s
exposition	19	4	716	4	exposition__
expositions	20	4	684	4	exposition_s
imposition	14	4	653	4	imposition__
impositions	15	4	603	4	imposition_s
malposition	15	5	396	4	malposition__
malpositions	16	5	367	4	malposition_s
oppositionist	17	14	381	4	oppositionist
position	10	9	1219	4	__position__
positionally	17	5	492	4	__positionally
positioned	13	9	600	4	__positioned
positions	11	8	1150	4	__position_s
postpositional	18	6	265	4	postpositional
probational	15	4	708	4	_probational
promotional	15	5	563	4	_promotional
provisional	16	5	546	4	_provisional
repetitional	14	5	372	4	repetitional
reposition	12	10	1014	4	reposition__
repositioned	15	5	422	4	repositioned
repositions	13	11	1016	4	reposition_s
supposition	15	5	520	4	supposition__
suppositions	16	5	489	4	supposition_s
transitional	12	5	622	4	transitional
transpositional	17	11	233	4	transpositional
volitional	13	4	541	4	__volitional

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.406	440125.6
2	DLD Change Limit	124790	59	6.346	19664.4
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	6.782	26347.8