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

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

57 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
cravens	12	40	1012	(None)
craven	11	41	1393	1	craven_
cravers	12	44	1656	1	cravers
craves	11	58	2539	1	crave_s
ravens	9	39	1688	1	_ravens
avens	8	64	1933	2	__avens
bravers	12	47	1552	2	bravers
braves	11	55	2408	2	brave_s
brazens	18	41	871	2	brazens
caravans	13	3	862	2	caravans
caravels	13	3	744	2	caravels
careens	9	45	1470	2	careens
carvels	12	49	1459	2	carvels
carven	11	47	1666	2	carven_
carvers	12	48	1754	2	carvers
carves	11	51	2845	2	carve_s
caverns	12	45	1025	2	c_averns
cavers	11	50	2684	2	c_avers
caves	10	56	3970	2	c_ave_s
clavers	12	43	1490	2	clavers
claves	11	50	2006	2	clave_s
covens	11	49	1926	2	c_ovens
crakes	12	49	2181	2	crake_s
cranes	8	43	3075	2	crane_s
crapes	10	47	2769	2	crape_s
crases	8	55	3231	2	crase_s
craters	9	50	2189	2	craters
crates	8	57	3606	2	crate_s
cratons	9	43	1603	2	cratons
cravats	12	3	740	2	cravats
crave	10	56	2631	2	crave__
craved	12	54	1777	2	crave_d
cravened	14	7	672	2	cravened
cravenly	16	4	466	2	cravenly
craver	11	46	1847	2	crave_r
craving	13	40	1573	2	craving
cravings	14	42	822	2	cravings
crayons	12	43	923	2	crayons
crazes	17	47	2013	2	craze_s
davens	10	46	1291	2	_davens
grabens	10	36	700	2	grabens
gravels	11	36	1114	2	gravels
graven	10	45	1352	2	graven_
gravers	11	45	1527	2	gravers
graves	10	46	2400	2	grave_s
havens	12	45	1404	2	_havens
heavens	13	43	930	2	heavens
krakens	10	3	429	2	krakens
leavens	10	40	930	2	leavens
mavens	11	43	1297	2	_mavens
ravels	9	47	1707	2	_ravels
raven	8	47	2344	2	_raven_
ravers	9	46	2818	2	_ravers
raves	8	54	4197	2	_rave_s
ravins	9	46	2256	2	_ravins
travels	10	47	1129	2	travels
traves	9	42	2274	2	trave_s

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	57	3.030	35535.0
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	3.422	52218.3