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

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

80 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
novels	9	55	1250	(None)
hovels	12	54	1333	1	hovels
navels	9	57	1269	1	navels
noels	5	64	1870	1	no_els
novel	8	56	1599	1	novel_
bevels	11	39	1398	2	bevels
botels	8	48	1580	2	botels
bowels	11	43	1559	2	bowels
covens	11	49	1926	2	covens
covers	11	46	2796	2	covers
coves	10	55	3917	2	cove_s
covets	11	48	1964	2	covets
coveys	14	54	1350	2	coveys
devels	10	43	1390	2	devels
dovens	10	44	1390	2	dovens
doves	9	47	2815	2	dove_s
dowels	10	48	1334	2	dowels
foveas	12	3	862	2	foveas
gavels	10	59	1109	2	gavels
grovels	11	42	781	2	grovels
hosels	9	42	1860	2	hosels
hotels	9	45	1551	2	hotels
hovel	11	50	1768	2	hovel_
hovers	12	43	2025	2	hovers
kevels	13	44	1071	2	kevels
koels	9	46	1390	2	ko_els
levels	9	41	1328	2	levels
losels	6	47	1458	2	losels
lovely	12	33	971	2	lovely
lovers	9	42	2343	2	lovers
loves	8	53	3201	2	love_s
models	9	42	1635	2	models
mohels	11	50	1132	2	mohels
morels	8	48	2001	2	morels
motels	8	36	1689	2	motels
movers	11	51	1719	2	movers
moves	10	61	2842	2	move_s
navel	8	70	1657	2	navel_
naves	8	70	3038	2	nave_s
neves	8	70	2187	2	neve_s
newels	9	37	1082	2	newels
nobles	8	33	1972	2	nobles
nodes	6	46	3349	2	node_s
noel	4	52	2655	2	no_el_
noes	4	58	4539	2	no_e_s
noils	5	50	2433	2	no_ils
nomes	7	49	3312	2	nome_s
nones	5	56	3913	2	none_s
nonets	6	41	1870	2	nonets
nonyls	9	5	785	2	nonyls
nopals	8	49	1402	2	nopals
noses	5	54	3564	2	nose_s
noters	6	40	2100	2	noters
notes	5	50	3458	2	note_s
novas	8	52	1536	2	nov_as
novelise	11	3	795	2	novelise
novelist	11	4	945	2	novelist
novella	10	7	621	2	novella
novellas	11	7	634	2	novellas
novelle	10	5	823	2	novelle
novelly	13	4	651	2	novelly
novelty	13	6	517	2	novelty
novena	9	3	676	2	novena
novenas	10	3	689	2	novenas
ovals	8	54	1339	2	_ovals
ovens	8	62	1745	2	_ovens
overs	8	52	2479	2	_overs
ravels	9	47	1707	2	ravels
revels	9	42	2057	2	revels
rovers	9	54	2352	2	rovers
roves	8	48	3448	2	rove_s
rowels	9	45	1545	2	rowels
shovels	13	37	839	2	shovels
snivels	10	33	690	2	snivels
sorels	6	39	2116	2	sorels
towels	9	43	1464	2	towels
vowels	12	44	1048	2	vowels
wovens	12	44	983	2	wovens
yodels	10	46	1007	2	yodels
yokels	13	48	806	2	yokels

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	80	2.280	36206.6
3	Display Results	80	80	0.016	5000.0
	(SQL Overall)	178691	80	2.639	67711.6