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

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

70 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
pliancies	13	4	667	(None)
planches	15	31	1186	2	pl_anches
valiancies	15	4	528	2	valiancies
alliances	11	10	709	3	allianc_es
appliances	16	4	397	3	applianc_es
blanches	15	33	1160	3	bl_anches
blatancies	14	4	438	3	blatancies
clinches	15	39	1036	3	cli_nches
compliancies	20	5	348	3	~~com~~pliancies
deviancies	16	4	459	3	deviancies
elegancies	13	4	501	3	elegancies
errancies	11	4	796	3	errancies
fancies	12	40	1878	3	__fancies
fiancees	13	3	510	3	_fiancees
fiances	12	3	1067	3	_fianc_es
flinches	16	35	895	3	fli_nches
flippancies	20	5	176	3	flippancies
fluencies	14	4	593	3	fluencies
glances	10	41	1314	3	gl_anc_es
infancies	14	4	697	3	infancies
lances	8	48	2410	3	_l_anc_es
lanciers	10	30	854	3	_l_anciers
lianes	6	38	1932	3	_lian__es
lindies	8	4	1658	3	_li_ndies
litanies	8	3	1099	3	_litan_ies
lunacies	10	3	801	3	_lunacies
militancies	15	5	422	3	militancies
nancies	9	35	1684	3	__nancies
painches	15	8	891	3	pai_nches
pandies	10	42	2450	3	p__andies
pansies	9	45	2198	3	p__ansies
panties	9	42	3093	3	p__anties
papacies	14	3	948	3	papa_cies
patencies	13	4	917	3	patencies
peccancies	15	4	493	3	peccancies
penances	12	3	1244	3	penanc_es
pinches	14	41	1793	3	p_i_nches
pinkies	13	38	1826	3	p_i_nkies
pinnies	9	33	1844	3	p_i_nnies
piquancies	23	4	323	3	piquancies
piracies	12	3	1264	3	p_iracies
places	10	43	2370	3	pl_a_c_es
plaices	11	4	1114	3	pl_aic_es
planche	14	29	975	3	pl_anche_
planchet	15	25	1196	3	pl_anchet
planchets	16	23	674	3	pl_anchets
planes	8	50	2808	3	pl_an__es
platies	9	37	2254	3	pl_a_ties
pleaches	15	32	1043	3	plea_ches
plenaries	11	4	1038	3	plenaries
plenches	15	31	1062	3	pl_enches
plenties	10	3	1469	3	pl_enties
pliancy	14	3	559	3	plianc__y
pliantness	12	6	364	3	pliantness
pliskies	14	7	597	3	pli_skies
poignancies	16	5	270	3	poignancies
policies	12	24	1566	3	poli__cies
potencies	13	6	930	3	potencies
prances	11	36	1877	3	p_ranc_es
primacies	15	4	845	3	primacies
princes	11	30	1514	3	pri_nc_es
privacies	16	4	680	3	privacies
pudencies	14	4	578	3	pudencies
radiancies	13	4	527	3	radiancies
reliances	11	3	962	3	relianc_es
saliencies	12	4	613	3	saliencies
tenancies	11	4	917	3	tenancies
truancies	11	4	688	3	truancies
vacancies	16	4	549	3	vacancies
valiances	14	8	720	3	valianc_es

Search took 8 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.440	406115.9
2	DLD Change Limit	148641	70	7.233	20550.4
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	7.706	23188.6