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

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

108 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
chimp	14	52	1647	(None)
champ	14	50	1796	1	champ
chimb	14	48	1356	1	chimb
chime	12	53	2259	1	chime
chimps	15	57	1366	1	chimps
chip	11	67	2642	1	chi_p
chirp	12	47	1716	1	chirp
chomp	14	48	1566	1	chomp
chump	14	53	1544	1	chump
crimp	11	56	1580	1	crimp
blimp	11	56	1294	2	blimp
camp	10	63	3645	2	c_amp
cham	11	55	3231	2	cham_
champs	15	49	1568	2	champs
champy	18	50	961	2	champy
chams	12	60	2850	2	chams
chap	11	49	2849	2	ch_ap
cheap	12	69	1594	2	cheap
cheep	12	54	1650	2	cheep
chemo	12	3	1363	2	chemo
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
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
chief	13	44	1948	2	chief
chiel	10	49	1897	2	chiel
child	11	45	1622	2	child
chile	10	56	2689	2	chile
chili	10	62	1848	2	chili
chill	10	56	1987	2	chill
chimar	13	39	1147	2	chimar
chimbs	15	39	1030	2	chimbs
chimed	14	58	1483	2	chimed
chimer	13	55	1720	2	chimer
chimes	13	49	2257	2	chimes
chimla	13	3	759	2	chimla
chin	9	69	3474	2	chi_n
china	10	50	2248	2	china
chine	10	52	3172	2	chine
chink	14	53	2159	2	chink
chino	10	58	2331	2	chino
chins	10	56	3146	2	chins
chippy	18	43	761	2	chippy
chips	12	57	2125	2	chips
chirk	14	45	1618	2	chirk
chirm	12	53	1706	2	chirm
chirms	13	51	1398	2	chirms
chiro	10	53	2034	2	chiro
chirps	13	54	1400	2	chirps
chirpy	16	49	891	2	chirpy
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
chomps	15	51	1222	2	chomps
chop	11	60	2492	2	ch_op
chum	11	63	1800	2	chum_
chumps	15	43	1382	2	chumps
chums	12	50	1583	2	chums
chyme	15	65	1250	2	chyme
clamp	11	55	1765	2	clamp
climb	11	54	1359	2	climb
clime	9	57	2089	2	clime
clip	8	69	2400	2	cli_p
clomp	11	56	1570	2	clomp
clump	11	55	1745	2	clump
comp	10	67	3125	2	c_omp
cramp	11	51	2069	2	cramp
crime	9	48	2269	2	crime
crimps	12	46	1345	2	crimps
crimpy	15	48	939	2	crimpy
crisp	9	50	1462	2	crisp
crump	11	56	1642	2	crump
gimp	9	61	2404	2	_gimp
hemp	11	57	2562	2	_hemp
him	8	62	4766	2	_him_
hims	9	52	3097	2	_hims
hip	8	67	5043	2	_hi_p
hump	11	62	2872	2	_hump
imp	7	66	2697	2	__imp
jimp	15	56	1846	2	_jimp
limp	8	84	3249	2	_limp
pimp	10	60	2490	2	_pimp
primp	11	56	1592	2	primp
scrimp	12	51	1058	2	scrimp
shim	9	58	2786	2	shim_
shims	10	44	2255	2	shims
ship	9	52	2824	2	shi_p
shrimp	13	47	877	2	shrimp
simp	8	52	2877	2	_simp
skimp	13	54	1132	2	skimp
thump	12	62	1157	2	thump
whim	12	62	2053	2	whim_
whims	13	45	1533	2	whims
whip	12	55	2184	2	whi_p
whomp	15	50	1132	2	whomp
whump	15	49	1004	2	whump
wimp	11	55	2152	2	_wimp

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.296	603685.8
2	DLD Change Limit	53800	108	1.610	33416.1
3	Display Results	108	108	0.016	6750.0
	(SQL Overall)	178691	108	1.922	92971.4