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

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

77 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
decipher	16	4	442	(None)
deciphers	17	4	439	1	deciphers
cipher	13	37	1026	2	__cipher
decider	11	42	1318	2	deci_der
deciphered	19	4	300	2	deciphered
decipherer	18	5	242	2	decipherer
encipher	15	4	413	2	encipher
ciphers	14	37	999	3	__ciphers
cither	11	46	1668	3	__cither
cypher	16	30	659	3	__cypher
decanter	11	25	1079	3	decanter
decayer	13	33	935	3	dec_ayer
deceiver	14	3	623	3	deceiver
decenter	11	24	1216	3	decenter
deciare	10	7	1066	3	deciare_
deciares	11	5	1063	3	deciares
decibel	12	3	599	3	deci_bel
decide	10	41	1687	3	deci_de_
decided	12	43	1242	3	deci_ded
deciders	12	35	1075	3	deci_ders
decides	11	42	1765	3	deci_des
decile	9	46	1921	3	deci_le_
deciles	10	44	1772	3	deci_les
deciliter	12	4	703	3	deciliter
decimeter	14	14	741	3	decimeter
decipherers	19	5	178	3	decipherers
deciphering	20	5	322	3	decipher~~ing~~
decker	13	52	1599	3	dec__ker
declarer	11	4	806	3	declarer
decliner	11	37	1084	3	decliner
decoder	11	37	1229	3	dec_oder
decoupler	14	11	383	3	decoupler
decoyer	13	34	868	3	dec_oyer
decreer	10	26	912	3	dec_reer
decrier	10	27	1355	3	dec_rier
decuple	12	8	536	3	decuple_
decupled	14	9	498	3	decupled
decuples	13	9	528	3	decuples
deeper	9	36	1350	3	de_ep_er
defier	10	51	1865	3	defi__er
defiler	11	39	1188	3	defi_ler
definer	11	44	1377	3	defi_ner
deicer	9	41	1441	3	de_i_cer
deifier	11	30	1312	3	de_ifier
delighter	14	4	558	3	delighter
deliver	11	33	1224	3	deli_ver
demister	11	3	1022	3	demister
denier	7	44	2069	3	deni__er
depicter	13	5	685	3	depicter
derider	9	32	1497	3	deri_der
deringer	10	3	814	3	deringer
deriver	11	42	1391	3	deri_ver
designer	10	3	654	3	designer
desilver	12	28	650	3	desilver
desirer	8	3	1078	3	desi_rer
despiser	11	3	634	3	despiser
detacher	14	3	754	3	detacher
deticker	15	4	528	3	deticker
deviser	11	42	1239	3	devi_ser
dewier	10	40	1346	3	dewi__er
dicier	9	44	1623	3	dici__er
dipper	11	40	1779	3	d__ipper
dither	10	44	1768	3	d__ither
dripper	12	34	923	3	d_ripper
eclipser	12	4	279	3	_eclipser
either	9	45	1742	3	_e_ither
enciphers	16	4	401	3	enciphers
hemipter	15	4	558	3	hemipter
lecher	11	34	1585	3	lec__her
neither	10	3	757	3	ne_ither
periphery	19	4	384	3	periphery
peripter	12	7	875	3	peripter
recipe	10	34	1489	3	recip_e_
recipes	11	33	1446	3	recip_es
reciter	9	41	1726	3	reci_ter
telpher	12	3	556	3	te_lpher
weigher	14	13	634	3	we_igher

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.436	409841.7
2	DLD Change Limit	146162	77	6.423	22756.0
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.889	25938.6