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

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

76 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
hubbub	12	4	360	1	hubbub
hubbly	16	47	841	2	hubbly
hubbubs	13	4	260	2	hubbubs
hubby	15	50	1140	2	hubb_y
humbug	14	3	480	2	humbug
bubba	8	43	1180	3	bubb_a
bubbas	9	41	1070	3	bubbas
bubble	9	40	1659	3	bubble
bubbly	12	41	1035	3	bubbly
bubby	11	50	1393	3	bubb_y
bubu	8	50	2267	3	bu_bu_
bubus	9	51	1545	3	bu_bus
bulbul	10	34	807	3	bulbul
chubby	18	4	412	3	chubb_y
cubby	14	52	1212	3	cubb_y
cubic	11	43	1342	3	cu_bic
dibbuk	15	4	350	3	dibbuk
dubbed	12	41	1321	3	dubbed
dubber	11	38	1455	3	dubber
dubbin	11	32	926	3	dubbin
dybbuk	18	4	175	3	dybbuk
fubbed	14	47	1124	3	fubbed
habu	9	73	2548	3	h_abu_
habus	10	63	1714	3	h_abus
hagbut	12	7	892	3	hagbut
hobbed	14	41	1430	3	hobbed
hobber	13	41	1463	3	hobber
hobbit	13	28	1054	3	hobbit
hobble	13	39	1343	3	hobble
hobby	15	59	1373	3	hobb_y
hub	8	64	3748	3	hu_b__
hubbies	14	32	1156	3	hubbies
hubcap	15	5	399	3	hubcap
hubris	11	21	897	3	hubris
hubs	9	60	2714	3	hu_b_s
huic	9	48	1805	3	hu__ic
humble	13	36	1505	3	humble
humbly	16	40	1052	3	humbly
humbugs	15	3	424	3	humbugs
humic	12	41	1324	3	hu_mic
hummus	13	3	624	3	hummus
humour	11	11	675	3	humour
humus	10	62	1507	3	hu_mus
jubbah	20	3	435	3	jubbah
jumbuck	24	4	327	3	jumbuck
kebbuck	16	4	292	3	kebbuck
lubber	10	42	1462	3	lubber
lubric	10	9	798	3	lubric
mucluc	12	4	505	3	mucluc
mudbug	12	4	325	3	mudbug
nubbin	10	30	829	3	nubbin
nubble	10	38	1371	3	nubble
nubbly	13	36	967	3	nubbly
nubby	12	50	1103	3	nubb_y
nubuck	14	3	454	3	nu_buck
outbuy	11	4	694	3	outbuy
pubic	11	45	1372	3	pu_bic
public	12	23	814	3	public
rubbed	11	45	1508	3	rubbed
rubber	10	47	1579	3	rubber
rubble	10	43	1567	3	rubble
rubbly	13	37	1061	3	rubbly
rubby	12	44	1386	3	rubb_y
rubout	8	3	1356	3	rubout
rubric	10	9	782	3	rubric
rubus	7	64	1506	3	ru_bus
subbed	11	41	1667	3	subbed
subduce	12	10	698	3	subduce
subduct	12	10	758	3	subduct
subdue	9	12	849	3	subdue
subfusc	14	4	433	3	subfusc
subgum	11	3	613	3	subgum
tubbed	11	47	1222	3	tubbed
tubber	10	43	1320	3	tubber
tubby	12	45	1140	3	tubb_y
tubful	11	3	668	3	tubful

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.406	440125.6
2	DLD Change Limit	112716	76	5.533	20371.6
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	5.969	29936.5