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

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

64 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
knave	12	38	946	(None)
knaves	13	43	952	1	knaves
knawe	12	39	788	1	knawe
nave	7	57	3231	1	_nave
agave	9	53	1403	2	agave
ave	6	77	4870	2	__ave
brave	10	49	2550	2	brave
cave	9	59	4126	2	_cave
clave	10	54	2015	2	clave
crave	10	56	2631	2	crave
deave	9	50	2233	2	deave
drave	9	52	1927	2	drave
eave	7	57	3358	2	_eave
enate	5	44	2814	2	enate
fave	10	55	3296	2	_fave
gave	8	46	3405	2	_gave
grave	9	46	2487	2	grave
have	10	61	3707	2	_have
heave	11	45	2181	2	heave
inane	5	28	2034	2	inane
kae	7	67	4454	2	k_a_e
kale	8	65	3375	2	k_ale
kame	10	57	2823	2	k_ame
kane	8	51	3396	2	k_ane
kava	11	58	1970	2	k_ava
keeve	12	45	1212	2	keeve
kinase	10	42	1065	2	kinase
knack	10	43	1104	2	knack
knap	10	58	1540	2	kna_p
knaps	11	55	1117	2	knaps
knar	8	58	1872	2	kna_r
knars	9	44	1611	2	knars
knaur	9	50	825	2	knaur
knavery	17	3	312	2	knavery
knawel	13	41	541	2	knawel
knawes	13	32	839	2	knawes
knee	8	53	2360	2	kn_ee
knife	12	100	1013	2	knife
knives	13	45	855	2	knives
lave	7	56	4214	2	_lave
leave	8	47	2372	2	leave
nabe	6	60	2949	2	_nabe
nae	3	59	5274	2	_na_e
naive	8	51	1621	2	_naive
name	6	56	3741	2	_name
nape	6	52	3080	2	_nape
navel	8	70	1657	2	_navel
naves	8	70	3038	2	_naves
navy	10	75	1863	2	_navy
neve	7	62	2483	2	_neve
pave	9	61	3389	2	_pave
rave	7	55	4209	2	_rave
reave	8	45	2802	2	reave
save	7	57	4136	2	_save
shave	11	44	2589	2	shave
slave	8	42	2403	2	slave
snake	9	48	2111	2	snake
snare	5	44	2998	2	snare
soave	8	42	1905	2	soave
stave	8	53	2499	2	stave
suave	8	35	1987	2	suave
trave	8	52	2303	2	trave
wave	10	52	3473	2	_wave
weave	11	52	1853	2	weave

Search took 2 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	53800	0.106	1685764.2
2	DLD Change Limit	53800	64	1.736	30990.8
3	Display Results	64	64	0.013	4923.1
	(SQL Overall)	178691	64	1.855	96329.4