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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

113 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
chiel	10	49	1897	(None)
chief	13	44	1947	1	chief
chield	12	46	1021	1	chield
chiels	11	51	1593	1	chiels
chile	10	56	2689	1	chile
chill	10	56	1987	1	chill
chisel	11	21	1194	1	chisel
shiel	8	110	2377	1	shiel
achier	11	39	1426	2	achier
ariel	5	52	2897	2	ariel
cahier	11	36	1577	2	cahier
camel	9	68	2280	2	camel
ceil	6	57	2506	2	cei_l
cel	5	60	4055	2	c__el
chapel	13	49	1137	2	chapel
cheek	14	51	1571	2	cheek
cheep	12	54	1650	2	cheep
cheer	10	54	2038	2	cheer
chef	12	51	2562	2	ch_ef
chela	10	39	1680	2	ch_ela
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	2551	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
chicle	13	43	1254	2	chicle
chicly	16	42	920	2	chicly
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
chiefly	18	3	410	2	chiefly
chiefs	14	50	965	2	chiefs
chields	13	50	748	2	chields
child	11	45	1622	2	child
chiles	11	54	2530	2	chiles
chili	10	62	1848	2	chili
chilli	11	43	1277	2	chilli
chills	11	47	1770	2	chills
chilly	14	41	1322	2	chilly
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
chimla	13	3	759	2	chimla
chimp	14	52	1647	2	chimp
chin	9	69	3474	2	chi_n
china	10	50	2247	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
chiral	11	46	1441	2	chiral
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
chisels	12	21	910	2	chisels
chit	9	69	3746	2	chi_t
chital	11	43	1388	2	chital
chits	10	54	2457	2	chits
chive	13	51	1762	2	chive
chives	14	43	1759	2	chives
chivy	16	48	1036	2	chivy
churl	10	59	1388	2	churl
chyle	13	49	1348	2	chyle
coil	6	64	3965	2	coi_l
creel	7	51	2148	2	creel
cried	8	46	2428	2	cried
crier	7	47	2446	2	crier
cries	7	54	3840	2	cries
cruel	7	48	1590	2	cruel
cupel	9	5	1430	2	cupel
diel	5	90	3460	2	_diel
heel	7	50	3422	2	_heel
heil	7	63	2893	2	_heil
hie	6	76	5270	2	_hie_
hied	8	54	3404	2	_hied
hies	7	48	4283	2	_hies
hill	7	64	3949	2	_hill
oriel	5	49	2042	2	oriel
phial	10	3	1320	2	phial
riel	4	64	3238	2	_riel
shied	9	61	2549	2	shied
shield	10	62	1297	2	shield
shiels	9	54	1892	2	shiels
shier	8	54	2894	2	shier
shies	8	61	3655	2	shies
shill	8	53	2533	2	shill
spiel	7	46	2391	2	spiel
thief	11	45	1629	2	thief
thill	8	59	1873	2	thill
thiol	8	76	1604	2	thiol
thirl	8	54	1682	2	thirl
wheel	11	55	1533	2	wheel
while	11	54	1869	2	while
whirl	11	49	1382	2	whirl

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.110	1624463.6
2	DLD Change Limit	53800	113	1.420	37887.3
3	Display Results	113	113	0.033	3424.2
	(SQL Overall)	178691	113	1.563	114325.7