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

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

68 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
canoeable	13	4	710	(None)
cancelable	16	4	464	2	cancelable
changeable	18	4	396	2	changeable
danceable	14	4	530	2	danceable
adorable	11	3	877	3	_adorable
atonable	10	3	879	3	_atonable
atoneable	11	4	585	3	_atoneable
avowable	16	3	545	3	_avowable
bankable	16	7	791	3	ban_kable
bannable	12	7	835	3	ban_nable
callable	12	3	1075	3	ca_llable
cancellable	17	5	316	3	cancellable
canoodle	11	4	418	3	cano_odle
cantabile	13	4	689	3	can_tabile
capable	13	3	1336	3	ca__pable
cartable	12	13	1409	3	ca_rtable
cascable	14	15	1062	3	ca_scable
cashable	15	15	979	3	ca_shable
castable	12	16	1397	3	ca_stable
catchable	18	4	571	3	catchable
causable	12	3	997	3	ca_usable
changeably	21	5	299	3	changeably
chantable	16	3	689	3	chan_table
chargeable	18	4	347	3	chargeable
chaseable	16	4	634	3	chaseable
chokeable	20	5	385	3	chokeable
citeable	12	3	841	3	c_iteable
closable	12	16	800	3	c_losable
closeable	13	15	502	3	closeable
codable	12	3	1166	3	c__odable
colorable	13	4	824	3	colorable
condonable	15	4	544	3	condonable
constable	13	3	1100	3	constable
cookable	16	14	797	3	c_ookable
dateable	11	4	944	3	da_teable
denotable	12	3	837	3	denotable
faceable	15	10	849	3	fa_ceable
favorable	17	4	458	3	favorable
fineable	13	18	1033	3	fin_eable
gaugeable	13	4	298	3	gaugeable
handleable	16	4	374	3	handleable
hangable	14	3	821	3	han_gable
hateable	13	3	937	3	ha_teable
honorable	14	4	695	3	honorable
ignorable	12	4	533	3	ignorable
knowable	17	4	504	3	_knowable
lineable	10	18	1108	3	lin_eable
makeable	16	3	725	3	ma_keable
malleable	13	7	607	3	malleable
manageable	15	4	312	3	manageable
mineable	12	16	1105	3	min_eable
nameable	12	3	886	3	na_meable
notable	9	21	1490	3	__notable
parolable	13	4	711	3	parolable
raiseable	11	4	724	3	raiseable
rateable	10	3	1144	3	ra_teable
saleable	10	3	1202	3	sa_leable
sandable	11	16	1282	3	san_dable
saveable	13	3	900	3	sa_veable
scannable	13	4	564	3	scan_nable
takeable	14	3	746	3	ta_keable
tameable	12	3	860	3	ta_meable
tannable	10	3	938	3	tan_nable
tapeable	12	3	882	3	ta_peable
tasteable	11	4	612	3	tasteable
tuneable	10	3	891	3	tun_eable
vaporable	16	4	554	3	vaporable
wadeable	14	3	744	3	wa_deable

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	148641	0.420	425454.8
2	DLD Change Limit	148641	68	6.690	22218.4
3	Display Results	68	68	0.030	2266.7
	(SQL Overall)	178691	68	7.140	25026.8