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

Here are the results of your fuzzy-string dictionary search for “durative” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

112 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
durative	12	3	907	(None)
curative	13	3	1040	1	curative
duratives	13	4	622	1	duratives
curatives	14	3	782	2	curatives
dative	10	3	1181	2	d__ative
dilative	12	3	952	2	dilative
donative	12	13	987	2	donative
duration	9	3	1269	2	duration
educative	15	13	655	2	educative
furtive	13	3	717	2	fur_tive
indurative	14	4	728	2	indurative
lucrative	14	4	586	2	lucrative
mutative	13	4	828	2	mutative
purgative	15	4	528	2	purgative
putative	13	4	837	2	putative
ablative	13	4	824	3	ablative
abrasive	13	4	575	3	abrasive
adumbrative	19	6	245	3	adumbrative
amative	12	3	1173	3	_amative
auditive	12	4	716	3	auditive
aurate	6	44	2647	3	aurat__e
causative	14	4	583	3	causative
conative	13	12	1462	3	conative
creative	13	28	1280	3	creative
curarine	10	6	1071	3	curarine
curarize	19	8	885	3	curarize
curate	8	52	2624	3	curat__e
curating	11	3	1429	3	curating
curatively	18	4	573	3	curatively
cursive	12	3	783	3	cur_sive
datives	11	3	1007	3	d__atives
decorative	16	4	892	3	decorative
decretive	15	4	749	3	decretive
denotive	12	3	867	3	denotive
derate	7	45	3123	3	derat__e
derating	10	32	2228	3	derating
derisive	12	4	750	3	derisive
derivative	17	4	668	3	derivative
derive	10	38	1704	3	der__ive
derogative	15	4	698	3	derogative
detractive	16	4	737	3	detractive
deviative	16	4	772	3	deviative
dilutive	12	5	538	3	dilutive
directive	15	5	777	3	directive
donatives	13	14	690	3	donatives
drave	9	52	1927	3	d_ra__ve
drive	9	53	1800	3	d_r__ive
dualize	17	5	976	3	du_alize
ductile	10	4	848	3	du_ctile
durable	10	23	1272	3	dura_ble
durance	10	5	911	3	dura_nce
durations	10	3	1146	3	durations
durrie	7	37	1326	3	dur_ri_e
duvetine	12	4	516	3	duvetine
eductive	14	7	686	3	edu_ctive
elative	10	3	1245	3	_elative
emulative	14	4	745	3	emulative
ergative	12	3	897	3	ergative
eruptive	13	4	579	3	eruptive
exudative	20	4	489	3	exudative
federative	17	4	616	3	federative
figurative	17	4	411	3	figurative
fixative	21	4	508	3	fixative
formative	17	4	796	3	formative
fugitive	15	4	417	3	fugitive
gratine	8	47	1919	3	_gratine
gustative	13	4	568	3	gustative
hortative	15	4	643	3	hortative
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
iterative	12	4	1071	3	iterative
laudative	13	4	475	3	laudative
laxative	18	4	509	3	laxative
ligative	12	5	880	3	ligative
locative	13	3	868	3	locative
narrative	12	4	737	3	narrative
native	9	6	1301	3	__native
negative	12	3	908	3	negative
normative	14	4	889	3	normative
nutritive	12	4	533	3	nutritive
operative	14	11	1055	3	operative
optative	13	4	765	3	optative
portative	14	4	937	3	portative
pulsative	14	5	517	3	pulsative
punitive	13	4	683	3	punitive
purgatives	16	4	374	3	purgatives
quartile	17	4	705	3	quartile
ratine	6	51	3182	3	__ratine
ratite	6	50	2242	3	__ratite
relative	11	3	1314	3	relative
rotative	11	3	1034	3	rotative
ruralise	8	3	964	3	ruralise
ruralite	8	4	896	3	ruralite
ruralize	17	3	923	3	ruralize
sanative	11	3	1047	3	sanative
sedative	12	3	885	3	sedative
sorptive	13	4	647	3	sorptive
stative	10	26	1293	3	_stative
suasive	10	3	785	3	su_asive
summative	16	4	620	3	summative
survive	13	3	593	3	sur_vive
tractive	13	3	1004	3	_tractive
unitive	10	3	1056	3	_unitive
uralite	7	17	1410	3	_uralite
uranide	8	22	1209	3	_uranide
uranite	7	25	1569	3	_uranite
urate	5	54	3216	3	_urat__e
uratic	8	30	1636	3	_urati_c
urinative	12	4	765	3	_urinative
vibrative	17	4	558	3	vibrative
vocative	16	3	791	3	vocative
zaratite	17	4	779	3	zaratite

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	146162	0.436	409841.7
2	DLD Change Limit	146162	112	9.406	15539.2
3	Display Results	112	112	0.063	1777.8
	(SQL Overall)	178691	112	9.905	18040.5