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

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

43 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
drubbed	13	40	698	(None)
drabbed	13	42	872	1	drabbed
dribbed	13	32	675	1	dribbed
drubber	12	35	786	1	drubber
dubbed	12	41	1321	1	d_ubbed
grubbed	13	40	643	1	grubbed
rubbed	11	45	1508	1	_rubbed
blubbed	11	33	839	2	blubbed
clubbed	14	30	745	2	clubbed
crabbed	14	38	887	2	crabbed
cribbed	14	40	766	2	cribbed
crumbed	14	37	847	2	crumbed
dabbed	12	44	1614	2	d_abbed
daubed	10	46	1178	2	dau_bed
dibbed	12	47	1347	2	d_ibbed
doubled	11	28	995	2	doubled
doubted	11	30	748	2	doubted
drabber	12	43	859	2	drabber
drabbet	12	31	957	2	drabbet
drabbled	14	36	705	2	drabbled
dribbled	14	37	659	2	dribbled
drubbers	13	38	603	2	drubbers
drudged	11	27	761	2	drudged
drugged	11	36	718	2	drugged
drumbled	14	26	603	2	drumbled
drummed	13	30	632	2	drummed
dubber	11	38	1455	2	d_ubber
dumbed	12	40	1208	2	d_umbed
flubbed	15	30	663	2	flubbed
fubbed	14	47	1124	2	_fubbed
grabbed	13	36	864	2	grabbed
grubber	12	41	791	2	grubber
ribbed	11	40	1437	2	_ribbed
robbed	11	34	1519	2	_robbed
rubber	10	47	1579	2	_rubber
rubbled	12	46	1162	2	_rubbled
rubied	9	43	1241	2	_rubied
scrubbed	15	3	385	2	scrubbed
slubbed	12	33	928	2	slubbed
snubbed	12	34	744	2	snubbed
stubbed	12	37	808	2	stubbed
subbed	11	41	1667	2	_subbed
tubbed	11	47	1222	2	_tubbed

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.390	458182.1
2	DLD Change Limit	107671	43	2.923	36835.8
3	Display Results	43	43	0.016	2687.5
	(SQL Overall)	178691	43	3.329	53677.1