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

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

65 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
jobbing	19	27	901	(None)
bobbing	11	31	1319	1	bobbing
fobbing	15	34	1027	1	fobbing
gobbing	13	29	1070	1	gobbing
hobbing	15	28	1112	1	hobbing
jabbing	19	31	941	1	jabbing
jibbing	19	33	806	1	jibbing
lobbing	12	31	1091	1	lobbing
mobbing	14	29	970	1	mobbing
robbing	12	33	1321	1	robbing
sobbing	12	76	1288	1	sobbing
bibbing	11	29	961	2	bibbing
blobbing	12	24	692	2	blobbing
bobbin	9	34	1073	2	bobbin_
bobbins	10	34	1034	2	bobbins
bobbling	12	23	864	2	bobbling
bombing	14	32	1139	2	bombing
boobing	12	36	1391	2	boobing
cabbing	14	36	1315	2	cabbing
cobbling	15	24	880	2	cobbling
combing	14	37	1473	2	combing
dabbing	13	35	1123	2	dabbing
dibbing	13	31	1089	2	dibbing
dobbin	11	33	952	2	dobbin_
dobbins	12	37	953	2	dobbins
dubbing	13	33	1121	2	dubbing
ebbing	11	3	707	2	_ebbing
fibbing	15	33	946	2	fibbing
fubbing	15	40	957	2	fubbing
gabbing	13	35	1203	2	gabbing
gibbing	13	33	937	2	gibbing
gobbling	14	25	753	2	gobbling
hobbling	16	22	758	2	hobbling
hoboing	13	30	945	2	hoboing
jambing	19	32	853	2	jambing
jibing	16	37	962	2	j_ibing
jogging	17	32	1123	2	jogging
joining	15	30	1148	2	joining
joking	18	41	1302	2	jo_king
jolting	15	34	1091	2	jolting
joshing	18	51	941	2	joshing
jotting	15	29	1277	2	jotting
jouking	19	30	761	2	jouking
jowing	17	42	1604	2	jo_wing
joying	17	38	1080	2	jo_ying
lobbying	16	3	360	2	lobbying
nabbing	12	29	996	2	nabbing
nibbing	12	33	955	2	nibbing
nobbling	13	22	827	2	nobbling
orbing	9	33	1236	2	_orbing
ribbing	12	31	1195	2	ribbing
robbin	10	36	1118	2	robbin_
robbins	11	28	1106	2	robbins
robing	9	36	1800	2	ro_bing
rubbing	12	34	1227	2	rubbing
sabbing	12	33	1474	2	sabbing
sorbing	10	28	1526	2	sorbing
stobbing	13	22	724	2	stobbing
subbing	12	39	1558	2	subbing
swobbing	16	23	517	2	swobbing
tabbing	12	36	1191	2	tabbing
tombing	12	33	1053	2	tombing
tubbing	12	35	1009	2	tubbing
webbing	15	3	612	2	webbing
wobbling	16	24	692	2	wobbling

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.376	475242.0
2	DLD Change Limit	107671	65	2.920	36873.6
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.312	53952.6