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

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

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.

80 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
handworkers	22	5	261	(None)
handworker	21	4	321	1	handworker_
handworks	20	4	670	2	handwork__s
caseworkers	20	5	246	3	caseworkers
dayworkers	21	4	216	3	da_yworkers
farmworkers	23	5	142	3	farmworkers
handiworks	21	4	269	3	handiwork__s
handovers	16	13	618	3	hand_o_vers
handwork	19	4	690	3	handwork___
nonworkers	17	4	441	3	non_workers
wageworkers	22	7	195	3	wageworkers
waxworkers	27	5	200	3	wa_xworkers
woodworkers	22	15	272	3	woodworkers
adorers	8	44	1173	4	_a_d_or_ers
adorners	9	19	662	4	_a_d_orners
adsorbers	12	4	326	4	_a_dsorbers
answerers	12	4	374	4	_answer_ers
autoworkers	18	5	174	4	autoworkers
bandoleers	13	4	356	4	band_oleers
bandoliers	13	4	414	4	band_oliers
bandores	11	3	1160	4	band_or_e_s
caseworker	19	5	296	4	caseworker_
coworkers	18	5	436	4	__coworkers
dayworker	20	4	239	4	da_yworker_
dockworkers	20	14	233	4	dockworkers
endorsers	10	4	612	4	_end_orsers
farmworker	22	5	169	4	farmworker_
glassworkers	20	5	122	4	glassworkers
hackworks	20	4	520	4	hackwork__s
hairworks	19	4	484	4	hairwork__s
handbaskets	21	5	153	4	handbaskets
handbooks	19	4	439	4	handbook__s
handers	11	42	2433	4	hand____ers
handiwork	20	4	301	4	handiwork___
handlers	12	40	1414	4	hand___lers
handover	15	12	682	4	hand_o_ver_
handpress	15	4	403	4	hand_pr_ess
handshakes	21	4	356	4	handshake_s
handsomer	15	4	545	4	handso_mer_
handspikes	20	4	283	4	handspike_s
handwheels	20	12	208	4	handw_heels
handwoven	19	4	321	4	handwo_ve_n
handwringers	20	5	137	4	handwringers
handwrites	17	4	475	4	handw_rites
handwrote	16	4	412	4	handwrote__
hangovers	16	14	416	4	han_go_vers
hankerers	16	22	671	4	han_ker_ers
hankers	14	42	1813	4	han____kers
harborers	14	4	691	4	ha_rbor_ers
hardcores	15	4	598	4	hardcor_e_s
hardcovers	19	4	303	4	hardco_vers
hardwares	16	4	656	4	hardwar_e_s
hardwires	16	4	464	4	hardwir_e_s
hardworking	23	5	167	4	hardworking
havockers	21	4	212	4	ha__vockers
hawkers	17	42	1033	4	ha__w__kers
headworks	20	4	595	4	headwork__s
hinderers	13	3	735	4	hind_er_ers
honorers	11	3	927	4	hon__or_ers
hoodwinkers	22	5	173	4	hoodwinkers
indorsers	10	7	538	4	_ind_orsers
ironworkers	18	5	206	4	ironworkers
landholders	16	5	325	4	landholders
landlopers	13	4	367	4	landlo_pers
landowners	14	4	348	4	land_owners
networkers	17	4	263	4	_networkers
nonworker	16	4	482	4	non_worker_
outworkers	17	4	333	4	_outworkers
panderers	12	22	915	4	pand_er_ers
pandores	11	3	1245	4	pand_or_e_s
sandlotters	12	5	287	4	sandlotters
sandworms	15	4	565	4	sandwor__ms
sandworts	13	4	645	4	sandwor__ts
timeworkers	20	5	195	4	timeworkers
wageworker	21	8	227	4	wageworker_
wanderers	13	22	848	4	wand_er_ers
waxworker	26	4	213	4	wa_xworker_
woodworker	21	15	322	4	woodworker_
workers	14	46	1269	4	____workers
yardworks	20	4	448	4	yardwork__s

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	80	8.986	16561.2
3	Display Results	80	80	0.043	1860.5
	(SQL Overall)	178691	80	9.465	18879.1