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

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

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.

63 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
privative	17	18	829	(None)
privatise	14	16	777	1	privatise
privatives	18	18	647	1	privatives
privatize	23	16	704	1	privatize
derivative	17	4	668	2	derivative
fricative	17	4	674	2	fricative
precative	16	3	1257	2	precative
primitive	16	4	639	2	primitive
private	12	15	1326	2	privat__e
privation	14	3	1117	2	privation
privatised	16	13	500	2	privatised
privatises	15	18	741	2	privatises
privatism	16	17	694	2	privatism
privatist	14	22	879	2	privatist
privatively	22	4	508	2	privatively
privatized	25	19	564	2	privatized
privatizes	24	15	681	2	privatizes
probative	16	4	917	2	probative
urinative	12	4	765	2	urinative
agitative	13	4	687	3	agitative
creative	13	28	1280	3	cr_eative
derivatives	18	4	464	3	derivatives
derivatize	23	4	598	3	derivatize
deviative	16	4	773	3	deviative
dilative	12	3	952	3	_dilative
ergative	12	3	897	3	er_gative
fixative	21	4	508	3	_fixative
fricatives	18	4	469	3	fricatives
imitative	14	4	633	3	imitative
irritative	13	4	520	3	irritative
ligative	12	5	880	3	_ligative
motivative	18	4	428	3	motivative
oxidative	20	4	431	3	oxidative
permeative	17	4	852	3	permeative
pervasive	17	4	448	3	pervasive
placative	16	4	622	3	placative
portative	14	4	937	3	portative
predicative	19	4	737	3	predicative
preventive	18	4	754	3	preventive
primate	11	15	1628	3	primat__e
primatial	13	4	810	3	primatial
primitives	17	4	562	3	primitives
pristine	10	3	1350	3	pri_stine
privacies	16	4	680	3	privacies
privateer	14	13	415	3	privateer
privately	17	4	489	3	privately
privater	13	15	853	3	privat_er
privates	13	18	1238	3	privat_es
privatest	14	19	674	3	privatest
privations	15	3	1010	3	privations
privatisms	17	16	596	3	privatisms
privatists	15	17	606	3	privatists
privities	14	3	1204	3	privities
proactive	16	4	836	3	proactive
promotive	16	4	803	3	promotive
provocative	21	5	464	3	provocative
pulsative	14	5	517	3	pulsative
purgative	15	4	528	3	purgative
putative	13	4	837	3	p_utative
relative	11	3	1314	3	_relative
reprivatize	25	5	441	3	reprivatize
rotative	11	3	1034	3	_rotative
trivalve	14	4	394	3	triva_lve

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	148641	0.423	422437.4
2	DLD Change Limit	148641	63	7.716	19264.0
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	8.172	21866.3