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

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

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
bezazz	15	4	398	(None)
begaze	18	3	833	2	begaze
bezant	17	8	1454	2	bezant
bezazzes	17	4	197	2	bezazzes
pazazz	15	5	402	2	pazazz
pizazz	15	5	422	2	pizazz
bazaar	17	30	640	3	bazaar
bazar	16	38	1600	3	baza_r
bazars	17	46	1311	3	bazars
beach	12	46	2389	3	be_ach
bead	7	59	3792	3	be_a_d
beads	8	54	2950	3	be_ads
beady	11	47	1992	3	be_ady
beak	10	65	3438	3	be_a_k
beaks	11	53	2662	3	be_aks
beaky	14	61	1802	3	be_aky
beam	8	69	3923	3	be_a_m
beams	9	53	2817	3	be_ams
beamy	12	62	1857	3	be_amy
bean	6	64	4386	3	be_a_n
beano	7	54	2155	3	be_ano
beans	7	57	3469	3	be_ans
bear	6	68	4464	3	be_a_r
beard	8	60	2496	3	be_ard
bears	7	57	3904	3	be_ars
beast	7	63	3864	3	be_ast
beat	6	61	6830	3	be_a_t
beats	7	60	4224	3	be_ats
beau	6	61	3727	3	be_a_u
beaus	7	51	2711	3	be_aus
beaut	7	51	3521	3	be_aut
beaux	14	65	1321	3	be_aux
becalm	12	3	920	3	becalm
became	12	32	1316	3	became
becap	11	43	1505	3	beca_p
becaps	12	38	1140	3	becaps
bedamn	11	3	781	3	bedamn
bedaub	11	4	603	3	bedaub
bedazzle	19	4	214	3	bedazzle
befall	11	44	1064	3	befall
begall	9	26	1072	3	begall
began	8	63	1957	3	bega_n
begat	8	66	2972	3	bega_t
begazed	20	3	620	3	begazed
begazes	19	3	796	3	begazes
behalf	14	3	1095	3	behalf
behave	14	20	901	3	behave
belady	12	48	993	3	belady
belaud	9	3	913	3	belaud
belay	10	50	2152	3	bela_y
belays	11	43	1385	3	belays
bema	8	58	2525	3	bema__
bemas	9	64	2428	3	bema_s
bemata	10	4	1169	3	bemata
bename	10	33	1607	3	bename
benzal	17	3	964	3	benza_l
berake	12	42	1608	3	berake
berate	8	47	2902	3	berate
beta	6	62	3413	3	beta__
betake	12	45	1270	3	betake
betas	7	55	2876	3	beta_s
bewail	11	8	958	3	bewail
beware	11	3	1371	3	beware
bezants	18	7	734	3	bezants
bezel	16	52	1517	3	bez_el
bezels	17	37	1228	3	bezels
bezil	16	38	1288	3	bez_il
bezils	17	113	1060	3	bezils
bezoar	17	3	691	3	bezoar
bezoars	18	3	679	3	bezoars
bezzant	17	4	689	3	bezzant
blaze	16	55	2083	3	b_laze
braza	16	52	1425	3	b_raza
braze	16	54	2345	3	b_raze
buzz	14	66	1780	3	b__uzz
byzant	20	9	681	3	byzant
feaze	17	52	1631	3	fe_aze
fezzy	19	98	1145	3	fez_zy
jazz	19	37	1446	3	__jazz
jezail	22	3	464	3	jezail
lezzy	16	60	808	3	lez_zy
mezuza	16	4	353	3	mezuza
mezzo	15	3	743	3	mez_zo
pizazzy	19	5	224	3	pizazzy
pizzaz	15	6	544	3	pizzaz
pizzazz	0	24	302	3	pizzazz
razz	12	52	1942	3	__razz
spazz	15	58	1113	3	_spazz
zzz	10	179	1191	3	__z_zz

Search took 7 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.140	1276364.3
2	DLD Change Limit	112716	89	6.656	16934.5
3	Display Results	89	89	0.033	2697.0
	(SQL Overall)	178691	89	6.829	26166.5