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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

65 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
backhand	20	4	743	(None)
backhands	21	4	630	1	backhands
backland	17	4	810	1	backland
bacchant	17	4	780	2	bacchant
backbend	19	4	478	2	backbend
backhanded	23	11	466	2	backhanded
backhander	22	14	494	2	backhander
backhaul	19	4	513	2	backhaul
backhoed	20	4	701	2	backhoed
backlands	18	4	682	2	backlands
backward	20	4	810	2	backward
backyard	20	4	684	2	backyard
barehand	14	4	615	2	barehand
blackland	18	4	465	2	blackland
deckhand	19	4	310	2	deckhand
dockhand	19	5	339	2	dockhand
bacchanal	18	5	280	3	bacchanal
bacchante	18	4	465	3	bacchante
bacchants	18	4	502	3	bacchants
bached	14	55	1989	3	bac_h_ed
baching	15	60	1775	3	bac_hing
backbends	20	4	409	3	backbends
backboard	20	4	718	3	backboard
backbone	18	4	744	3	backbone
backboned	20	4	548	3	backboned
backcast	18	8	767	3	backcast
backchat	21	4	711	3	backcha_t
backchats	22	4	531	3	backchats
backdate	17	4	822	3	backdate
backdated	19	4	648	3	backdated
backed	15	57	2572	3	back__ed
backhanders	23	12	380	3	backhand~~ers~~
backhanding	24	5	376	3	backhand~~ing~~
backhauled	22	5	325	3	backhauled
backhauls	20	4	486	3	backhauls
backhoe	18	4	715	3	backh_oe
backhoes	19	3	854	3	backhoes
backing	16	55	2344	3	back_ing
backlash	19	4	592	3	backlash
backload	17	4	683	3	backload
backpack	19	4	546	3	backpack
backsaw	18	3	620	3	backsa_w
backsaws	19	4	680	3	backsaws
backslid	17	4	627	3	backslid
backwards	21	4	746	3	backwards
backwash	22	4	494	3	backwash
backwood	20	4	697	3	backwood
backyards	21	4	653	3	backyards
badland	11	4	765	3	ba_dland
bankcard	17	7	402	3	bankcard
barchan	14	6	913	3	barchan_
barchans	15	8	868	3	barchans
barehands	15	4	525	3	barehands
blackhander	23	6	302	3	blackhander
blackhead	21	8	429	3	blackhead
blacklands	19	4	412	3	blacklands
buckhound	21	4	319	3	buckhound
deckhands	20	4	308	3	deckhands
dockhands	20	5	312	3	dockhands
dockland	16	4	371	3	dockland
farmhand	17	4	356	3	farmhand
hackman	18	3	643	3	hackman_
neckband	17	4	253	3	neckband
packman	17	3	669	3	packman_
parkland	15	4	537	3	parkland

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	65	7.673	19048.9
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	8.126	21990.0