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

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

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.

91 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
dibbuk	15	4	350	(None)
dibbuks	16	4	316	1	dibbuks
dybbuk	18	4	175	1	dybbuk
dibbed	12	47	1347	2	dibbed
dibber	11	46	1471	2	dibber
dibble	11	40	1384	2	dibble
dibbukim	19	5	90	2	dibbukim
disbud	10	16	571	2	disbud
dybbuks	19	4	160	2	dybbuks
airbus	8	4	834	3	airbus
bibb	7	58	1921	3	bibb__
bibbed	10	47	1234	3	bibbed
bibber	9	46	1357	3	bibber
bibbs	8	49	1158	3	bibb_s
chabuk	17	3	467	3	chabuk
chibouk	18	4	392	3	chibouk
dabbed	12	44	1614	3	dabbed
dabber	11	48	1696	3	dabber
dabble	11	45	1519	3	dabble
debark	13	42	1094	3	debark
debeak	13	3	676	3	debeak
debug	9	42	1006	3	d_ebug
debunk	13	6	511	3	debunk
debut	8	60	2414	3	d_ebut
dib	6	57	4694	3	di_b__
dibbers	12	40	1317	3	dibbers
dibbing	13	31	1089	3	dibbing
dibbled	13	35	1084	3	dibbled
dibbler	12	45	1028	3	dibbler
dibbles	12	40	1333	3	dibbles
dibs	7	62	3368	3	di_b_s
dick	11	64	3238	3	di__ck
dictum	11	3	686	3	dictum
dieback	16	4	691	3	dieback
dikdik	11	5	261	3	dikdik
dimout	9	4	1424	3	dimout
dingus	8	36	1184	3	dingus
dink	9	71	3780	3	di__nk
dinkum	13	3	589	3	dinkum
diobol	9	3	688	3	diobol
dirdum	10	3	603	3	dirdum
dirk	9	63	2683	3	di__rk
disbar	9	3	851	3	disbar
disbuds	11	12	524	3	disbuds
discus	9	45	1211	3	discus
diseur	7	3	884	3	diseur
disk	9	66	2583	3	di__sk
dobber	11	40	1542	3	dobber
dobbin	11	33	952	3	dobbin
dobby	13	60	1363	3	dobb_y
dorbug	10	3	495	3	dorbug
dribbed	13	32	675	3	dribbed
dribble	12	36	860	3	dribble
dribbly	15	27	495	3	dribbly
drouk	10	3	943	3	d_rouk
dubbed	12	41	1321	3	dubbed
dubber	11	38	1455	3	dubber
dubbin	11	32	926	3	dubbin
dybbukim	22	5	45	3	dybbukim
fibbed	14	40	1155	3	fibbed
fibber	13	48	1193	3	fibber
gibbed	12	45	1235	3	gibbed
gibber	11	41	1286	3	gibber
gibbet	11	41	1338	3	gibbet
gibbon	11	3	532	3	gibbon
gibbous	12	6	533	3	gibbous
hubbub	12	4	360	3	hubbub
imbue	9	3	948	3	_imbue
jibb	15	58	1674	3	jibb__
jibbed	18	48	1056	3	jibbed
jibber	17	41	1124	3	jibber
jibbs	16	60	974	3	jibb_s
kebbuck	16	4	292	3	kebbuck
kibbe	13	52	1197	3	kibb_e
kibbeh	17	40	606	3	kibbeh
kibbes	14	38	1119	3	kibbes
kibbi	13	44	927	3	kibb_i
kibbis	14	39	847	3	kibbis
kibble	14	39	1095	3	kibble
kibbutz	24	4	253	3	kibbutz
libber	10	44	1401	3	libber
limbus	10	57	1038	3	limbus
nibbed	11	43	1190	3	nibbed
nibble	10	37	1328	3	nibble
nimbus	10	37	728	3	nimbus
ribbed	11	40	1437	3	ribbed
ribber	10	35	1549	3	ribber
ribbon	10	3	653	3	ribbon
ribby	12	41	968	3	ribb_y
sibb	8	59	2142	3	sibb__
sibbs	9	62	1190	3	sibb_s

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	91	4.640	24292.2
3	Display Results	91	91	0.013	7000.0
	(SQL Overall)	178691	91	5.029	35532.1