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

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

89 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
motivate	13	4	769	(None)
motivated	15	4	596	1	motivated
motivates	14	4	707	1	motivates
activate	13	5	1037	2	activate
estivate	11	10	1000	2	estivate
mitigate	11	4	869	2	mitigate
motivative	18	4	428	2	motivative
motivator	14	4	510	2	motivator
motive	11	31	1214	2	motiv__e
motivity	16	4	622	2	motivity
mutilate	10	3	1227	2	mutilate
remotivate	15	4	483	2	remotivate
titivate	11	4	680	2	titivate
activated	15	6	788	3	activated
activates	14	4	968	3	activates
aestivate	12	12	766	3	aestivate
captivate	16	4	592	3	captivate
cogitate	11	4	855	3	cogitate
corticate	13	4	1076	3	corticate
cultivate	14	4	708	3	cultivate
derivate	12	3	1120	3	derivate
dominate	11	3	1285	3	dominate
emotive	12	3	919	3	emotiv__e
emotivity	17	4	481	3	emotivity
estimate	10	9	1200	3	estimate
estivated	13	10	832	3	estivated
estivates	12	10	975	3	estivates
foliate	10	5	1353	3	foli_ate
intimate	10	10	1383	3	intimate
iodinate	9	4	934	3	iodinate
litigate	9	4	830	3	litigate
loricate	10	3	1066	3	loricate
marinate	10	30	1778	3	marinate
masticate	13	4	1128	3	masticate
maturate	10	3	1262	3	maturate
mediate	10	34	1521	3	medi_ate
medicate	13	5	1324	3	medicate
meditate	11	3	1062	3	meditate
metate	8	27	2053	3	met__ate
metricate	13	4	992	3	metricate
militate	10	3	1167	3	militate
misate	8	12	2269	3	m__isate
mitigated	13	4	708	3	mitigated
mitigates	12	4	825	3	mitigates
moderate	11	7	1099	3	moderate
modiste	10	3	928	3	modi_ste
modulate	11	3	859	3	modulate
moschate	15	4	659	3	moschate
motile	8	38	1834	3	moti__le
motility	13	3	873	3	motility
motivating	16	4	680	3	motivating
motivation	15	4	808	3	motivation
motivators	15	4	518	3	motivators
motived	13	35	776	3	motiv_ed
motives	12	36	1189	3	motiv_es
motivic	14	4	516	3	motiv_ic
motiving	14	3	716	3	motiving
motivities	15	4	769	3	motivities
motte	7	55	2697	3	mot___te
muriate	9	3	1336	3	muri_ate
muricate	12	3	1111	3	muricate
mutate	8	30	1748	3	mut__ate
mutilated	12	3	945	3	mutilated
mutilates	11	3	1095	3	mutilates
nominate	10	3	1247	3	nominate
notate	6	32	1786	3	not__ate
obovate	12	3	546	3	_obovate
obviate	12	3	578	3	_obviate
opiate	8	5	1346	3	_opi_ate
ovate	8	42	1439	3	_o__vate
oxidate	15	3	702	3	_oxidate
patinate	10	30	1631	3	patinate
private	12	15	1326	3	_private
remotivated	17	4	414	3	remotivated
remotivates	16	4	477	3	remotivates
rotate	6	33	2034	3	rot__ate
salivate	11	3	1001	3	salivate
satiate	7	3	1540	3	sati_ate
solvate	10	27	1021	3	so_lvate
sonicate	10	3	1093	3	sonicate
titivated	13	4	544	3	titivated
titivates	12	4	643	3	titivates
tittivate	12	4	340	3	tittivate
ultimate	10	4	920	3	ultimate
unmotivated	17	5	351	3	unmotivated
urticate	10	4	986	3	urticate
vitiate	10	34	1295	3	viti_ate
volvate	13	31	799	3	vo_lvate
votive	12	34	893	3	votiv__e

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.423	422437.4
2	DLD Change Limit	146162	89	7.500	19488.3
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	7.953	22468.4