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

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

63 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
clavier	12	3	917	(None)
claver	11	38	1697	1	clav_er
claviers	13	6	710	1	claviers
clayier	12	4	832	1	clayier
cagier	9	37	1593	2	c_agier
cahier	11	36	1577	2	c_ahier
cakier	12	31	1524	2	c_akier
caver	10	56	2906	2	c_av_er
caviar	11	3	1016	2	c_aviar
cavie	10	46	2159	2	c_avie_
cavies	11	45	2500	2	c_avies
caviler	12	4	906	2	c_aviler
charier	12	43	1790	2	charier
clabber	13	42	1011	2	clabber
clacker	15	38	1377	2	clacker
claimer	11	27	988	2	claimer
clamber	13	33	1174	2	clamber
clammer	13	42	1179	2	clammer
clammier	14	3	584	2	clammier
clamper	13	40	1299	2	clamper
clanger	10	41	1349	2	clanger
clankier	14	32	708	2	clankier
clapper	13	40	1186	2	clapper
claquer	18	28	735	2	claquer
claries	9	34	2220	2	claries
clasher	12	46	1551	2	clasher
clasper	11	38	1186	2	clasper
classer	9	36	1461	2	classer
classier	10	35	908	2	classier
clatter	9	40	1497	2	clatter
clave	10	54	2015	2	clav_e_
clavers	12	43	1490	2	clav_ers
claves	11	50	2006	2	clav_es
clavi	10	49	1292	2	clavi__
clawer	11	45	1278	2	cla_wer
cleaver	12	41	1080	2	cleav_er
clever	11	46	1153	2	clev_er
clover	11	46	1712	2	clov_er
coalier	9	34	1618	2	coalier
craver	11	46	1847	2	crav_er
crazier	18	36	1074	2	crazier
curvier	12	31	1066	2	curvier
flakier	14	39	1020	2	flakier
flamier	12	31	1214	2	flamier
flawier	13	37	873	2	flawier
flaxier	17	33	798	2	flaxier
glacier	10	39	1130	2	glacier
gladier	9	38	1099	2	gladier
glarier	8	41	1221	2	glarier
glazier	17	40	935	2	glazier
heavier	13	42	942	2	heavier
lacier	8	40	2009	2	_lacier
lakier	10	47	1627	2	_lakier
laveer	9	41	1042	2	_laveer
laver	8	50	3179	2	_lav_er
lazier	15	42	1461	2	_lazier
leavier	10	31	999	2	leavier
levier	9	40	1387	2	_levier
livier	9	75	1459	2	_livier
platier	9	37	1629	2	platier
slatier	7	40	1681	2	slatier
slaver	9	44	1961	2	slav_er
wavier	12	46	1308	2	_wavier

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.390	458182.1
2	DLD Change Limit	107671	63	3.406	31612.2
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	3.829	46667.8