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

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

93 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
deiced	10	42	1448	(None)
deice	8	43	2003	1	deice_
deicer	9	41	1441	1	deicer
deices	9	41	1937	1	deices
deuced	10	41	1212	1	deuced
diced	9	58	2468	1	d_iced
ceiled	9	41	1495	2	ceiled
danced	10	53	1525	2	danced
deaired	9	4	1153	2	deaired
deaned	8	46	2045	2	deaned
deaved	11	49	1655	2	deaved
debited	11	33	1162	2	debited
decide	10	41	1687	2	decide
decided	12	43	1242	2	decided
decked	14	52	1762	2	decked
deduced	12	6	668	2	deduced
deed	6	53	4090	2	de__ed
deeded	9	46	1554	2	deeded
deemed	10	47	1306	2	deemed
defaced	14	29	1097	2	defaced
defied	11	50	1638	2	defied
defiled	12	40	1310	2	defiled
defined	12	38	1382	2	defined
dehisced	15	8	368	2	dehisced
deicers	10	36	1273	2	deicers
deicide	11	4	940	2	deicide
deified	12	31	1241	2	deified
deigned	10	3	750	2	deigned
deked	11	57	1853	2	de_ked
deled	7	53	2654	2	de_led
delimed	11	3	1072	2	delimed
delved	11	41	1275	2	delved
demised	11	36	1368	2	demised
demoed	10	37	1344	2	demoed
denied	8	43	1863	2	denied
denimed	11	5	923	2	denimed
denned	8	42	1563	2	denned
dented	8	41	2051	2	dented
depicted	14	3	774	2	depicted
derided	10	29	1425	2	derided
derived	12	39	1276	2	derived
descend	11	24	815	2	descend
desired	9	3	1198	2	desired
deticked	16	3	569	2	deticked
deuce	8	45	1749	2	deuce_
deuces	9	40	1551	2	deuces
device	12	45	1216	2	device_
devices	13	32	1258	2	devices
deviled	12	41	1218	2	deviled
devised	12	37	1256	2	devised
devoiced	15	27	606	2	devoiced
dewed	10	50	2030	2	de_wed
dezinced	21	8	390	2	dezinced
dice	7	58	4190	2	d_ice_
dicer	8	54	2642	2	d_icer
dices	8	64	3424	2	d_ices
dicey	11	48	1933	2	d_icey
dicked	14	49	2086	2	d_icked
died	6	61	3786	2	d_i_ed
dieted	8	31	1549	2	dieted
diked	11	50	2468	2	d_iked
dined	7	64	3199	2	d_ined
disced	10	49	1465	2	disced
dived	10	63	2137	2	d_ived
doiled	8	48	1729	2	doiled
doited	8	50	1663	2	doited
dried	7	53	2138	2	dri_ed
dwined	11	46	1021	2	dwined
edited	8	39	1367	2	edited
educed	10	41	885	2	educed
fenced	12	44	1271	2	fenced
heiled	10	44	1561	2	heiled
heired	10	38	1304	2	heired
iced	7	87	2189	2	__iced
juiced	16	3	651	2	juiced
peaced	11	58	1891	2	peaced
peined	9	49	1884	2	peined
peised	9	48	1768	2	peised
pieced	11	39	1210	2	pieced
priced	11	50	1888	2	priced
reined	7	44	2552	2	reined
reived	10	45	1813	2	reived
riced	8	58	2554	2	_riced
seined	7	40	2306	2	seined
seised	7	42	1812	2	seised
seized	16	43	1365	2	seized
sliced	9	44	1631	2	sliced
spiced	11	52	1831	2	spiced
triced	9	55	1867	2	triced
veiled	10	37	1454	2	veiled
veined	10	44	1391	2	veined
viced	11	51	1818	2	_viced
voiced	12	39	1011	2	voiced

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	93	2.470	33421.5
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	2.843	62853.0