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

Here are the results of your fuzzy-string dictionary search for “echelle” with Change Limit: [1] [2] [3] [4]

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.

78 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
echelle	12	4	662	(None)
echelles	13	4	667	1	echelles
chelae	11	36	1461	2	_chelae
echelon	12	7	616	2	echelon
achene	11	3	1381	3	ache_ne
achillea	13	4	410	3	achillea
belle	7	58	2783	3	__belle
cadelle	10	3	992	3	cadelle
cell	6	50	3172	3	_c_ell_
cella	7	54	2031	3	_c_ella
cellae	8	49	1593	3	_c_ellae
celled	9	44	2032	3	_c_elled
celli	7	67	1769	3	_c_elli
cello	7	49	1958	3	_c_ello
cells	7	54	2806	3	_c_ells
challa	11	40	1419	3	_challa
challie	12	40	1285	3	_challie
chally	14	43	1429	3	_chally
cheese	11	38	1276	3	_cheese
chegoe	12	3	727	3	_chegoe
chela	10	39	1680	3	_che_la
chelas	11	38	1720	3	_chelas
chelate	12	29	1490	3	_chelate
chenille	13	5	459	3	_chenille
cheque	20	3	666	3	_cheque
chevre	14	31	831	3	_chevre
chicle	13	43	1254	3	_chicle
childe	12	47	1121	3	_childe
chile	10	56	2689	3	_ch_ile
chill	10	56	1987	3	_chill_
chilled	13	33	1093	3	_chilled
chiller	12	41	1218	3	_chiller
chilli	11	43	1277	3	_chilli
chills	11	47	1770	3	_chills
chilly	14	41	1322	3	_chilly
cholla	11	39	1102	3	_cholla
chyle	13	49	1348	3	_ch_yle
creole	8	9	1373	3	_creole
eche	9	75	2028	3	ech___e
eched	11	69	1922	3	eche__d
echeloned	15	4	344	3	echeloned
echelons	13	8	554	3	echelons
eches	10	63	2216	3	eche__s
ekuele	10	3	438	3	ekue_le
ephebe	13	3	606	3	ephe_be
ethene	9	33	1292	3	ethe_ne
excelled	18	12	570	3	excelled
exhale	16	3	687	3	exh_ale
expelled	18	9	588	3	expelled
expellee	17	11	609	3	expellee
expeller	17	10	579	3	expeller
eyehole	13	4	600	3	eyehole
gabelle	10	25	921	3	gabelle
gazelle	17	23	633	3	gazelle
hell	7	56	3789	3	__hell_
helled	10	40	2470	3	__helled
heller	9	33	2251	3	__heller
hello	8	65	2298	3	__hello
hells	8	50	3204	3	__hells
helve	11	50	1809	3	__helve
micelle	11	7	834	3	micelle
morelle	9	12	1080	3	morelle
nacelle	9	3	815	3	nacelle
novelle	10	5	823	3	novelle
ocelli	8	3	684	3	oc_elli
phellem	14	3	583	3	_phellem
roselle	7	3	1024	3	roselle
schedule	14	4	324	3	schedule
scheme	13	7	963	3	sche_me
schiller	13	29	647	3	schiller
schmelze	24	4	315	3	schmelze
selle	5	44	2831	3	__selle
shell	8	44	2412	3	_shell_
shelled	11	38	1509	3	_shelled
sheller	10	35	1589	3	_sheller
shells	9	43	1952	3	_shells
shelly	12	44	1447	3	_shelly
shelve	12	40	1276	3	_shelve

Search took 8 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	134027	0.436	409841.7
2	DLD Change Limit	134027	78	7.266	18445.8
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.732	23110.6