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

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

69 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
bizarres	19	5	379	(None)
bizarre	18	4	410	1	bizarre_
bizarros	19	4	271	1	bizarros
barres	8	44	2754	2	b__arres
binaries	10	3	1417	2	binaries
bizarrely	23	5	160	2	bizarrely
bizarro	18	4	333	2	bizarr_o
barbes	10	45	2623	3	b__arbes
bardes	9	50	2693	3	b__ardes
bares	7	54	5713	3	b__a_res
barges	9	45	2825	3	b__arges
barre	7	59	2954	3	b__arre_
barred	9	57	2579	3	b__arred
barrel	8	45	1787	3	b__arrel
barrels	9	45	1436	3	b__arrels
barren	8	53	1761	3	b__arren
barrens	9	44	1432	3	b__arrens
barret	8	49	3048	3	b__arret
barrets	9	49	1710	3	b__arrets
baryes	11	62	1850	3	b__aryes
bazaars	18	27	588	3	bazaar_s
bazars	17	46	1311	3	baza_r_s
bearers	9	46	1959	3	b_earers
bewares	12	3	1337	3	bewa_res
bezazzes	17	4	197	3	bezazzes
bialies	9	36	1841	3	bi_alies
biases	8	46	1843	3	bi_a_ses
biasses	9	49	1165	3	bi_asses
bicarbs	13	3	601	3	bica_rbs
bicornes	12	30	725	3	bicornes
bidarkas	15	4	336	3	bidarkas
bidarkee	15	4	458	3	bidarkee
bidarkees	16	4	214	3	bidarkees
bifaces	14	4	806	3	bifa_ces
bigamies	13	3	736	3	bigamies
bigarades	13	4	413	3	bigarades
bigarreau	12	5	176	3	bigarreau
bigarreaus	13	5	118	3	bigarreaus
bilayers	13	29	691	3	bilayers
biparous	12	4	692	3	biparous
biparted	13	3	513	3	biparted
birles	8	49	2064	3	bi__rles
birred	9	47	1320	3	bi__rred
birrs	7	49	1710	3	bi__rr_s
birses	8	47	1773	3	bi__rses
bistres	9	40	1721	3	bi_stres
bivalves	16	4	338	3	bivalves
bizarreness	22	5	173	3	bizarreness
bizarrerie	21	12	119	3	bizarrerie
bizarreries	22	14	157	3	bizarreries
bizes	16	59	2366	3	biz___es
bizones	18	3	782	3	biz_ones
bizzes	16	39	1084	3	biz__zes
blares	8	50	2163	3	b_la_res
diaries	8	33	2195	3	di_aries
fiacres	12	3	725	3	fi_acres
filarees	11	8	762	3	filarees
gisarmes	11	4	443	3	gisarmes
izars	14	51	1293	3	_iza_r_s
lizards	17	42	761	3	liza_rds
pizazzes	17	4	237	3	pizazzes
sizars	15	48	1262	3	siza_r_s
tarres	6	47	2304	3	__tarres
vivaries	14	3	926	3	vivaries
vizarded	22	4	275	3	vizarded
vizards	20	37	726	3	viza_rds
wizardries	23	5	127	3	wizardries
wizards	20	32	640	3	wiza_rds
zaires	15	3	970	3	__zaires

Search took 10 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	146162	0.156	1145455.1
2	DLD Change Limit	146162	69	8.970	16294.5
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	9.156	19516.3