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

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

151 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
chard	11	61	2474	(None)
card	7	102	4587	1	c_ard
chad	10	55	2550	1	cha_d
char	9	51	3215	1	char_
chards	12	51	1973	1	chards
chare	10	52	3198	1	chare
chared	12	54	2369	1	chared
chark	14	42	2271	1	chark
charm	12	61	2466	1	charm
charr	10	48	2178	1	charr
chars	10	59	3664	1	chars
chart	10	50	3828	1	chart
chary	13	50	2313	1	chary
chord	11	59	1726	1	chord
echard	12	4	922	1	echard
hard	8	54	4350	1	_hard
shard	9	61	2596	1	shard
award	9	71	1804	2	award
bard	7	56	4886	2	_bard
beard	8	60	2496	2	beard
board	8	55	2300	2	board
cad	6	74	5636	2	c_a_d
caid	7	78	3753	2	c_aid
caird	8	57	1723	2	caird
canard	9	3	1476	2	canard
car	5	91	6556	2	c_ar_
carb	8	51	4316	2	c_arb
cards	8	51	3793	2	c_ards
care	6	69	6837	2	c_are
cared	8	60	5009	2	c_ared
cark	10	55	3927	2	c_ark
carl	6	51	4478	2	c_arl
carn	6	62	4543	2	c_arn
carp	8	51	3981	2	c_arp
carr	6	54	3470	2	c_arr
cars	6	73	6476	2	c_ars
cart	6	65	7034	2	c_art
chadri	12	3	814	2	chadri
chads	11	61	2223	2	chads
chafe	13	51	1735	2	chafe
chafed	15	48	1391	2	chafed
chaff	16	50	1628	2	chaff
chai	9	59	2990	2	cha_i
chain	10	57	2367	2	chain
chair	10	55	1963	2	chair
chaired	13	42	1124	2	chaired
chairs	11	49	1618	2	chairs
chais	10	75	3031	2	chais
chakra	15	43	753	2	chakra
chalk	14	48	1460	2	chalk
cham	11	55	3231	2	cha_m
champ	14	50	1796	2	champ
chams	12	60	2850	2	chams
chang	11	54	1856	2	chang
chant	10	59	3269	2	chant
chao	9	57	2731	2	cha_o
chaos	10	56	2286	2	chaos
chap	11	49	2849	2	cha_p
chape	12	52	2114	2	chape
chaps	12	53	2606	2	chaps
chapt	12	58	2764	2	chapt
charade	13	12	991	2	charade
charas	11	42	2361	2	charas
chares	11	56	3180	2	chares
charge	12	51	1421	2	charge
charged	14	46	1402	2	charged
charka	15	40	1170	2	charka
charked	17	48	1401	2	charked
charks	15	52	1970	2	charks
charmed	15	47	1425	2	charmed
charms	13	52	1884	2	charms
charred	13	46	1448	2	charred
charro	11	42	1295	2	charro
charrs	11	52	1919	2	charrs
charry	14	50	1211	2	charry
charted	13	51	1685	2	charted
charts	11	58	2309	2	charts
chase	10	51	2712	2	chase
chased	12	50	1929	2	chased
chasm	12	55	1879	2	chasm
chat	9	55	4613	2	cha_t
chats	10	57	3009	2	chats
chaw	12	62	2463	2	cha_w
chawed	15	52	1460	2	chawed
chaws	13	50	2246	2	chaws
chay	12	49	2487	2	cha_y
chays	13	53	1974	2	chays
chert	10	52	3210	2	chert
chid	10	66	2640	2	ch_id
child	11	45	1622	2	child
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
chords	12	52	1463	2	chords
chore	10	51	2676	2	chore
chored	12	53	2188	2	chored
churl	10	59	1388	2	churl
churn	10	51	1310	2	churn
churr	10	45	1285	2	churr
clad	7	62	2582	2	cla_d
claro	7	50	1869	2	claro
clary	10	57	1961	2	clary
cord	7	67	4092	2	c_ord
coward	12	4	1167	2	coward
curd	7	76	3498	2	c_urd
czar	15	60	1313	2	czar_
czars	16	48	1291	2	czars
echards	13	3	796	2	echards
fard	8	56	3906	2	_fard
guard	7	44	1554	2	guard
had	7	76	5876	2	_ha_d
haed	8	63	3858	2	_haed
hand	8	68	3371	2	_hand
hards	9	64	3565	2	_hards
hardy	12	56	2206	2	_hardy
hare	7	62	5573	2	_hare
hared	9	57	4218	2	_hared
hark	11	52	3739	2	_hark
harl	7	57	4000	2	_harl
harm	9	56	3779	2	_harm
harp	9	61	3429	2	_harp
hart	7	68	6577	2	_hart
heard	9	52	2275	2	heard
herd	8	49	3306	2	_herd
hoard	9	49	1831	2	hoard
lard	5	67	4200	2	_lard
liard	6	54	1859	2	liard
lyard	9	51	1321	2	lyard
nard	5	66	3445	2	_nard
orchard	13	4	693	2	orchard
pard	7	64	4132	2	_pard
pochard	15	3	736	2	pochard
sard	5	53	4424	2	_sard
shad	8	62	3091	2	sha_d
shaird	10	28	870	2	shaird
shards	10	43	1917	2	shards
share	8	64	3708	2	share
shared	10	58	2906	2	shared
shark	12	62	2502	2	shark
sharn	8	48	2370	2	sharn
sharp	10	49	2253	2	sharp
sherd	9	63	2115	2	sherd
sward	9	42	2146	2	sward
tharm	10	59	1664	2	tharm
third	9	59	1249	2	third
ward	8	65	4225	2	_ward
wharf	14	3	1582	2	wharf
yard	8	56	3325	2	_yard

Search took 6 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.656	272394.8
2	DLD Change Limit	53800	151	4.390	12255.1
3	Display Results	151	151	0.046	3282.6
	(SQL Overall)	178691	151	5.092	35092.5