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

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

82 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
workers	14	46	1269	(None)
corkers	13	41	1885	1	corkers
forkers	14	46	1578	1	forkers
porkers	13	43	1493	1	porkers
worker	13	47	1511	1	worker_
wormers	12	40	1257	1	wormers
barkers	13	43	1851	2	barkers
bonkers	13	40	1530	2	bonkers
bookers	13	40	1661	2	bookers
borders	10	43	1753	2	borders
borers	8	51	2268	2	bor_ers
brokers	13	31	1191	2	brokers
burkers	13	37	1662	2	burkers
cockers	15	36	1833	2	cockers
conkers	13	37	2104	2	conkers
cookers	13	46	1946	2	cookers
corders	10	45	2088	2	corders
corers	8	52	3107	2	cor_ers
corker	12	47	2085	2	corker_
corners	9	47	2331	2	corners
coworkers	18	5	436	2	coworkers
dockers	14	37	1500	2	dockers
dormers	10	43	1392	2	dormers
dorpers	10	41	1317	2	dorpers
dorsers	8	35	1630	2	dorsers
forcers	12	42	1571	2	forcers
forgers	11	52	1818	2	forgers
forker	13	47	1790	2	forker_
formers	12	82	1795	2	formers
gorgers	9	48	1364	2	gorgers
hockers	16	39	1591	2	hockers
honkers	14	33	1523	2	honkers
hookers	14	49	1651	2	hookers
jerkers	18	28	708	2	jerkers
jokers	17	55	1119	2	jo_kers
larkers	11	30	1451	2	larkers
lockers	13	35	1692	2	lockers
lookers	11	40	1407	2	lookers
lurkers	11	39	1008	2	lurkers
markers	13	35	1610	2	markers
mockers	15	38	1294	2	mockers
ockers	12	38	1390	2	_ockers
orders	7	43	1599	2	_orders
ormers	8	43	1614	2	_ormers
parkers	13	38	1687	2	parkers
pokers	12	46	1792	2	po_kers
porker	12	49	1754	2	porker_
porters	9	37	2270	2	porters
rockers	13	39	1655	2	rockers
soakers	11	41	1495	2	soakers
sorners	7	34	1687	2	sorners
sorters	7	42	2113	2	sorters
tokers	10	48	1889	2	to_kers
wakers	13	48	2249	2	w_akers
walkers	14	34	1147	2	walkers
wankers	14	45	1471	2	wankers
warders	11	34	1681	2	warders
warmers	12	45	1429	2	warmers
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
wickers	16	41	1470	2	wickers
winkers	14	35	1711	2	winkers
wirers	9	46	1789	2	wir_ers
wolfers	13	40	963	2	wolfers
wolvers	13	34	931	2	wolvers
wonders	11	33	1599	2	wonders
wonners	10	43	1281	2	wonners
wooers	9	37	1244	2	wo_oers
woofers	13	38	1058	2	woofers
woolers	10	42	1402	2	woolers
worked	14	53	1470	2	worke_d
workless	15	27	680	2	workless
works	12	56	2190	2	work__s
workups	16	3	361	2	workups
wormer	11	45	1491	2	wormer_
worriers	11	25	781	2	worriers
worsens	10	46	1026	2	worsens
worser	9	51	1752	2	worser_
worses	9	55	2295	2	worse_s
worsets	10	55	1284	2	worsets
wowsers	13	48	876	2	wowsers
yonkers	14	37	982	2	yonkers

Search took 8 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.796	224486.2
2	DLD Change Limit	107671	82	6.470	16641.6
3	Display Results	82	82	0.063	1301.6
	(SQL Overall)	178691	82	7.329	24381.4