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

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

81 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
deicer	9	41	1441	(None)
deice	8	43	2003	1	deice_
deiced	10	42	1448	1	deiced
deicers	10	36	1273	1	deicers
deices	9	41	1937	1	deices
dicer	8	54	2642	1	d_icer
ceiler	8	40	1396	2	ceiler
chicer	13	45	1360	2	chicer
daiker	11	51	1303	2	daiker
dancer	9	48	1761	2	dancer
deader	8	42	2047	2	deader
deafer	10	41	1481	2	deafer
dealer	7	41	2214	2	dealer
dearer	7	48	2280	2	dearer
decern	9	13	1095	2	de_cern
decider	11	42	1318	2	decider
decker	13	52	1599	2	decker
decor	8	47	1757	2	de_cor
deeper	9	36	1350	2	deeper
deer	5	67	3902	2	de__er
defacer	13	28	1036	2	defacer
defer	9	46	1975	2	de_fer
deffer	13	44	1130	2	deffer
defier	10	51	1865	2	defier
defiler	11	39	1188	2	defiler
definer	11	44	1377	2	definer
defter	10	42	1592	2	defter
deifier	11	30	1312	2	deifier
deliver	11	33	1224	2	deliver
delver	10	49	1349	2	delver
denier	7	44	2069	2	denier
denser	7	41	1519	2	denser
depicter	13	5	685	2	depicter
derider	9	32	1497	2	derider
deriver	11	42	1391	2	deriver
desirer	8	3	1078	2	desirer
deter	6	50	2804	2	de_ter
deticker	15	4	528	2	deticker
deuce	8	45	1749	2	deuce_
deuced	10	41	1212	2	deuced
deuces	9	40	1551	2	deuces
device	12	45	1216	2	device_
devices	13	32	1258	2	devices
deviser	11	42	1239	2	deviser
dewier	10	40	1346	2	dewier
dexter	14	38	1089	2	dexter
dice	7	58	4189	2	d_ice_
diced	9	58	2468	2	d_iced
dicers	9	47	2074	2	d_icers
dices	8	64	3424	2	d_ices
dicey	11	48	1933	2	d_icey
dicier	9	44	1623	2	d_icier
dicker	13	45	2140	2	d_icker
dieter	7	35	1677	2	dieter
diker	10	55	2455	2	d_iker
dimer	8	56	2560	2	d_imer
diner	6	56	3290	2	d_iner
direr	6	49	2707	2	d_irer
diver	9	48	2780	2	d_iver
drier	6	44	2396	2	dri_er
driver	10	47	1449	2	driver
duiker	11	41	1059	2	duiker
eider	6	46	2474	2	_eider
fencer	11	46	1353	2	fencer
heifer	12	3	820	2	heifer
juicer	15	3	628	2	juicer
mercer	10	52	1420	2	mercer
nicer	7	46	1829	2	_nicer
piecer	10	52	1308	2	piecer
pricer	10	39	1829	2	pricer
reiver	9	53	1829	2	reiver
ricer	7	47	2661	2	_ricer
seiner	6	46	2248	2	seiner
seiser	6	53	1834	2	seiser
seizer	15	41	1457	2	seizer
slicer	8	41	1760	2	slicer
spicer	10	47	1931	2	spicer
veiler	9	38	1435	2	veiler
veiner	9	45	1475	2	veiner
voicer	11	39	1054	2	voicer
weiner	9	42	1413	2	weiner

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.360	496363.9
2	DLD Change Limit	82551	81	2.376	34743.7
3	Display Results	81	81	0.013	6230.8
	(SQL Overall)	178691	81	2.749	65002.2