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

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

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.

50 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
devote	10	45	1378	(None)
demote	9	48	1780	1	demote
denote	7	41	1804	1	denote
devoted	12	41	1109	1	devoted
devotee	11	38	1182	1	devotee
devotes	11	37	1375	1	devotes
revote	9	49	1745	1	revote
cenote	8	37	1584	2	cenote
debate	9	44	1919	2	debate
debone	9	37	1478	2	debone
decode	10	44	1474	2	decode
delate	7	38	2775	2	delate
delete	7	36	2070	2	delete
demode	10	40	1346	2	demode
demoted	11	43	1354	2	demoted
demotes	10	47	1767	2	demotes
denoted	9	35	1276	2	denoted
denotes	8	38	1700	2	denotes
depone	9	36	1655	2	depone
depose	9	42	1576	2	depose
depot	8	57	2792	2	depot_
depots	9	47	1634	2	depots
depute	9	45	1230	2	depute
derate	7	45	3123	2	derate
deviate	11	3	1271	2	deviate
device	12	45	1216	2	device
devise	10	42	1575	2	devise
devoice	13	34	734	2	devoice
devoid	11	8	936	2	devoid
devoir	10	7	603	2	devoir
devolve	14	31	606	2	devolve
devon	9	51	1368	2	devo_n
devons	10	45	1225	2	devons
devotees	12	28	628	2	devotees
devour	10	7	670	2	devour
devout	10	7	1299	2	devout
devouter	12	3	551	2	devouter
divot	9	57	2307	2	divot_
divots	10	47	1220	2	divots
dote	5	54	4288	2	d__ote
emote	7	54	2119	2	_emote
evite	8	53	1768	2	_evite
evoke	12	47	885	2	_evoke
gemote	9	46	1302	2	gemote
peyote	11	3	985	2	peyote
remote	8	42	2260	2	remote
revoke	13	52	1624	2	revoke
revoted	11	43	1415	2	revoted
revotes	10	47	1639	2	revotes
vote	7	47	2862	2	__vote

Search took 3 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	82551	0.346	516448.0
2	DLD Change Limit	82551	50	2.483	33246.5
3	Display Results	50	50	0.016	3125.0
	(SQL Overall)	178691	50	2.845	62808.8