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

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

88 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
scrubby	16	4	280	(None)
shrubby	17	4	236	1	shrubby
chubby	18	4	412	2	_chubby
clubby	15	3	468	2	_clubby
crabby	15	34	675	2	_crabby
crumby	15	40	811	2	_crumby
cubby	14	52	1211	2	_c_ubby
grubby	14	32	450	2	_grubby
rubby	12	44	1385	2	__rubby
scabby	15	3	550	2	sc_abby
scrabbly	17	16	462	2	scrabbly
scribbly	17	14	362	2	scribbly
scrub	9	49	1420	2	scru_b_
scrubbed	15	3	385	2	scrubbed
scrubber	14	3	411	2	scrubber
scrubbily	18	4	231	2	scrubbily
scrubs	10	42	1031	2	scru_bs
scruffy	18	4	264	2	scruffy
snubby	13	4	453	2	s_nubby
stubby	13	4	504	2	s_tubby
brumby	15	38	595	3	_brumby
bubby	11	50	1392	3	__bubby
cabby	14	53	1455	3	_c_abby
cobby	14	55	1640	3	_c_obby
cruddy	13	3	419	3	_cruddy
crumb	11	43	1359	3	_crumb_
crumbly	16	34	752	3	_crumbly
crumbs	12	40	923	3	_crumbs
crummy	15	36	589	3	_crummy
crusty	11	49	1134	3	_crusty
crybaby	19	4	193	3	_crybaby
grabby	14	33	618	3	_grabby
hubby	15	50	1139	3	__hubby
knubby	17	4	278	3	_knubby
nubby	12	50	1102	3	__nubby
ribby	12	41	967	3	__ribby
rubbly	13	37	1061	3	__rubbly
ruby	9	78	1994	3	__ru_by
rugby	11	44	813	3	__rugby
scrabble	14	19	699	3	scrabble
scraggy	14	30	458	3	scraggy
scrappy	16	23	447	3	scrappy
scrawly	15	19	718	3	scrawly
scrawny	15	21	393	3	scrawny
screaky	16	43	621	3	screaky
screwy	14	65	945	3	scr_ewy
scribal	11	3	796	3	scribal
scribble	14	17	543	3	scribble
scribe	10	46	1352	3	scr_ibe
scribed	12	45	1064	3	scribed
scriber	11	39	1096	3	scriber
scribes	11	37	1320	3	scribes
scrimpy	16	48	613	3	scrimpy
scroggy	14	24	384	3	scroggy
scroungy	14	5	256	3	scroungy
scrubbers	15	4	336	3	scrubbers
scrubbier	15	4	333	3	scrubbier
scrubbing	16	3	393	3	scrubbing
scruff	14	3	796	3	scru_ff
scruffs	15	5	417	3	scruffs
scrum	9	54	1819	3	scru__m
scrums	10	46	1425	3	scru_ms
scrunch	14	4	403	3	scrunch
scrunchy	18	5	238	3	scrunchy
scruple	11	3	719	3	scruple
scrutiny	13	4	477	3	scrutiny
scry	9	60	1776	3	scr___y
scuba	9	42	1159	3	sc_u_ba
scubas	10	37	1022	3	sc_ubas
scummy	15	26	522	3	sc_ummy
scurfy	14	33	876	3	sc_urfy
scurry	11	41	958	3	sc_urry
scurvy	14	38	610	3	sc_urvy
scuzzy	19	3	308	3	sc_uzzy
shabby	16	3	580	3	s_habby
shrub	10	48	1489	3	shru_b_
shrubbery	19	4	170	3	shrubbery
shrubs	11	40	921	3	shru_bs
sirupy	11	37	705	3	siru_py
slobby	13	3	480	3	s_lobby
snobby	13	3	440	3	s_nobby
solubly	12	5	528	3	solubly
sprucy	13	35	632	3	spru_cy
squabby	23	4	328	3	squabby
stubbly	14	4	447	3	s_tubbly
swabby	16	3	435	3	s_wabby
syrupy	14	28	582	3	syru_py
tubby	12	45	1139	3	__tubby

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	134027	0.143	1249587.4
2	DLD Change Limit	134027	88	8.016	16719.9
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	8.189	21820.9