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

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

60 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
dibble	11	40	1384	(None)
dabble	11	45	1519	1	dabble
dibbled	13	35	1084	1	dibbled
dibbler	12	45	1028	1	dibbler
dibbles	12	40	1333	1	dibbles
dribble	12	36	860	1	dribble
kibble	14	39	1095	1	kibble
nibble	10	37	1328	1	nibble
babble	9	40	1711	2	babble
bible	9	51	1942	2	bi_ble
bobble	9	41	1514	2	bobble
bubble	9	40	1659	2	bubble
cobble	12	36	1526	2	cobble
dabbled	13	37	1207	2	dabbled
dabbler	12	40	1215	2	dabbler
dabbles	12	45	1477	2	dabbles
dibbed	12	47	1347	2	dibbed
dibber	11	46	1471	2	dibber
dibblers	13	37	758	2	dibblers
dibbuk	15	4	350	2	dibbuk
diddle	9	49	1521	2	diddle
dimple	11	35	1279	2	dimple
dindle	8	44	1722	2	dindle
dingle	8	43	1707	2	dingle
dipole	9	11	1285	2	dipole
disable	10	5	1643	2	disable
doable	9	31	1524	2	doable
double	9	40	1399	2	double
drabble	12	23	888	2	drabble
dribbled	14	37	659	2	dribbled
dribbler	13	31	631	2	dribbler
dribbles	13	34	839	2	dribbles
dribblet	13	34	754	2	dribblet
dribbly	15	27	495	2	dribbly
dyable	12	30	898	2	dyable
edible	9	6	935	2	edi_ble
fimble	13	36	1175	2	fimble
fribble	14	28	778	2	fribble
gabble	11	38	1572	2	gabble
gobble	11	35	1298	2	gobble
gribble	12	29	727	2	gribble
hobble	13	39	1343	2	hobble
kibbe	13	52	1197	2	kibb_e
kibbled	16	36	798	2	kibbled
kibbles	15	35	1025	2	kibbles
liable	8	14	1581	2	liable
nibbled	12	38	907	2	nibbled
nibbler	11	37	927	2	nibbler
nibbles	11	40	1169	2	nibbles
nimble	10	34	1294	2	nimble
nobble	10	38	1431	2	nobble
nubble	10	38	1371	2	nubble
pebble	12	3	800	2	pebble
quibble	20	3	471	2	quibble
rabble	10	38	1824	2	rabble
rubble	10	43	1567	2	rubble
viable	11	16	1377	2	viable
wabble	13	37	1484	2	wabble
wimble	13	32	1192	2	wimble
wobble	13	32	1231	2	wobble

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.346	516448.0
2	DLD Change Limit	82551	60	2.106	39198.0
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	2.485	71907.8