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

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

80 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
invocate	13	4	783	(None)
invocated	15	4	620	1	invocated
invocates	14	4	764	1	invocates
advocate	14	4	583	2	advocate
indicate	11	3	1335	2	indicate
innovate	11	4	564	2	innovate
insolate	8	3	1189	2	insolate
intonate	8	3	1092	2	intonate
inviolate	12	4	639	2	inviolate
involute	11	4	547	2	involute
advocated	16	4	464	3	advocated
advocates	15	4	588	3	advocates
allocate	10	4	1102	3	allocate
annotate	8	7	771	3	annotate
colocate	12	3	1344	3	colocate
dislocate	12	8	913	3	dislocate
immolate	12	4	654	3	immolate
incage	9	35	1362	3	in__cage
incase	8	36	1528	3	in__case
inchoate	13	4	767	3	inchoate
incite	8	36	1873	3	in__cite
increate	10	3	1220	3	increate
incubate	12	3	866	3	incubate
incudate	11	3	887	3	incudate
inculcate	13	4	743	3	inculcate
indagate	10	4	719	3	indagate
indicated	13	3	1095	3	indicated
indicates	12	3	1258	3	indicates
indocile	11	4	670	3	indocile
indurate	9	3	1187	3	indurate
inflate	10	3	1231	3	in_flate
infuscate	14	4	433	3	infuscate
ingate	7	30	1824	3	in__gate
ingrate	8	7	1512	3	in_grate
initiate	8	4	1269	3	initiate
inmate	8	29	1736	3	in__mate
innate	6	39	1731	3	in__nate
innovated	13	4	457	3	innovated
innovates	12	4	552	3	innovates
inoculate	11	4	962	3	in_oculate
inosite	7	3	1406	3	in_osite
inscape	11	3	802	3	in_scape
insolated	10	3	971	3	insolated
insolates	9	3	1127	3	insolates
instate	7	16	1648	3	in_state
insulate	8	3	1284	3	insulate
intimate	10	10	1383	3	intimate
intonated	10	4	830	3	intonated
intonates	9	4	1024	3	intonates
intoxicate	19	5	500	3	intoxicate
intricate	11	4	1119	3	intricate
intubate	10	4	753	3	intubate
inundate	9	4	604	3	inundate
invade	10	15	785	3	inv__ade
invected	14	25	888	3	invec_ted
invigorate	14	13	437	3	invigorate
invite	9	37	1503	3	inv__ite
invocating	16	4	633	3	invocating
invocation	15	4	754	3	invocation
invocatory	18	4	416	3	invocatory
invoice	12	13	624	3	invo_ice
invoke	13	3	621	3	invo__ke
involucrate	16	5	193	3	involucrate
involuted	13	5	434	3	involuted
involutes	12	4	510	3	involutes
involve	13	4	509	3	invo_lve
iodate	7	3	1350	3	i__odate
isolate	7	3	1392	3	i_solate
lineolate	9	4	628	3	lineolate
locate	8	39	1984	3	__locate
mislocate	13	10	771	3	mislocate
neonate	7	3	1133	3	_neonate
niobate	9	3	770	3	_niobate
notate	6	32	1786	3	_n_otate
relocate	10	7	1353	3	relocate
unlocated	12	3	838	3	unlocated
unvocal	12	4	523	3	unvoca_l
vacate	11	3	1455	3	__vacate
vindicate	15	4	635	3	vindicate
zincate	18	3	853	3	zin__cate

Search took 8 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.420	425454.8
2	DLD Change Limit	146162	80	7.126	20511.1
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	7.576	23586.5