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

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

104 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
child	11	45	1622	(None)
chid	10	66	2640	1	chi_d
chield	12	46	1021	1	chield
childe	12	47	1121	1	childe
chile	10	56	2689	1	chile
chili	10	62	1848	1	chili
chill	10	56	1987	1	chill
ahold	9	47	1425	2	ahold
build	8	44	1335	2	build
caid	7	78	3753	2	cai_d
caird	8	57	1723	2	caird
cauld	8	53	1844	2	cauld
ceil	6	57	2506	2	ceil_
ceiled	9	41	1495	2	ceiled
ceili	7	58	1479	2	ceili
ceils	7	50	1940	2	ceils
chad	10	55	2550	2	ch_ad
chalk	14	48	1460	2	chalk
chard	11	61	2474	2	chard
chela	10	39	1680	2	chela
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
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
chide	11	53	2101	2	chide
chided	13	51	1396	2	chided
chief	13	44	1948	2	chief
chiel	10	49	1897	2	chiel
chields	13	50	748	2	chields
chiels	11	51	1593	2	chiels
childes	13	42	1127	2	childes
childly	16	4	480	2	childly
chiles	11	54	2530	2	chiles
chiliad	13	3	756	2	chiliad
chilis	11	55	1787	2	chilis
chilled	13	33	1093	2	chilled
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
chimla	13	3	759	2	chimla
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
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
chit	9	69	3746	2	chi_t
chits	10	54	2457	2	chits
chive	13	51	1762	2	chive
chivy	16	48	1036	2	chivy
chola	10	47	1803	2	chola
cholo	10	52	1797	2	cholo
chord	11	59	1726	2	chord
chyle	13	49	1348	2	chyle
coil	6	64	3965	2	coil_
coiled	9	51	2394	2	coiled
coils	7	50	3008	2	coils
cold	7	73	3877	2	c_old
could	8	65	1771	2	could
cried	8	46	2428	2	cried
gild	6	55	2651	2	_gild
guild	7	53	1275	2	guild
held	8	53	3040	2	_held
hid	7	62	4838	2	_hi_d
hied	8	54	3404	2	_hied
hila	7	62	2835	2	_hila
hili	7	56	2663	2	_hili
hill	7	64	3949	2	_hill
hilt	7	58	5071	2	_hilt
hind	8	55	2975	2	_hind
hold	8	62	3506	2	_hold
mild	7	53	3085	2	_mild
shied	9	61	2549	2	shied
shield	10	62	1297	2	shield
shill	8	53	2533	2	shill
shily	11	52	2201	2	shily
sild	5	50	3058	2	_sild
thill	8	59	1873	2	thill
third	9	59	1249	2	third
whid	11	54	1887	2	whi_d
while	11	54	1869	2	while
whiled	13	45	1413	2	whiled
wild	8	51	2651	2	_wild

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.310	576422.6
2	DLD Change Limit	53800	104	1.610	33416.1
3	Display Results	104	104	0.016	6500.0
	(SQL Overall)	178691	104	1.936	92299.1