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

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

89 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
dibbed	12	47	1347	(None)
bibbed	10	47	1234	1	bibbed
dabbed	12	44	1614	1	dabbed
dibber	11	46	1471	1	dibber
dibbled	13	35	1084	1	dibbled
dribbed	13	32	675	1	dribbed
dubbed	12	41	1321	1	dubbed
fibbed	14	40	1155	1	fibbed
gibbed	12	45	1235	1	gibbed
jibbed	18	48	1056	1	jibbed
nibbed	11	43	1190	1	nibbed
ribbed	11	40	1437	1	ribbed
bibber	9	46	1357	2	bibber
bobbed	10	43	1583	2	bobbed
cabbed	13	54	1626	2	cabbed
cribbed	14	40	766	2	cribbed
dabber	11	48	1696	2	dabber
dabbled	13	37	1207	2	dabbled
daubed	10	46	1178	2	daubed
daybed	13	43	867	2	daybed
dialed	8	47	1645	2	dialed
dibbers	12	40	1317	2	dibbers
dibble	11	40	1384	2	dibble
dibbler	12	45	1028	2	dibbler
dibbles	12	40	1333	2	dibbles
dibbuk	15	4	350	2	dibbuk
diced	9	58	2468	2	di_ced
dicked	14	49	2086	2	dicked
died	6	61	3785	2	di__ed
dieted	8	31	1549	2	dieted
digged	10	43	1465	2	digged
diked	11	50	2468	2	di_ked
dilled	8	41	2222	2	dilled
dimmed	12	41	1032	2	dimmed
dined	7	64	3199	2	di_ned
dinged	9	52	2178	2	dinged
dinked	12	48	1835	2	dinked
dinned	8	43	1761	2	dinned
dinted	8	44	1984	2	dinted
dipped	12	35	1749	2	dipped
dirked	12	49	1227	2	dirked
dirled	8	45	1490	2	dirled
disbud	10	16	571	2	disbud
disced	10	49	1465	2	disced
dished	11	43	1871	2	dished
disked	12	50	1576	2	disked
dissed	8	52	2018	2	dissed
dived	10	63	2137	2	di_ved
dobber	11	40	1542	2	dobber
drabbed	13	42	872	2	drabbed
dribbled	14	37	659	2	dribbled
drubbed	13	40	698	2	drubbed
dubber	11	38	1455	2	dubber
dumbed	12	40	1208	2	dumbed
ebbed	10	41	1100	2	_ebbed
fibber	13	48	1193	2	fibber
fobbed	14	41	1261	2	fobbed
fubbed	14	47	1124	2	fubbed
gabbed	12	52	1689	2	gabbed
gibber	11	41	1286	2	gibber
gibbet	11	41	1338	2	gibbet
gibed	9	62	1596	2	gi_bed
gobbed	12	46	1388	2	gobbed
hobbed	14	41	1430	2	hobbed
imbed	10	50	1365	2	_imbed
jabbed	18	42	1348	2	jabbed
jibber	17	41	1124	2	jibber
jibed	15	51	1416	2	ji_bed
jobbed	18	42	1213	2	jobbed
kibbe	13	52	1197	2	kibbe_
kibbeh	17	40	606	2	kibbeh
kibbes	14	38	1119	2	kibbes
kibbled	16	36	798	2	kibbled
libber	10	44	1401	2	libber
limbed	11	45	1318	2	limbed
lobbed	11	31	1461	2	lobbed
mobbed	13	71	1224	2	mobbed
nabbed	11	51	1361	2	nabbed
nibbled	12	38	907	2	nibbled
ribber	10	35	1549	2	ribber
robbed	11	34	1519	2	robbed
rubbed	11	45	1508	2	rubbed
sabbed	11	45	1808	2	sabbed
snibbed	12	32	563	2	snibbed
sobbed	11	35	1626	2	sobbed
subbed	11	41	1667	2	subbed
tabbed	11	42	1536	2	tabbed
tubbed	11	47	1222	2	tubbed
webbed	14	3	643	2	webbed

Search took 3 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	82551	0.330	541487.9
2	DLD Change Limit	82551	89	2.500	33020.4
3	Display Results	89	89	0.030	2966.7
	(SQL Overall)	178691	89	2.860	62479.4