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

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

55 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
device	12	45	1216	(None)
deice	8	43	2003	1	de_ice
devices	13	32	1258	1	devices
devise	10	42	1575	1	devise
devoice	13	34	734	1	devoice
advice	12	10	788	2	advice
ceviche	17	4	414	2	ceviche
crevice	14	3	615	2	crevice
decide	10	41	1687	2	decide
decile	9	46	1921	2	decile
deduce	10	7	925	2	deduce
deface	12	31	1386	2	deface
defile	10	52	1666	2	defile
define	10	47	1814	2	define
dehisce	13	10	427	2	dehisce
deiced	10	42	1448	2	de_iced
deicer	9	41	1441	2	de_icer
deices	9	41	1937	2	de_ices
delict	9	43	2033	2	delict
delime	9	3	1404	2	delime
demic	10	51	1919	2	demic_
demise	9	46	1832	2	demise
depict	11	35	1479	2	depict
deride	8	44	2003	2	deride
derive	10	38	1704	2	derive
desire	7	4	1530	2	desire
detick	13	3	938	2	detick
deuce	8	45	1749	2	de_uce
deviance	14	7	708	2	deviance
deviate	11	3	1271	2	deviate
devil	9	47	1473	2	devi_l
deviled	12	41	1218	2	deviled
devils	10	44	1281	2	devils
devised	12	37	1256	2	devised
devisee	11	38	1271	2	devisee
deviser	11	42	1239	2	deviser
devises	11	41	1676	2	devises
devoiced	15	27	606	2	devoiced
devoices	14	30	741	2	devoices
devote	10	45	1378	2	devote
dexie	13	47	1689	2	dexi_e
dice	7	58	4190	2	d__ice
divide	11	34	1089	2	divide
divine	10	35	1446	2	divine
evict	10	44	1714	2	_evict
evince	11	3	776	2	_evince
evite	8	53	1768	2	_evite
novice	11	3	843	2	novice
revile	9	49	2161	2	revile
revise	9	40	1974	2	revise
revive	12	49	1482	2	revive
revoice	12	31	918	2	revoice
service	12	3	909	2	service
seviche	15	4	511	2	seviche
vice	9	57	3286	2	__vice

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.343	520965.0
2	DLD Change Limit	82551	55	2.546	32423.8
3	Display Results	55	55	0.016	3437.5
	(SQL Overall)	178691	55	2.905	61511.5