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

Here are the results of your fuzzy-string dictionary search for “assortative” 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
assortative	14	7	395	(None)
associative	16	5	385	2	associative
assortatively	19	6	232	2	assortatively
absorptive	17	5	367	3	absor_ptive
adsorptive	16	5	336	3	adsor_ptive
annotative	13	4	503	3	anno_tative
assertive	12	4	647	3	asser__tive
exhortative	24	5	305	3	exhortative
hortative	15	4	643	3	__hortative
portative	14	4	937	3	__portative
abortive	13	4	688	4	a_bor__tive
absolutive	15	5	265	4	abso_lutive
abstractive	18	5	489	4	abstractive
adsorbate	12	4	318	4	adsorbat__e
adversative	18	5	324	4	adversative
advocative	19	4	396	4	advo_cative
affirmative	22	5	309	4	affirmative
agitative	13	4	687	4	a__gitative
alternative	14	5	468	4	alternative
apostatise	12	5	525	4	a_postatise
apostatize	21	6	457	4	a_postatize
arbitrative	16	5	426	4	arbitrative
ascorbate	13	4	446	4	ascorbat__e
ascriptive	17	5	383	4	a_scriptive
aspartate	11	4	484	4	aspartat__e
assaultive	13	5	211	4	ass_aultive
assentation	11	4	618	4	assentation
assentive	12	4	574	4	ass__entive
asseverative	18	5	232	4	asseverative
assimilative	17	6	317	4	assimilative
assistive	12	4	429	4	ass__istive
associate	11	11	602	4	associat__e
associating	14	4	486	4	associating
association	13	4	615	4	association
associatively	21	6	236	4	associatively
assorting	10	3	730	4	assor__ting
assuasive	12	4	262	4	ass__uasive
assumptive	17	5	220	4	ass_umptive
astatine	8	3	1353	4	a_s__tatine
authoritative	19	6	198	4	authoritative
decorative	16	4	892	4	decor_ative
deformative	20	4	497	4	deformative
denotative	14	5	672	4	deno_tative
dissociative	18	13	373	4	dissociative
formative	17	4	796	4	__formative
gestative	13	4	730	4	ges__tative
gustative	13	4	568	4	gus__tative
informative	19	6	515	4	informative
normative	14	4	889	4	__normative
optative	13	4	765	4	___optative
pejorative	22	4	569	4	pejor_ative
reformative	19	4	567	4	reformative
resorptive	15	4	476	4	resor_ptive
restorative	14	4	694	4	restor_ative
rotative	11	3	1034	4	__ro_tative
sorptive	13	4	647	4	__sor_ptive
sportive	13	4	833	4	_spor__tive
sporulative	16	5	374	4	_sporulative
stative	10	26	1293	4	__s__tative

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.156	1145455.1
2	DLD Change Limit	148819	59	9.326	15957.4
3	Display Results	59	59	0.050	1180.0
	(SQL Overall)	178691	59	9.532	18746.4