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

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

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.

84 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
chokers	16	43	1152	(None)
choker	15	43	1437	1	choker_
chokes	15	49	1738	1	choke_s
cholers	12	42	1520	1	cholers
cookers	13	46	1946	1	cookers
bookers	13	40	1661	2	bookers
brokers	13	31	1191	2	brokers
calkers	13	44	1469	2	calkers
cankers	13	44	1875	2	cankers
chafers	15	45	1274	2	chafers
chasers	12	37	1492	2	chasers
chawers	15	44	1205	2	chawers
checkers	19	31	784	2	checkers
cheders	13	45	1239	2	cheders
cheers	11	45	1891	2	ch_eers
chewers	15	41	1114	2	chewers
chiders	13	53	1294	2	chiders
chimers	14	45	1514	2	chimers
choirs	11	49	1188	2	cho_irs
choke	14	51	1802	2	choke__
choked	16	49	1479	2	choke_d
chokey	18	48	1171	2	choke_y
chokier	16	3	804	2	chokier_
choler	11	37	1715	2	choler_
cholera	12	40	909	2	cholera
choleras	13	28	904	2	choleras
chompers	17	36	959	2	chompers
choosers	13	48	1088	2	choosers
choppers	17	41	1046	2	choppers
choreas	12	44	1420	2	choreas
chores	11	48	2802	2	chore_s
choses	11	58	2513	2	chose_s
chousers	13	46	1020	2	chousers
chowders	17	38	754	2	chowders
chukars	16	3	428	2	chukars
chukkers	16	3	348	2	chukkers
clockers	16	36	981	2	clockers
cloners	9	45	1482	2	cloners
closers	9	44	1532	2	closers
clovers	12	51	1466	2	clovers
cockers	15	36	1833	2	cockers
coders	9	54	2698	2	c_oders
cokes	11	55	3719	2	c_oke_s
comers	10	53	2808	2	c_omers
conkers	13	37	2104	2	conkers
cooers	8	43	2456	2	c_ooers
cooker	12	47	2245	2	cooker_
cookery	16	42	1039	2	cookery
cookeys	16	47	850	2	cookeys
coolers	9	35	2249	2	coolers
coopers	11	40	1948	2	coopers
cooters	9	45	2573	2	cooters
copers	10	46	2984	2	c_opers
corers	8	52	3107	2	c_orers
corkers	13	41	1885	2	corkers
covers	11	46	2796	2	c_overs
cowers	11	46	2553	2	c_owers
croakers	14	28	852	2	croakers
crowers	12	46	1490	2	crowers
crozers	18	41	1108	2	crozers
echoers	12	45	969	2	echo_ers
evokers	14	38	679	2	evokers
hikers	13	50	1435	2	_hikers
hockers	16	39	1591	2	_hockers
hoers	8	57	2492	2	_ho_ers
hokes	12	62	3164	2	_hoke_s
homers	11	48	2198	2	_homers
honers	9	43	2497	2	_honers
honkers	14	33	1523	2	_honkers
hookers	14	49	1652	2	hookers
hopers	11	42	2297	2	_hopers
hosers	9	52	2397	2	_hosers
hovers	12	43	2025	2	_hovers
jokers	17	55	1119	2	_jokers
lookers	11	40	1407	2	lookers
pokers	12	46	1792	2	_pokers
shakers	14	40	1556	2	shakers
shockers	17	31	946	2	shockers
shoers	9	45	1833	2	sho_ers
shovers	13	46	1300	2	shovers
showers	13	46	1268	2	showers
smokers	13	38	932	2	smokers
stokers	11	45	1518	2	stokers
tokers	10	48	1889	2	_tokers

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	84	3.470	31029.1
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	3.873	46137.6