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

Here are the results of your fuzzy-string dictionary search for “ribbed” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

103 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
ribbed	11	40	1437	(None)
bibbed	10	47	1234	1	bibbed
cribbed	14	40	766	1	cribbed
dibbed	12	47	1347	1	dibbed
dribbed	13	32	675	1	dribbed
fibbed	14	40	1155	1	fibbed
gibbed	12	45	1235	1	gibbed
jibbed	18	48	1056	1	jibbed
nibbed	11	43	1190	1	nibbed
ribber	10	35	1549	1	ribber
robbed	11	34	1519	1	robbed
rubbed	11	45	1508	1	rubbed
bibber	9	46	1357	2	bibber
bobbed	10	43	1583	2	bobbed
bribed	11	53	1284	2	bri_bed
cabbed	13	54	1626	2	cabbed
crabbed	14	38	887	2	crabbed
cribber	13	36	766	2	cribber
cribbled	15	30	580	2	cribbled
dabbed	12	44	1614	2	dabbed
dibber	11	46	1471	2	dibber
dibbled	13	35	1084	2	dibbled
drabbed	13	42	872	2	drabbed
dribbled	14	37	659	2	dribbled
drubbed	13	40	698	2	drubbed
dubbed	12	41	1321	2	dubbed
ebbed	10	41	1100	2	_ebbed
fibber	13	48	1193	2	fibber
fobbed	14	41	1261	2	fobbed
fribbled	16	30	574	2	fribbled
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
grabbed	13	36	864	2	grabbed
grubbed	13	40	643	2	grubbed
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
rabbet	10	38	1865	2	rabbet
rabbled	12	35	1442	2	rabbled
rebbe	9	3	1316	2	rebbe_
rebbes	10	3	1353	2	rebbes
rebred	9	58	1635	2	rebred
ribald	9	20	929	2	ribald
riband	9	23	962	2	riband
ribband	12	4	558	2	ribband
ribbers	11	39	1318	2	ribbers
ribbier	11	3	759	2	ribbier
ribbon	10	3	653	2	ribbon
ribboned	13	4	397	2	ribboned
ribby	12	41	968	2	ribb_y
ribes	7	55	3017	2	ri_bes
ribier	8	44	1423	2	ribier
riblet	8	42	2244	2	riblet
riced	8	58	2554	2	ri_ced
ricked	13	65	2362	2	ricked
ridded	9	36	1512	2	ridded
ridged	9	40	1422	2	ridged
riffed	13	38	1156	2	riffed
rifled	10	41	1500	2	rifled
rifted	10	41	1531	2	rifted
rigged	9	45	1740	2	rigged
riled	6	58	3325	2	ri_led
rilled	7	45	2565	2	rilled
rimed	8	48	2637	2	ri_med
rimmed	11	48	1230	2	rimmed
rinded	8	44	1898	2	rinded
ringed	8	46	2384	2	ringed
rinsed	7	50	1635	2	rinsed
rioted	7	34	1637	2	rioted
riped	8	52	2643	2	ri_ped
ripped	11	44	1901	2	ripped
risked	11	55	1463	2	risked
rived	9	48	2561	2	ri_ved
robber	10	39	1653	2	robber
robed	8	53	2373	2	r_obed
rubber	10	47	1579	2	rubber
rubbled	12	46	1162	2	rubbled
rubied	9	43	1241	2	rubied
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
unribbed	13	3	417	2	unribbed
webbed	14	3	643	2	webbed

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	82551	0.720	248181.9
2	DLD Change Limit	82551	103	6.876	12005.7
3	Display Results	103	103	0.076	1355.3
	(SQL Overall)	178691	103	7.672	23291.3