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

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

110 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
vocative	16	3	791	(None)
evocative	17	4	629	1	evocative
locative	13	3	868	1	locative
vocatives	17	4	588	1	vocatives
advocative	19	4	396	2	advocative
coactive	15	9	862	2	coactive
conative	13	12	1462	2	conative
donative	12	13	987	2	donative
locatives	14	4	656	2	locatives
rotative	11	3	1034	2	rotative
violative	15	4	511	2	violative
vocalise	13	15	1081	2	vocalise
vocalize	22	13	1015	2	vocalize
vocation	13	23	1198	2	vocation
vocatively	21	4	447	2	vocatively
volatile	11	4	643	2	volatile
volitive	14	4	689	2	volitive
vomitive	16	4	585	2	vomitive
votive	12	34	893	2	vo__tive
ablative	13	4	824	3	ablative
active	11	3	1374	3	_ac_tive
amative	12	3	1173	3	_amative
avocation	14	16	899	3	avocation
bioactive	16	4	413	3	bioactive
captive	14	3	897	3	__captive
cocaine	11	13	1517	3	coca_ine
combative	18	4	721	3	combative
costive	12	3	1284	3	co_stive
creative	13	28	1280	3	creative
curative	13	3	1040	3	curative
dative	10	3	1181	3	__dative
dilative	12	3	952	3	dilative
donatives	13	14	690	3	donatives
durative	12	3	907	3	durative
educative	15	13	655	3	educative
elative	10	3	1245	3	_elative
enactive	13	3	851	3	enactive
ergative	12	3	897	3	ergative
evacuative	18	4	373	3	evacuative
evocation	14	20	1029	3	evocation
evocatively	22	5	368	3	evocatively
fictive	15	3	702	3	fic_tive
fixative	21	4	508	3	fixative
focalise	13	12	1037	3	focalise
focalize	22	13	950	3	focalize
formative	17	4	796	3	formative
fricative	17	4	674	3	fricative
hortative	15	4	643	3	hortative
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
inactive	13	4	820	3	inactive
laxative	18	4	509	3	laxative
ligative	12	5	880	3	ligative
localise	10	15	1185	3	localise
localite	10	14	1154	3	localite
localize	19	14	1048	3	localize
locate	8	39	1984	3	locat__e
locating	11	3	1150	3	locating
location	10	21	1391	3	location
lucrative	14	4	586	3	lucrative
monitive	13	4	999	3	monitive
motive	11	31	1214	3	mo__tive
mutative	13	4	828	3	mutative
native	9	6	1301	3	__native
negative	12	3	908	3	negative
nonactive	14	4	897	3	nonactive
nonnative	12	4	834	3	nonnative
normative	14	4	889	3	normative
octave	11	15	734	3	_oc_tave
optative	13	4	765	3	optative
placative	16	4	622	3	placative
portative	14	4	937	3	portative
positive	13	4	999	3	positive
precative	16	3	1257	3	precative
proactive	16	4	836	3	proactive
probative	16	4	917	3	probative
provocative	21	5	464	3	~~pro~~vocative
putative	13	4	837	3	putative
reactive	13	3	1047	3	reactive
relative	11	3	1314	3	relative
sanative	11	3	1047	3	sanative
sedative	12	3	885	3	sedative
siccative	16	4	510	3	siccative
sonatine	8	3	1332	3	sonatine
sorptive	13	4	647	3	sorptive
stative	10	26	1293	3	_stative
tractive	13	3	1004	3	tractive
vacate	11	3	1455	3	vacat__e
vacating	14	3	1036	3	vacating
vacation	13	19	1189	3	vacation
vasoactive	18	5	247	3	vasoactive
vegetive	15	4	554	3	vegetive
vibrative	17	4	558	3	vibrative
vocable	14	18	967	3	voca_ble
vocalese	13	16	550	3	vocalese
vocalic	14	4	694	3	vocali_c
vocalics	15	4	559	3	vocalics
vocalised	15	15	739	3	vocalised
vocalises	14	17	1033	3	vocalises
vocalism	15	15	904	3	vocalism
vocalist	13	15	1212	3	vocalist
vocality	16	13	793	3	vocality
vocalized	24	17	881	3	vocalized
vocalizer	23	18	757	3	vocalizer
vocalizes	23	16	1010	3	vocalizes
vocations	14	19	1142	3	vocations
volatiles	12	4	613	3	volatiles
volcanize	23	4	573	3	volcanize
vomitives	17	4	461	3	vomitives
votives	13	33	795	3	vo__tives

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	146162	0.406	440125.6
2	DLD Change Limit	146162	110	7.813	18707.5
3	Display Results	110	110	0.046	2391.3
	(SQL Overall)	178691	110	8.265	21620.2