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

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

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.

89 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
chief	13	44	1948	(None)
chef	12	51	2562	1	ch_ef
chiefs	14	50	965	1	chiefs
chiel	10	49	1897	1	chiel
thief	11	45	1630	1	thief
achier	11	39	1426	2	achier
brief	10	54	2260	2	brief
cahier	11	36	1577	2	cahier
chafe	13	51	1735	2	chafe
chaff	16	50	1628	2	chaff
cheek	14	51	1571	2	cheek
cheep	12	54	1650	2	cheep
cheer	10	54	2038	2	cheer
chefs	13	62	1466	2	ch_efs
chew	12	66	2213	2	ch_ew
chez	18	45	1902	2	ch_ez
chi	8	62	2865	2	chi__
chia	9	60	2662	2	chi_a
chiao	10	56	1836	2	chiao
chias	10	46	2552	2	chias
chic	11	59	2520	2	chi_c
chica	12	58	1826	2	chica
chicer	13	45	1360	2	chicer
chick	16	54	1913	2	chick
chico	12	42	1825	2	chico
chics	12	39	2094	2	chics
chid	10	66	2640	2	chi_d
chide	11	53	2101	2	chide
chided	13	51	1396	2	chided
chider	12	51	1605	2	chider
chides	12	46	2047	2	chides
chiefer	15	3	686	2	chiefer
chiefly	18	3	410	2	chiefly
chield	12	46	1021	2	chield
chiels	11	51	1593	2	chiels
child	11	45	1622	2	child
chile	10	56	2689	2	chile
chiles	11	54	2530	2	chiles
chili	10	62	1848	2	chili
chill	10	56	1987	2	chill
chimb	14	48	1356	2	chimb
chime	12	53	2259	2	chime
chimed	14	58	1483	2	chimed
chimer	13	55	1720	2	chimer
chimes	13	49	2257	2	chimes
chimp	14	52	1647	2	chimp
chin	9	69	3474	2	chi_n
china	10	50	2248	2	china
chine	10	52	3172	2	chine
chined	12	56	2006	2	chined
chines	11	50	2917	2	chines
chink	14	53	2159	2	chink
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
chip	11	67	2642	2	chi_p
chips	12	57	2125	2	chips
chirk	14	45	1618	2	chirk
chirm	12	53	1706	2	chirm
chiro	10	53	2034	2	chiro
chirp	12	47	1716	2	chirp
chirr	10	50	1590	2	chirr
chiru	10	53	1715	2	chiru
chis	9	59	3331	2	chi_s
chisel	11	21	1194	2	chisel
chit	9	69	3746	2	chi_t
chits	10	54	2457	2	chits
chive	13	51	1762	2	chive
chives	14	43	1759	2	chives
chivy	16	48	1036	2	chivy
chuff	16	48	1249	2	chuff
clef	9	70	2818	2	c_lef
cliff	13	59	1713	2	cliff
coif	9	63	3791	2	coi_f
cried	8	46	2429	2	cried
crier	7	47	2446	2	crier
cries	7	54	3840	2	cries
cuif	9	65	2914	2	cui_f
fief	10	73	3136	2	_fief
grief	9	53	1978	2	grief
hie	6	76	5270	2	_hie_
hied	8	54	3404	2	_hied
hies	7	48	4283	2	_hies
kief	11	71	2841	2	_kief
lief	7	60	3699	2	_lief
shied	9	61	2549	2	shied
shiel	8	110	2377	2	shiel
shier	8	54	2894	2	shier
shies	8	61	3655	2	shies
whiff	17	3	1006	2	whiff

Search took 2 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	53800	0.326	548131.9
2	DLD Change Limit	53800	89	1.453	37026.8
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	1.809	98778.9