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

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

74 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
coachable	18	4	630	(None)
poachable	18	4	624	1	poachable
cashable	15	15	979	2	c_ashable
catchable	18	4	571	2	catchable
leachable	16	13	644	2	leachable
reachable	16	12	966	2	reachable
teachable	16	13	760	2	teachable
torchable	16	4	553	2	torchable
touchable	16	4	502	2	touchable
actable	11	3	1347	3	__actable
attachable	17	4	319	3	attachable
bleachable	19	4	338	3	bleachable
boardable	14	4	489	3	boardable
boatable	12	16	1026	3	boa_table
callable	12	3	1075	3	c_allable
capable	13	3	1336	3	c_a_pable
cartable	12	13	1409	3	c_artable
cascable	14	15	1062	3	c_ascable
castable	12	16	1397	3	c_astable
causable	12	3	997	3	c_ausable
chantable	16	3	689	3	chantable
chartable	16	3	683	3	chartable
chaseable	16	4	634	3	chaseable
checkable	22	4	474	3	checkable
claimable	15	4	570	3	claimable
classable	13	4	714	3	classable
clickable	19	4	430	3	clickable
coagulable	15	4	332	3	coagulable
coalhole	13	4	509	3	coalh_ole
codable	12	3	1166	3	co__dable
cogitable	14	4	694	3	cogitable
coinable	12	3	1158	3	co_inable
colorable	13	4	824	3	colorable
conchae	14	39	1164	3	concha__e
conchal	14	42	1159	3	concha_l_
constable	13	3	1100	3	constable
cookable	16	14	797	3	co_okable
copyable	17	3	662	3	co_pyable
countable	13	4	885	3	countable
coverable	16	4	910	3	coverable
covetable	16	4	816	3	covetable
crunchable	19	4	251	3	crunchable
crushable	16	4	526	3	crushable
detachable	18	4	461	3	detachable
enactable	13	3	849	3	enactable
exactable	20	4	643	3	exactable
faceable	15	10	849	3	_faceable
foamable	15	3	704	3	foa_mable
forceable	16	4	621	3	forceable
hackable	19	3	747	3	_hackable
hatchable	19	4	479	3	hatchable
loanable	10	3	761	3	loa_nable
locatable	13	4	557	3	locatable
lockable	16	3	695	3	lo_ckable
matchable	18	4	546	3	matchable
mockable	18	4	664	3	mo_ckable
munchable	18	4	494	3	munchable
packable	18	3	863	3	_packable
patchable	18	4	563	3	patchable
peaceable	15	4	825	3	peaceable
placable	14	16	924	3	plac_able
placeable	15	3	691	3	placeable
rockable	16	3	801	3	ro_ckable
searchable	17	4	414	3	searchable
sociable	12	3	950	3	so_ciable
stackable	17	3	599	3	stackable
teachably	19	13	518	3	teachably
traceable	13	3	832	3	traceable
trackable	17	3	674	3	trackable
tractable	13	3	851	3	tractable
unactable	13	3	1005	3	unactable
vocable	14	18	967	3	vo_c_able
washable	16	13	804	3	_washable
watchable	19	4	477	3	watchable

Search took 9 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	74	7.610	19532.3
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	8.063	22161.9