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

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

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.

76 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
chicaneries	18	5	391	(None)
chicaners	16	8	536	2	chicaner__s
chanceries	17	4	765	3	ch__anceries
chantries	14	3	1029	3	ch__antries
chicaner	15	8	607	3	chicaner___
chicanery	19	10	305	3	chicaner__y
chicanes	15	5	937	3	chican___es
chiccories	16	4	383	3	chic_cories
chickories	21	4	436	3	chic_kories
chicnesses	17	4	521	3	chic_nesses
chicories	16	8	876	3	chic__ories
chinaberries	19	5	246	3	chinaberries
chivalries	18	4	396	3	chiva_lries
chivaries	17	5	743	3	chiva__ries
shinneries	13	4	571	3	shi_nneries
beaneries	11	3	1090	4	__beaneries
canaries	10	3	1894	4	___canaries
canneries	11	3	1308	4	c__anneries
chancres	15	42	936	4	ch__ancr_es
chandleries	17	4	433	4	chandleries
chanties	13	26	1580	4	ch__an_ties
characteries	19	7	497	4	characteries
charcuteries	19	9	315	4	charcuteries
chiantis	13	4	659	4	chi_an_ti_s
chicalotes	17	16	356	4	chica_lotes
chicane	14	8	955	4	chican___e_
chicaned	16	6	587	4	chican___ed
chicaning	17	4	516	4	chican__ing
chicanos	15	9	599	4	chican___os
chickadees	22	7	230	4	chickade__es
chickarees	21	6	322	4	chic_karees
chickees	19	25	851	4	chic_ke__es
chicness	15	3	559	4	chic_ne__ss
chillnesses	16	4	472	4	chillnesses
chimaeras	16	6	457	4	chima_er_as
chimaeric	18	4	433	4	chima_eri_c
chimaerism	19	5	316	4	chima_erism
chimaerisms	20	5	272	4	chima_erisms
chimeres	15	35	1131	4	chi__mer_es
chinawares	18	5	270	4	chinawar_es
chinoiseries	17	5	216	4	chinoiseries
chiralities	16	4	651	4	chiralities
chivarees	17	4	438	4	chiva__rees
chivaried	18	4	405	4	chiva__ried
choicenesses	19	4	467	4	choicenesses
cicatrices	13	4	349	4	c_ica_trices
cicatrixes	21	4	258	4	c_ica_trixes
cicatrizes	23	4	384	4	c_ica_trizes
cicelies	12	6	975	4	c_ic__elies
cinerins	10	4	1410	4	c_i__nerins
clowneries	15	4	474	4	c_lowneries
commanderies	19	5	338	4	commanderies
comraderies	16	5	397	4	comraderies
creameries	14	4	667	4	c_reameries
crockeries	18	5	711	4	croc_keries
cutcheries	17	4	508	4	cutc_heries
cycleries	16	4	703	4	c_yc_leries
deaneries	10	3	1083	4	__deaneries
fineries	11	24	1674	4	_fi__neries
flaneries	12	4	956	4	__flaneries
henneries	12	4	864	4	_h_enneries
hickories	18	4	531	4	_hic_kories
imageries	12	4	678	4	__imageries
joineries	16	4	810	4	joi__neries
machineries	18	5	379	4	machi__neries
misandries	13	4	506	4	_misandries
philatelies	16	5	327	4	philatelies
pineries	10	24	1908	4	_pi__neries
sceneries	11	4	939	4	__sceneries
spiceries	13	4	931	4	spic__eries
spinneries	12	4	573	4	spi_nneries
thicknesses	20	4	391	4	thicknesses
thieveries	16	4	347	4	thi_everies
trickeries	16	4	714	4	tric_keries
vineries	11	27	1604	4	_vi__neries
wineries	11	23	1653	4	_wi__neries

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.436	409841.7
2	DLD Change Limit	148819	76	9.080	16389.8
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	9.546	18718.9