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

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

56 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
restoratives	15	5	415	(None)
restorative	14	4	694	1	restorative_
restorations	12	4	1095	2	restorations
pejoratives	23	5	350	3	pe_joratives
rectorates	12	4	1036	3	rectorat__es
reiterative	14	4	753	3	reiterative_
resorptive	15	4	476	3	res_orptive_
restoration	11	4	1209	3	restorati_on
restrictives	17	5	508	3	restrictives
restrives	12	3	1066	3	rest_r__ives
decorative	16	4	892	4	de_corative_
detonative	14	4	713	4	de_tonative_
estimative	15	4	648	4	_estimative_
extortive	19	4	514	4	_extor_tive_
extractives	23	5	455	4	_ext_ractives
gestative	13	4	730	4	gest__ative_
meliorative	16	5	515	4	meliorative_
pastorates	12	4	1014	4	pastorat__es
pejorative	22	4	569	4	pe_jorative_
performatives	23	9	268	4	performatives
preparatives	19	5	444	4	pre_paratives
prerogatives	18	5	343	4	pre_rogatives
preservatives	21	5	278	4	preservatives
recitatives	16	4	519	4	re_citatives
rectorate	11	4	1136	4	rectorat__e_
rectories	11	3	1464	4	rector__i_es
reformative	19	4	567	4	re_formative_
reiterates	10	4	1200	4	reiterat__es
reiterations	12	4	1087	4	reiterations
reiteratively	19	5	379	4	reiteratively
relatives	12	3	996	4	re___latives
renovative	16	4	543	4	re_novative_
reparative	15	4	817	4	re_parative_
reprobative	18	5	564	4	reprobative_
resonates	9	4	1240	4	res_onat__es
resorptions	13	4	723	4	res_orptions
respirations	14	4	1030	4	respirations
restates	8	34	2343	4	rest__at__es
restations	10	3	1584	4	rest__ations
restorable	12	4	675	4	restora_ble_
restorals	9	7	807	4	restora___ls
restores	8	52	2299	4	restor____es
restrained	11	4	841	4	rest_ra_ined
restrainer	10	4	697	4	rest_ra_iner
restrainers	11	4	512	4	rest_ra_iners
restrains	9	3	1162	4	rest_ra_i_ns
restraints	10	5	660	4	rest_ra_ints
restretches	16	5	350	4	rest_retches
restrictive	16	4	636	4	restrictive_
restrikes	13	3	941	4	rest_r__ikes
restrive	11	3	1092	4	rest_r__ive_
restriven	12	4	623	4	rest_r__iven
retortions	10	4	914	4	re_tor_tions
retroactive	16	4	582	4	re_troactive_
statives	11	27	1079	4	__st__atives
tentatives	13	4	548	4	tent__atives

Search took 9 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.156	1145455.1
2	DLD Change Limit	124790	56	8.733	14289.5
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	8.919	20034.9