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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

117 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
boycotters	17	4	192	(None)
boycotter	16	4	207	1	boycotter_
boycotted	17	4	203	2	boycotte_d
boycotts	15	4	309	2	boycott__s
blotters	10	41	1098	3	b__lotters
boosters	10	40	1345	3	bo__osters
boycott	14	5	731	3	boycott___
boycotting	18	4	263	3	boycotting
cocottes	12	3	831	3	co_cotte_s
concocters	13	4	676	3	concocters
cotters	9	43	2345	3	___cotters
accouters	13	4	487	4	_accouters
allotters	9	6	556	4	_allotters
balloters	11	5	767	4	ballo_ters
batters	9	46	2602	4	b___atters
bedcovers	17	8	356	4	bedco_vers
bedwetters	16	4	227	4	bedwetters
begetters	12	13	504	4	b_egetters
besetters	11	13	664	4	b_esetters
bespatters	14	4	278	4	bespatters
betatters	11	3	496	4	b_etatters
betters	9	44	2209	4	b___etters
bitters	9	49	2036	4	b___itters
blatters	10	44	1409	4	b__latters
bloaters	10	33	1102	4	b__loaters
blotter	9	46	1285	4	b__lotter_
boasters	10	39	1566	4	bo__asters
boaters	9	34	1924	4	b___oaters
boilovers	14	4	410	4	boilo_vers
bolometers	14	4	738	4	bolometers
bolsters	10	37	1245	4	bo__lsters
bolters	9	40	1780	4	b___olters
bombasters	16	4	371	4	bombasters
bonesetters	13	5	263	4	bonesetters
boodlers	11	37	1074	4	bo__odlers
boogers	10	45	1463	4	bo__o_gers
bookers	13	40	1661	4	bo__o_kers
boomers	11	41	1591	4	bo__o_mers
booster	9	43	1455	4	bo__oster_
bootees	9	41	1447	4	bo__o_tees
bootery	12	3	898	4	bo__o_tery
booties	9	41	2461	4	bo__otie_s
bootlegs	11	32	587	4	bo__otlegs
bootless	10	34	1098	4	bo__otless
boozers	18	39	1244	4	bo__o_zers
borrowers	14	7	403	4	borro_wers
botchers	15	35	1154	4	botc__hers
bothers	12	43	1775	4	b___others
bottlers	10	38	1001	4	bo__ttlers
bottomers	13	4	435	4	botto_mers
bowhunters	18	4	168	4	bowhunters
brothers	13	34	1083	4	b__rothers
butters	9	45	2172	4	b___utters
coaters	9	35	2579	4	___coaters
cocotte	11	3	860	4	co_cotte__
colcothars	17	5	191	4	colcothars
colters	9	35	2244	4	___colters
comforters	17	27	520	4	comforters
composters	16	38	833	4	composters
concenters	14	4	1059	4	concenters
concocter	12	4	763	4	concocter_
concoctors	13	4	641	4	concoctors
cooters	9	45	2573	4	___cooters
copters	11	36	2128	4	___copters
costers	9	41	2834	4	___costers
cottars	9	44	1224	4	___cottars
cotter	8	49	2667	4	___cotter_
cottiers	10	39	916	4	___cottiers
couters	9	38	2730	4	___couters
coyotes	12	4	1070	4	coy_o_te_s
cutters	9	42	1896	4	___cutters
dotters	8	37	1597	4	___dotters
footers	10	46	1833	4	fo__o_ters
footlers	11	39	1079	4	fo__otlers
forgetters	14	4	416	4	forgetters
formatters	15	4	457	4	formatters
garotters	10	5	504	4	_garotters
godmothers	17	5	263	4	godmothers
hooters	10	45	2048	4	ho__o_ters
jotters	14	34	1380	4	___jotters
joypoppers	23	6	152	4	joypoppers
keynoters	16	4	231	4	keyno_ters
knotters	12	27	615	4	__knotters
locaters	10	27	1007	4	lo_c_aters
looters	7	44	1916	4	lo__o_ters
lotters	7	39	2106	4	___lotters
mooters	9	38	1862	4	mo__o_ters
nonvoters	12	13	646	4	nonvo_ters
occulters	13	4	345	4	_occulters
omitters	10	27	765	4	_o_mitters
otters	6	40	2151	4	____otters
oysters	10	34	1169	4	_oy__sters
plotters	10	40	1155	4	__plotters
pocketers	17	19	649	4	po_cketers
poofters	13	3	692	4	po__ofters
potters	9	40	2434	4	___potters
rocketers	15	18	688	4	ro_cketers
roosters	8	35	1467	4	ro__osters
rooters	7	45	2293	4	ro__o_ters
rotters	7	44	2139	4	___rotters
roysters	11	36	1053	4	roy__sters
scatters	10	36	1275	4	__scatters
scooters	10	35	1103	4	__scooters
scoters	9	33	1381	4	__sco_ters
scouters	10	34	1132	4	__scouters
scutters	10	33	1102	4	__scutters
slotters	8	40	1240	4	__slotters
soothers	11	39	1343	4	so__others
spotters	10	43	1338	4	__spotters
swotters	11	44	848	4	__swotters
tooters	7	38	1877	4	to__o_ters
tootlers	8	28	950	4	to__otlers
totters	7	46	1873	4	___totters
trotters	8	33	1025	4	__trotters
vocoders	14	3	424	4	vo_co_ders
woodcutters	17	5	131	4	woodcutters
yatters	10	39	1462	4	__y_atters

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	161450	0.453	394461.4
2	DLD Change Limit	161450	117	9.376	17219.5
3	Display Results	117	117	0.060	1950.0
	(SQL Overall)	178691	117	9.889	18069.7