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

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

95 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
forkers	14	46	1578	(None)
corkers	13	41	1885	1	corkers
forcers	12	42	1571	1	forcers
forgers	11	52	1818	1	forgers
forker	13	47	1790	1	forker_
formers	12	82	1795	1	formers
porkers	13	43	1493	1	porkers
workers	14	46	1269	1	workers
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
dockers	14	37	1500	2	dockers
dormers	10	43	1392	2	dormers
dorpers	10	41	1317	2	dorpers
dorsers	8	35	1630	2	dorsers
fakers	13	42	1953	2	f_akers
farcers	12	47	1344	2	farcers
farers	9	59	2405	2	far_ers
farmers	12	43	1526	2	farmers
firers	9	49	2268	2	fir_ers
firmers	12	47	1144	2	firmers
flakers	14	36	1327	2	flakers
foamers	12	38	1210	2	foamers
fodders	12	40	1075	2	fodders
foggers	12	41	1201	2	foggers
folders	11	35	1439	2	folders
footers	10	46	1833	2	footers
foragers	12	34	963	2	foragers
forayers	14	27	727	2	forayers
forbears	13	3	707	2	forbears
forceps	14	46	698	2	forceps
forcer	11	49	1734	2	forcer_
forces	11	44	2213	2	force_s
fores	8	58	4710	2	for_e_s
forevers	14	3	817	2	forevers
forger	10	48	2077	2	forger_
forgery	14	41	930	2	forgery
forges	10	50	2426	2	forge_s
forgets	11	38	1379	2	forgets
forgoers	12	3	641	2	forgoers
forked	14	52	1714	2	forke_d
forkier	14	43	1159	2	forkier_
forkless	15	26	743	2	forkless
forks	12	53	2468	2	fork__s
former	11	42	2140	2	former_
formes	11	46	2371	2	forme_s
forsakers	16	4	465	2	forsakers
fortes	9	53	2718	2	forte_s
fosters	10	42	2010	2	fosters
fowlers	13	34	1120	2	fowlers
foyers	12	54	1313	2	fo_yers
freers	9	47	1730	2	f_reers
friers	9	47	1893	2	f_riers
fryers	12	57	1097	2	f_ryers
fuckers	16	36	1159	2	fuckers
funkers	14	37	1206	2	funkers
furlers	10	42	1422	2	furlers
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
worker	13	47	1511	2	worker_
wormers	12	40	1257	2	wormers
yonkers	14	37	982	2	yonkers

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.140	1276364.3
2	DLD Change Limit	107671	95	2.860	37647.2
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	3.030	58973.9