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

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

56 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
detectable	15	13	660	(None)
delectable	15	24	738	1	delectable
detestable	13	13	650	1	detestable
deflectable	19	4	380	2	deflectable
delectables	16	14	433	2	delectables
delectably	18	12	568	2	delectably
deletable	12	14	950	2	dele_table
detachable	18	4	461	2	detachable
deterrable	13	4	572	2	deterrable
detestably	16	14	439	2	detestably
ejectable	20	13	657	2	_ejectable
electable	13	14	962	2	_electable
erectable	13	12	1009	2	_erectable
resectable	14	7	812	2	resectable
selectable	14	13	644	2	selectable
undetectable	17	5	457	2	undetectable
affectable	20	4	361	3	affectable
dateable	11	4	944	3	date__able
debatable	14	4	631	3	de_batable
deceivable	18	4	502	3	deceivable
deductible	16	4	320	3	deductible
defendable	17	5	498	3	defendable
deferrable	16	4	485	3	deferrable
delectate	12	4	874	3	delecta_te
delegable	13	13	664	3	dele_gable
denotable	12	3	837	3	de_notable
dependable	16	4	579	3	dependable
depletable	15	4	496	3	depletable
deportable	15	4	565	3	deportable
depreciable	18	5	455	3	depreciable
deputable	14	8	704	3	de_putable
detachably	21	5	321	3	detachably
detective	15	4	810	3	detect_ive
detonable	12	4	762	3	det_onable
detonatable	14	6	249	3	detonatable
enactable	13	3	849	3	_enactable
exactable	20	4	643	3	_exactable
execrable	20	4	623	3	_execrable
executable	21	4	403	3	_executable
expectable	23	4	506	3	expectable
getatable	12	3	595	3	get_atable
gettable	11	17	813	3	get__table
injectable	21	4	700	3	injectable
metastable	14	4	492	3	metastable
nettable	10	16	1024	3	net__table
patentable	14	4	493	3	patentable
pettable	12	17	1071	3	pet__table
repeatable	14	4	760	3	repeatable
resettable	12	5	651	3	resettable
respectable	17	5	504	3	respectable
retractable	15	4	512	3	retractable
testable	10	14	1262	3	__testable
unelectable	15	4	675	3	unelectable
untestable	12	4	882	3	untestable
vegetable	15	4	568	3	vege_table
wettable	13	14	804	3	wet__table

Search took 7 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	140603	0.153	1167915.0
2	DLD Change Limit	140603	56	6.050	23240.2
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	6.233	28668.5