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

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

109 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
chirp	12	47	1716	(None)
chimp	14	52	1647	1	chimp
chip	11	67	2642	1	chi_p
chirk	14	45	1618	1	chirk
chirm	12	53	1706	1	chirm
chiro	10	53	2034	1	chiro
chirps	13	54	1400	1	chirps
chirpy	16	49	891	1	chirpy
chirr	10	50	1590	1	chirr
chiru	10	53	1715	1	chiru
caird	8	57	1723	2	caird
cairn	7	57	1751	2	cairn
carp	8	51	3981	2	c_arp
chair	10	55	1963	2	chair_
chairs	11	49	1618	2	chairs
champ	14	50	1796	2	champ
chap	11	49	2849	2	ch_ap
char	9	51	3215	2	char_
chard	11	61	2474	2	chard
chare	10	52	3198	2	chare
chark	14	42	2271	2	chark
charm	12	61	2466	2	charm
charr	10	48	2178	2	charr
chars	10	59	3664	2	chars
chart	10	50	3828	2	chart
chary	13	50	2313	2	chary
cheap	12	69	1594	2	cheap
cheep	12	54	1650	2	cheep
chert	10	52	3210	2	chert
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
chimb	14	48	1356	2	chimb
chime	12	53	2259	2	chime
chimps	15	57	1366	2	chimps
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
chiral	11	46	1441	2	chiral
chirks	15	54	1484	2	chirks
chirms	13	51	1398	2	chirms
chiros	11	46	1777	2	chiros
chirped	15	37	978	2	chirped
chirper	14	35	996	2	chirper
chirre	11	41	1185	2	chirre
chirrs	11	45	1498	2	chirrs
chirrup	14	12	383	2	chirrup
chirus	11	46	1569	2	chirus
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
choir	10	53	1360	2	choir_
choirs	11	49	1188	2	choirs
chomp	14	48	1566	2	chomp
chop	11	60	2492	2	ch_op
chord	11	59	1726	2	chord
chore	10	51	2676	2	chore
chump	14	53	1544	2	chump
churl	10	59	1388	2	churl
churn	10	51	1310	2	churn
churr	10	45	1285	2	churr
cire	6	58	3637	2	c_ire
clip	8	69	2400	2	cli_p
coir	6	63	2724	2	coir_
coirs	7	52	2105	2	coirs
crimp	11	56	1580	2	crimp
crisp	9	50	1462	2	crisp
harp	9	61	3429	2	_harp
hip	8	67	5043	2	_hi_p
hire	7	55	3896	2	_hire
sharp	10	49	2253	2	sharp
ship	9	52	2824	2	shi_p
shire	8	47	2713	2	shire
shirk	12	48	1784	2	shirk
shirr	8	47	1692	2	shirr
shirt	8	45	3390	2	shirt
stirp	7	68	1550	2	stirp
thir	7	64	2054	2	thir_
third	9	59	1249	2	third
thirl	8	54	1682	2	thirl
thorp	10	44	1426	2	thorp
thrip	10	30	1218	2	thrip
twirp	10	46	894	2	twirp
whip	12	55	2184	2	whi_p
whir	10	55	1928	2	whir_
whirl	11	49	1382	2	whirl
whirr	11	46	1119	2	whirr
whirs	11	52	1809	2	whirs

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.096	1861364.6
2	DLD Change Limit	53800	109	1.483	36277.8
3	Display Results	109	109	0.030	3633.3
	(SQL Overall)	178691	109	1.609	111057.2