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

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

66 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
basicity	15	4	631	(None)
ability	12	3	1144	3	_ability
acidity	13	3	859	3	_acidity
agility	11	4	865	3	_agility
aminity	12	3	1051	3	_aminity
anility	10	3	1272	3	_anility
anticity	13	3	1360	3	anticity
aridity	11	5	1011	3	_aridity
avidity	14	3	648	3	_avidity
banality	13	3	876	3	banality
basic	9	62	2052	3	basic___
basically	16	4	803	3	basically
basicities	14	4	686	3	basicities
basics	10	49	1512	3	basic__s
basidia	10	4	761	3	basidi_a
basidial	11	4	562	3	basidial
basidium	13	4	510	3	basidium
basified	14	3	782	3	basified
basifier	13	3	731	3	basifier
basifies	13	3	1049	3	basifies
basify	14	3	751	3	bas__ify
basilary	13	4	506	3	basilary
basilic	11	3	749	3	basili_c
basilica	12	4	435	3	basilica
basilisk	14	4	405	3	basilisk
basinet	9	3	1893	3	basinet_
basinets	10	3	906	3	basinets
bifidity	17	4	370	3	bifidity
biscuity	15	4	376	3	biscuity
bovinity	16	4	502	3	bovinity
caducity	16	4	388	3	caducity
caninity	13	3	806	3	caninity
capacity	17	4	602	3	capacity
causticity	17	5	381	3	causticity
conicity	15	4	1109	3	conicity
cubicity	17	4	603	3	cubicity
elasticity	15	7	538	3	elasticity
facility	16	3	824	3	facility
facticity	19	4	595	3	facticity
felicity	16	4	791	3	felicity
gaseity	11	3	511	3	gas_eity
helicity	16	4	850	3	helicity
ionicity	13	4	882	3	ionicity
lability	13	7	1083	3	lability
latinity	11	3	881	3	latinity
nasality	11	4	665	3	nasality
nativity	14	4	663	3	nativity
passivity	17	4	409	3	passivity
paucity	14	3	582	3	pa_ucity
plasticity	17	6	560	3	plasticity
rabidity	14	4	658	3	rabidity
rapacity	15	4	498	3	rapacity
rapidity	14	4	627	3	rapidity
raucity	12	3	585	3	ra_ucity
rusticity	14	4	596	3	rusticity
sagacity	14	4	524	3	sagacity
salacity	13	4	785	3	salacity
salinity	11	3	889	3	salinity
sapidity	14	4	643	3	sapidity
spasticity	17	5	426	3	spasticity
tonicity	13	4	854	3	tonicity
toxicity	20	4	568	3	toxicity
vagility	15	4	632	3	vagility
validity	15	4	599	3	validity
vapidity	17	4	519	3	vapidity
vastity	13	3	620	3	vas_tity

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	146162	0.406	440125.6
2	DLD Change Limit	146162	66	6.516	22431.2
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	6.955	25692.5