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

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

51 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
devotionals	15	5	299	(None)
devotional	14	4	467	1	devotional_
devotionally	19	5	372	2	devotionally
devotions	13	5	659	2	devotion__s
demotions	12	5	844	3	demotion__s
devotion	12	5	676	3	devotion___
emotional	11	4	666	3	_emotional_
sectionals	12	4	727	3	se_ctionals
deceptional	16	5	477	4	deceptional_
decisional	13	4	483	4	decisional_
decoctions	15	4	714	4	decoction__s
delations	10	26	1659	4	delation__s
deletions	10	26	1093	4	deletion__s
delusional	11	5	330	4	delusional_
demotion	11	6	907	4	demotion___
denominal	12	4	569	4	denomi_nal_
dentinal	9	3	950	4	de_nti_nal_
depositional	15	5	462	4	depositional_
derivational	16	5	426	4	derivational_
deviations	14	3	1116	4	deviation__s
devisals	12	4	561	4	dev__i_sals
devolutionary	20	6	298	4	devolutionary
devolutions	15	10	626	4	devolution__s
devotedness	16	5	370	4	devotedness
devoting	13	3	882	4	devoti_n__g
dictional	12	6	861	4	d_ictional_
divisional	14	5	395	4	divisional_
ecotonal	10	4	625	4	_ecot_onal_
emotionalism	16	18	575	4	_emotionalism
emotionalist	14	14	687	4	_emotionalist
emotionally	16	5	530	4	_emotionally
emotions	10	6	1028	4	_emotion__s
erosional	9	4	662	4	_erosional_
evasional	12	4	429	4	_evasional_
ideational	11	4	650	4	ide_ational_
irrationals	11	5	473	4	irrationals
meridionals	14	5	198	4	meridionals
motional	10	5	867	4	__motional_
nationals	9	4	886	4	__nationals
negational	11	4	715	4	negational_
notional	8	4	940	4	__notional_
optionals	11	4	534	4	__optionals
ovational	12	4	685	4	_ovational_
rationals	9	4	994	4	__rationals
regionals	10	28	641	4	re__gionals
relational	10	4	771	4	relational_
remotions	11	4	970	4	remotion__s
retinals	8	56	1296	4	re__ti_nals
sectional	11	4	942	4	se_ctional_
serotinal	9	4	721	4	seroti_nal_
unemotional	13	5	349	4	unemotional_

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	148819	0.453	394461.4
2	DLD Change Limit	148819	51	9.046	16451.4
3	Display Results	51	51	0.016	3187.5
	(SQL Overall)	178691	51	9.515	18779.9