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

Here are the results of your fuzzy-string dictionary search for “clavi” 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
clavi	10	49	1292	(None)
clave	10	54	2015	1	clave
bravi	10	47	1575	2	bravi
cadi	7	57	3218	2	c_adi
calami	10	3	1342	2	calami
calve	10	59	1992	2	calve
cave	9	59	4126	2	c_ave
cavie	10	46	2159	2	c_avie
cavil	10	38	1649	2	c_avil
cavy	12	59	2000	2	c_avy
chai	9	59	2990	2	cha_i
clach	12	46	1782	2	clach
clack	13	47	2017	2	clack
clad	7	62	2582	2	cla_d
clade	8	58	2101	2	clade
clads	8	57	2273	2	clads
clag	7	59	2457	2	cla_g
clags	8	56	2112	2	clags
claim	9	56	1691	2	claim
clam	8	63	3229	2	cla_m
clamp	11	55	1765	2	clamp
clams	9	51	2767	2	clams
clan	6	56	3392	2	cla_n
clang	8	60	1931	2	clang
clank	11	47	1952	2	clank
clans	7	50	3101	2	clans
clap	8	64	2904	2	cla_p
claps	9	56	2618	2	claps
clapt	9	80	2717	2	clapt
claro	7	50	1869	2	claro
clary	10	57	1961	2	clary
clash	10	62	1903	2	clash
clasp	9	55	1719	2	clasp
class	7	55	2548	2	class
clast	7	60	3058	2	clast
claver	11	38	1697	2	claver
claves	11	50	2006	2	claves
clavier	12	3	917	2	clavier
clavus	11	34	735	2	clavus
claw	9	56	2434	2	cla_w
claws	10	60	2083	2	claws
clay	9	59	2741	2	cla_y
clays	10	55	2133	2	clays
cleave	11	42	1251	2	cleave
clevis	11	5	896	2	clevis
clivia	11	7	723	2	clivia
clove	10	56	1944	2	clove
coati	7	56	2464	2	coati
crave	10	56	2631	2	crave
flavin	12	3	930	2	flavin
lari	4	58	3915	2	_lari
lati	4	64	3827	2	_lati
lav	6	68	4734	2	_lav_
lava	7	67	2542	2	_lava
lave	7	56	4214	2	_lave
lavs	7	67	3415	2	_lavs
slave	8	42	2403	2	slave

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.093	1921408.6
2	DLD Change Limit	53800	57	1.686	31909.8
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	1.795	99549.3