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

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

86 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
bombes	12	49	1682	(None)
bombe	11	55	1931	1	bombe_
bombed	13	41	1387	1	bombed
bomber	12	50	1465	1	bomber
bombers	13	45	1259	1	bombers
bombs	11	58	1882	1	bomb_s
combes	12	53	2173	1	combes
babes	9	58	3411	2	b_abes
barbes	10	45	2623	2	barbes
bimboes	13	49	873	2	bimboes
bimbos	12	46	1052	2	bimbos
biomes	10	38	1525	2	biom_es
bobbed	10	43	1583	2	bobbed
bobber	9	50	1674	2	bobber
bobbers	10	36	1428	2	bobbers
bobbies	10	37	1456	2	bobbies
bobbles	10	45	1491	2	bobbles
bobs	8	63	4065	2	bo_b_s
bocces	12	39	1202	2	bocces
boches	13	46	1852	2	boches
bodes	8	49	3510	2	bo_des
bodies	9	45	2414	2	bodies
bogies	9	47	2431	2	bogies
bogles	9	50	2083	2	bogles
boites	8	43	2270	2	boites
boles	7	54	4860	2	bo_les
bomb	10	69	2742	2	bomb__
bombast	13	4	822	2	bombast
bombax	19	3	575	2	bombax
bombesin	14	4	423	2	bombesin
bomblet	13	4	1226	2	bomblet
bomblets	14	3	602	2	bomblets
bombyx	22	3	269	2	bombyx
bombyxes	24	4	260	2	bombyxes
bones	7	64	4653	2	bo_nes
bonnes	8	56	2145	2	bonnes
bonzes	17	51	1610	2	bonzes
boobed	11	45	1487	2	boobed
boobies	11	37	1820	2	boobies
boobs	9	62	2199	2	boob_s
boozes	17	49	1652	2	boozes
bores	7	64	4825	2	bo_res
boshes	11	47	2188	2	boshes
bosses	8	59	2540	2	bosses
boules	8	49	2597	2	boules
bouses	8	49	3178	2	bouses
bowses	11	57	1886	2	bowses
boxes	14	56	2507	2	bo_xes
bribes	10	59	1853	2	bribes
bromes	10	47	1976	2	brom_es
bumbles	13	40	1684	2	bumbles
combe	11	62	2354	2	combe_
combed	13	55	1654	2	combed
comber	12	51	1850	2	comber
combers	13	45	1662	2	combers
combos	12	53	1661	2	combos
combs	11	61	2296	2	comb_s
comes	9	72	4699	2	com_es
comtes	10	62	2281	2	comtes
coombes	13	38	1066	2	coombes
domes	8	57	3556	2	dom_es
gambes	11	63	1831	2	gambes
gombos	11	43	1109	2	gombos
hombres	14	36	987	2	hombres
homes	10	69	3881	2	hom_es
homies	11	45	2472	2	homies
jambes	17	59	1405	2	jambes
kombus	14	3	552	2	kombus
lobes	7	53	3100	2	lo_bes
momes	9	51	3447	2	mom_es
nombles	11	32	1234	2	nombles
nomes	7	49	3312	2	nom_es
obes	6	60	3683	2	_o_bes
omber	9	53	1644	2	_omber
ombers	10	42	1440	2	_ombers
ombres	10	39	1114	2	_ombres
pomes	9	48	3393	2	pom_es
robes	7	51	3330	2	ro_bes
somber	10	37	1399	2	somber
tombed	11	38	1213	2	tombed
tombs	9	78	1873	2	tomb_s
tomes	7	60	3738	2	tom_es
wombed	14	41	923	2	wombed
wombs	12	58	1334	2	womb_s
zombies	20	3	799	2	zombies
zombis	19	3	628	2	zombis

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.123	1452772.4
2	DLD Change Limit	82551	86	2.580	31996.5
3	Display Results	86	86	0.016	5375.0
	(SQL Overall)	178691	86	2.719	65719.4