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

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

65 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
descriptive	19	5	368	(None)
ascriptive	17	5	383	2	_ascriptive
description	16	4	537	2	description
descriptively	24	7	232	2	descriptively
inscriptive	18	5	384	2	inscriptive
prescriptive	21	5	323	2	prescriptive
deceptive	17	4	685	3	de_c_eptive
decretive	15	4	749	3	de_cr_etive
descriptions	17	5	540	3	descriptions
descriptor	15	5	297	3	descript_or
descriptors	16	5	275	3	descriptors
destructive	17	5	569	3	destructive
disruptive	16	8	423	3	dis_ruptive
nondescriptive	22	6	197	3	~~non~~descriptive
proscriptive	21	5	287	3	proscriptive
resorptive	15	4	476	3	resor_ptive
restrictive	16	4	636	3	restrictive
absorptive	17	5	367	4	absor_ptive
adsorptive	16	5	336	4	adsor_ptive
ascription	14	4	499	4	_ascription
coscripting	18	4	390	4	coscripting
decisive	14	4	663	4	de_c_i_sive
decoctive	17	4	586	4	de_c_octive
decorative	16	4	892	4	de_corative
decrypting	19	4	322	4	de_crypting
decryption	18	4	374	4	de_cryption
definitive	17	4	508	4	defini_tive
deformative	20	4	497	4	deformative
derisive	12	4	750	4	de__ri_sive
derivative	17	4	668	4	de__rivative
describable	18	5	301	4	describable
describe	13	4	624	4	descr___ibe
describing	16	4	507	4	descri_bing
descriptiveness	23	6	227	4	descriptiveness
desiccative	19	5	394	4	desiccative
designative	16	5	433	4	designative
desorption	13	4	622	4	desor_ption
detractive	16	4	737	4	de_tractive
deverbative	20	5	362	4	deverbative
deviative	16	4	773	4	de__viative
discipline	15	5	532	4	disc_ipline
dissipative	17	5	381	4	dis_sipative
distractive	17	4	678	4	distractive
distributive	18	5	372	4	distributive
eruptive	13	4	579	4	_e__ruptive
escritoire	12	5	121	4	_escritoire
exceptive	23	4	568	4	_exc_eptive
excretive	21	4	514	4	_excr_etive
inscription	15	4	495	4	inscription
inscriptively	23	6	248	4	inscriptively
perceptive	19	4	680	4	perc_eptive
prescription	18	14	534	4	prescription
prescriptively	26	12	205	4	prescriptively
receptive	16	4	833	4	re_c_eptive
recreative	15	4	902	4	re_creative
redescription	18	6	274	4	redescription
rescript	12	7	742	4	rescript___
rescripts	13	7	457	4	rescript__s
resistive	12	4	758	4	res__istive
restrictives	17	5	509	4	restrictives
scripting	14	3	747	4	__scripting
scripture	13	4	388	4	__scripture
secretive	14	4	693	4	se_cr_etive
sorptive	13	4	647	4	__sor_ptive
susceptive	17	5	402	4	susc_eptive

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.423	422437.4
2	DLD Change Limit	148819	65	8.530	17446.5
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	8.999	19856.8