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

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

73 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
dibbing	13	31	1089	(None)
bibbing	11	29	961	1	bibbing
dabbing	13	35	1123	1	dabbing
dibbling	14	24	733	1	dibbling
dribbing	14	32	588	1	dribbing
dubbing	13	33	1121	1	dubbing
fibbing	15	33	946	1	fibbing
gibbing	13	33	937	1	gibbing
jibbing	19	33	806	1	jibbing
nibbing	12	33	955	1	nibbing
ribbing	12	31	1195	1	ribbing
bobbing	11	31	1319	2	bobbing
cabbing	14	36	1315	2	cabbing
cribbing	15	27	684	2	cribbing
dabbling	14	22	797	2	dabbling
daubing	11	35	862	2	daubing
dialing	9	43	1817	2	dialing
dicing	10	57	1876	2	di_cing
dicking	15	36	1761	2	dicking
dieing	8	40	1865	2	di_eing
dieting	9	36	1683	2	dieting
digging	11	35	1370	2	digging
diking	12	43	2024	2	di_king
dimming	13	33	959	2	dimming
dinging	10	36	1861	2	dinging
dining	8	45	2513	2	di_ning
dinking	13	36	1828	2	dinking
dinning	9	34	1655	2	dinning
dinting	9	35	2055	2	dinting
dipping	13	40	1483	2	dipping
dirking	13	38	1260	2	dirking
dirling	9	33	1607	2	dirling
discing	11	39	1459	2	discing
dishing	12	40	1710	2	dishing
disking	13	46	1549	2	disking
dissing	9	45	1768	2	dissing
diving	11	37	1795	2	di_ving
dobbin	11	33	952	2	dobbin_
dobbins	12	37	953	2	dobbins
drabbing	14	28	680	2	drabbing
dribbling	15	3	371	2	dribbling
drubbing	14	28	605	2	drubbing
dubbin	11	32	926	2	dubbin_
dubbings	14	24	547	2	dubbings
dubbins	12	35	880	2	dubbins
dumbing	13	31	985	2	dumbing
ebbing	11	3	707	2	_ebbing
fobbing	15	34	1027	2	fobbing
fubbing	15	40	957	2	fubbing
gabbing	13	35	1203	2	gabbing
gibing	10	37	1235	2	gi_bing
gobbing	13	29	1070	2	gobbing
hobbing	15	28	1112	2	hobbing
jabbing	19	31	941	2	jabbing
jibing	16	37	962	2	ji_bing
jobbing	19	27	901	2	jobbing
kibbling	17	22	570	2	kibbling
limbing	12	34	1042	2	limbing
lobbing	12	31	1091	2	lobbing
mobbing	14	29	970	2	mobbing
nabbing	12	29	996	2	nabbing
nibbling	13	25	650	2	nibbling
ribbings	13	27	592	2	ribbings
robbing	12	33	1321	2	robbing
rubbing	12	34	1227	2	rubbing
sabbing	12	33	1474	2	sabbing
sibling	10	8	1442	2	sibling
snibbing	13	29	589	2	snibbing
sobbing	12	76	1288	2	sobbing
subbing	12	39	1558	2	subbing
tabbing	12	36	1191	2	tabbing
tubbing	12	35	1009	2	tubbing
webbing	15	3	612	2	webbing

Search took 5 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.406	440125.6
2	DLD Change Limit	107671	73	3.593	29966.9
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	4.029	44351.2