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

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

118 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
connectable	17	4	571	(None)
connectible	17	5	525	1	connectible
collectable	17	10	490	2	collectable
contestable	15	4	689	2	contestable
correctable	17	4	523	2	correctable
collectables	18	10	335	3	collectables
collectible	17	10	451	3	collectible
concealable	17	5	505	3	concealable
conceivable	20	5	499	3	conceivable
conceptacle	16	7	436	3	conceptacle
condemnable	18	5	405	3	condemnable
condensable	16	11	539	3	condensable
conductible	18	5	446	3	conductible
conferrable	18	4	582	3	conferrable
confessable	18	5	485	3	confessable
connectedly	19	5	321	3	connectedly
connective	17	4	925	3	connect_ive
constable	13	3	1100	3	co_n_stable
conversable	18	4	635	3	conversable
convertible	18	4	623	3	convertible
countable	13	4	885	3	coun__table
covetable	16	4	816	3	co_ve_table
injectable	21	4	700	3	_injectable
affectable	20	4	361	4	_affectable
cancelable	16	4	464	4	cance_lable
cancellable	17	5	316	4	cancellable
canoeable	13	4	710	4	canoe__able
chantable	16	3	689	4	chan__table
cheatable	16	4	671	4	c__heatable
checkable	22	4	474	4	c__heckable
coachable	18	4	630	4	co__achable
cogitable	14	4	694	4	co__gitable
cognizable	24	4	339	4	cogn_izable
coinable	12	3	1158	4	coin___able
collectibles	18	8	361	4	collectibles
comestible	16	4	542	4	co_mestible
comfortable	20	9	364	4	comfortable
commendable	20	5	434	4	commendable
committable	19	5	349	4	committable
commutable	18	4	534	4	co_mmutable
compactible	21	5	365	4	compactible
compellable	19	5	337	4	compellable
compensable	19	5	519	4	compensable
computable	18	5	572	4	co_mputable
conceivably	23	5	372	4	conceivably
conceptacles	17	7	379	4	conceptacles
condensible	16	13	440	4	condensible
condonable	15	4	544	4	co_ndonable
conductance	15	5	340	4	conductance
confirmable	20	6	418	4	confirmable
confiscable	20	5	367	4	confiscable
confiscatable	22	13	142	4	confiscatable
conformable	20	8	498	4	conformable
conjecture	21	13	474	4	conject_ure
connect	11	35	1574	4	connect____
connected	14	3	875	4	connect__ed
connecter	13	4	905	4	connect__er
connecters	14	4	801	4	connect_ers
connecting	15	3	1038	4	connect_ing
connection	14	4	1053	4	connect_ion
connections	15	4	1070	4	connections
connectively	22	5	518	4	connectively
connectives	18	4	750	4	connectives
connector	13	4	792	4	connect__or
connectors	14	4	818	4	connect_ors
connects	12	30	1056	4	connect___s
consecrate	14	4	843	4	consecra_te
consignable	16	5	428	4	consignable
constables	14	4	673	4	co_n_stables
construable	15	5	478	4	construable
consumable	16	4	556	4	co_nsumable
containable	15	4	620	4	containable
contemptible	20	5	327	4	contemptible
contractible	18	5	466	4	contractible
contrastable	16	5	443	4	contrastable
convective	20	4	911	4	convect_ive
conventicle	18	5	471	4	conventicle
convertibles	19	5	462	4	convertibles
convertibly	21	5	513	4	convertibly
correlatable	16	5	254	4	correlatable
countably	16	4	629	4	coun__tably
coverable	16	4	910	4	co_ve_rable
creatable	13	3	956	4	c__reatable
crunchable	19	4	251	4	crun_chable
deflectable	19	4	380	4	deflectable
delectable	15	24	738	4	_delectable
detectable	15	13	660	4	_detectable
ejectable	20	13	657	4	__ejectable
electable	13	14	962	4	__electable
enactable	13	3	849	4	__enactable
erectable	13	12	1009	4	__erectable
expectable	23	4	506	4	_expectable
forfeitable	19	6	278	4	forfeitable
forgettable	17	5	210	4	forgettable
incontestable	17	6	384	4	incontestable
indictable	15	4	749	4	_indictable
inflectable	18	4	512	4	inflectable
injectables	22	5	281	4	_injectables
investable	15	4	804	4	_investable
mountable	13	4	630	4	moun__table
nestable	10	16	1367	4	___nestable
nettable	10	16	1024	4	___nettable
nonnegotiable	16	6	194	4	nonnegotiable
nonreusable	13	5	471	4	nonreusable
pocketable	20	4	359	4	pocke_table
pointable	13	3	734	4	poin__table
ponderable	15	4	608	4	ponde_rable
projectable	24	5	290	4	projectable
resectable	14	7	812	4	_resectable
respectable	17	5	504	4	respectable
roundtable	13	8	320	4	roun_dtable
selectable	14	13	644	4	_selectable
unactable	13	3	1005	4	__unactable
unbeatable	14	4	783	4	_unbeatable
uncorrectable	19	6	339	4	uncorrectable
uneatable	11	3	1169	4	__uneatable
unelectable	15	4	675	4	unelectable
untestable	12	4	882	4	_untestable

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	148819	0.440	406115.9
2	DLD Change Limit	148819	118	9.343	15928.4
3	Display Results	118	118	0.076	1552.6
	(SQL Overall)	178691	118	9.859	18124.7