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

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

82 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
motivates	14	4	707	(None)
motivate	13	4	769	1	motivate_
motivated	15	4	596	1	motivated
activates	14	4	968	2	activates
estivates	12	10	975	2	estivates
mitigates	12	4	825	2	mitigates
motivator	14	4	510	2	motivator
motivators	15	4	518	2	motivators
motives	12	36	1189	2	motiv__es
motivities	15	4	769	2	motivities
mutilates	11	3	1095	2	mutilates
remotivates	16	4	477	2	remotivates
titivates	12	4	643	2	titivates
activate	13	5	1037	3	activate_
activated	15	6	788	3	activated
aestivates	13	10	736	3	aestivates
bolivares	14	4	472	3	bolivares
captivates	17	4	549	3	captivates
cogitates	12	4	786	3	cogitates
cultivates	15	4	651	3	cultivates
derivates	13	3	1009	3	derivates
dominates	12	3	1174	3	dominates
emotivities	16	4	575	3	emotivities
estimates	11	9	1136	3	estimates
estivate	11	10	1000	3	estivate_
estivated	13	10	832	3	estivated
foliates	11	4	1275	3	foli_ates
intimates	11	10	1331	3	intimates
iodinates	10	4	820	3	iodinates
litigates	10	4	800	3	litigates
loricates	11	3	1012	3	loricates
marinates	11	25	1638	3	marinates
masticates	14	4	984	3	masticates
maturates	11	3	1176	3	maturates
mediates	11	28	1406	3	medi_ates
medicates	14	3	1211	3	medicates
meditates	12	3	981	3	meditates
metates	9	27	2001	3	met__ates
metricates	14	4	912	3	metricates
militates	11	3	1088	3	militates
mitigate	11	4	869	3	mitigate_
mitigated	13	4	708	3	mitigated
moderates	12	7	1075	3	moderates
modistes	11	3	864	3	modi_stes
modulates	12	3	805	3	modulates
motiles	9	33	1743	3	moti__les
motilities	12	4	1058	3	motilities
motivating	16	4	680	3	motivating
motivation	15	4	808	3	motivation
motivations	16	4	709	3	motivations
motivative	18	4	428	3	motivative
motive	11	31	1214	3	motiv__e_
motived	13	35	776	3	motiv__ed
motiveless	15	4	296	3	motiveless
motivity	16	4	622	3	motivit_y
mottes	8	55	2369	3	mot___tes
muriates	10	3	1208	3	muri_ates
mutates	9	22	1579	3	mut__ates
mutilate	10	3	1227	3	mutilate_
mutilated	12	3	945	3	mutilated
nominates	11	3	1105	3	nominates
notates	7	28	1748	3	not__ates
obviates	13	4	515	3	_obviates
opiates	9	3	1214	3	_opi_ates
oxidates	16	3	633	3	_oxidates
patinates	11	38	1469	3	patinates
privates	13	18	1237	3	_privates
remotivate	15	4	483	3	remotivate_
remotivated	17	4	414	3	remotivated
rotates	7	28	1977	3	rot__ates
salivates	12	3	929	3	salivates
satiates	8	3	1463	3	sati_ates
solvates	11	24	967	3	so_lvates
sonicates	11	4	1038	3	sonicates
titivate	11	4	680	3	titivate_
titivated	13	4	544	3	titivated
tittivates	13	5	332	3	tittivates
ultimates	11	4	843	3	ultimates
unmotivated	17	5	351	3	unmotivated
urticates	11	4	889	3	urticates
vitiates	11	23	1143	3	viti_ates
votives	13	33	795	3	votiv__es

Search took 7 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.420	425454.8
2	DLD Change Limit	148641	82	6.533	22752.3
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	6.983	25589.4