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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

146 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
affectable	20	4	361	(None)
acceptable	18	4	429	3	acceptable
actable	11	3	1347	3	a___ctable
affable	15	11	740	3	aff___able
affectedly	22	5	215	3	affectedly
affective	20	13	541	3	affect_ive
affirmable	20	4	262	3	affirmable
affixable	24	4	334	3	aff_ixable
affordable	19	4	254	3	affordable
avertable	14	11	734	3	a_vertable
deflectable	19	4	380	3	deflectable
delectable	15	24	738	3	delectable
detectable	15	13	660	3	detectable
effaceable	20	4	226	3	effaceable
ejectable	20	13	657	3	_ejectable
electable	13	14	962	3	_electable
erectable	13	12	1009	3	_erectable
expectable	23	4	506	3	expectable
inflectable	18	4	512	3	inflectable
injectable	21	4	700	3	injectable
resectable	14	7	812	3	resectable
selectable	14	13	644	3	selectable
abatable	12	3	802	4	a__batable
abdicable	16	8	502	4	abdic_able
acceptably	21	5	338	4	acceptably
adaptable	14	4	461	4	a_daptable
adherable	15	4	500	4	adhe_rable
adjustable	20	4	244	4	adjustable
adoptable	14	4	475	4	a_doptable
affably	18	5	518	4	aff___ably
affect	14	4	890	4	affect____
affectability	26	6	385	4	affectability
affectation	19	4	384	4	affectation
affected	17	4	479	4	affect__ed
affecter	16	4	452	4	affect__er
affecters	17	6	393	4	affect_ers
affecting	18	4	523	4	affect_ing
affectingly	23	5	240	4	affectingly
affection	17	4	589	4	affect_ion
affectioned	20	5	245	4	affectioned
affections	18	4	589	4	affections
affectively	25	5	397	4	affectively
affectless	18	4	213	4	affectless
affects	15	3	539	4	affect___s
affordably	22	5	183	4	affordably
aftertaste	13	7	319	4	aftertaste
agitable	11	3	858	4	a__gitable
agreeable	12	4	465	4	agre_eable
alienable	11	4	693	4	alie_nable
allocable	13	4	563	4	alloc_able
allocatable	15	5	196	4	allocatable
alterable	11	4	916	4	alte_rable
amenable	12	3	886	4	a_me_nable
amendable	14	4	605	4	a_mendable
amerciable	16	5	374	4	amerciable
amicable	14	3	843	4	a_mic_able
appealable	16	4	385	4	appealable
appeasable	16	4	459	4	appeasable
appreciable	19	5	384	4	appreciable
ascendable	15	4	398	4	ascendable
assessable	12	4	341	4	assessable
attachable	17	4	319	4	attachable
attemptable	17	5	153	4	attemptable
auditable	12	4	599	4	a_uditable
averrable	14	10	541	4	a_verrable
avertible	14	9	523	4	a_vertible
beatable	12	16	1224	4	__beatable
cheatable	16	4	671	4	_cheatable
checkable	22	4	474	4	_checkable
collectable	17	10	490	4	collectable
connectable	17	4	571	4	connectable
correctable	17	4	523	4	correctable
covetable	16	4	816	4	cove_table
creatable	13	3	956	4	_creatable
defendable	17	5	498	4	defendable
deferrable	16	4	485	4	deferrable
delectables	16	14	433	4	delectables
delectably	18	12	568	4	delectably
deletable	12	14	950	4	dele_table
detestable	13	13	650	4	detestable
eatable	9	17	1760	4	___eatable
effable	15	10	667	4	eff___able
effective	20	7	619	4	effect_ive
effectual	17	5	276	4	effectual_
effectually	22	5	265	4	effectually
effectuate	18	5	258	4	effectuate
enactable	13	3	849	4	_enactable
exactable	20	4	643	4	_exactable
execrable	20	4	623	4	_execrable
executable	21	4	403	4	_executable
expectably	26	5	422	4	expectably
faceable	15	10	849	4	__faceable
feedable	14	3	767	4	__feedable
fellable	13	17	913	4	__fellable
fightable	18	4	437	4	_fightable
fittable	13	3	709	4	__fittable
flickable	20	4	398	4	_flickable
floatable	14	4	498	4	_floatable
forceable	16	4	621	4	_forceable
forfeitable	19	6	278	4	forfeitable
freezable	23	4	509	4	_freezable
getable	10	17	1255	4	__ge_table
gettable	11	17	813	4	__gettable
giftable	14	6	589	4	gif__table
harvestable	19	5	186	4	harvestable
heatable	13	16	1204	4	__heatable
impeccable	20	4	452	4	impeccable
indictable	15	4	749	4	indictable
inferable	14	4	1127	4	infe_rable
inflatable	15	4	600	4	inflatable
injectables	22	5	281	4	injectables
investable	15	4	804	4	investable
lamentable	14	4	420	4	lamentable
liftable	13	7	686	4	lif__table
marketable	18	4	322	4	marke_table
meltable	12	3	1047	4	__meltable
nestable	10	16	1367	4	__nestable
nettable	10	16	1024	4	__nettable
patentable	14	4	493	4	patentable
peccable	16	4	812	4	__peccable
perfectible	20	5	343	4	perfectible
pettable	12	17	1071	4	__pettable
projectable	24	5	290	4	projectable
referable	14	3	962	4	refe_rable
refutable	14	7	786	4	ref_utable
rentable	10	17	1633	4	__rentable
repeatable	14	4	760	4	repeatable
resettable	12	5	651	4	resettable
respectable	17	5	504	4	respectable
restable	10	16	1844	4	__restable
retable	9	18	2040	4	__re_table
spectacle	15	4	408	4	_spectacle
sufferable	18	4	332	4	suffe_rable
targetable	13	8	387	4	targe_table
testable	10	14	1262	4	__testable
timetable	13	4	687	4	time_table
tractable	13	3	851	4	_tractable
trafficable	21	7	200	4	traffic_able
treatable	11	3	932	4	_treatable
unactable	13	3	1005	4	_unactable
unbeatable	14	4	783	4	unbeatable
uneatable	11	3	1169	4	_uneatable
unelectable	15	4	675	4	unelectable
untestable	12	4	882	4	untestable
vegetable	15	4	568	4	vege_table
wettable	13	14	804	4	__wettable

Search took 10 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	161450	0.436	409841.7
2	DLD Change Limit	161450	146	9.360	17248.9
3	Display Results	146	146	0.063	2317.5
	(SQL Overall)	178691	146	9.859	18124.7