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

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

82 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
dottrels	9	6	349	(None)
dottels	8	32	778	1	dott_els
dotterels	10	4	390	1	dotterels
dottrel	8	3	446	1	dottrel_
costrels	10	3	893	2	costrels
doggrels	11	4	263	2	doggrels
dottel	7	36	1089	2	dott_el_
dotterel	9	4	506	2	dotterel_
dotters	8	37	1597	2	dott_ers
dottles	8	39	1228	2	dottle_s
poitrels	10	3	524	2	poitrels
boatels	9	35	1023	3	boat_els
botels	8	48	1580	3	bo_t_els
bottlers	10	38	1001	3	bottlers
bottles	9	42	1627	3	bottle_s
buttress	10	3	588	3	buttress
coistrels	11	4	526	3	coistrels
controls	10	3	1139	3	controls
costrel	9	3	1037	3	costrel_
cotters	9	43	2344	3	cott_ers
cottiers	10	39	915	3	cottiers
dioptres	11	4	611	3	dioptre_s
distress	9	3	1171	3	distress
ditties	8	31	1698	3	dittie_s
doggerels	12	5	215	3	doggerels
doggrel	10	3	388	3	doggrel_
dogtrots	10	4	469	3	dogtrots
donzels	17	3	539	3	do_nzels
dorsels	8	44	1257	3	do_rsels
dossels	8	55	1160	3	do_ssels
dotages	9	23	1179	3	dotage_s
dotardly	13	4	384	3	dotardly
dotards	9	3	725	3	dotar_ds
doters	7	44	2391	3	do_t_ers
dotes	6	58	3669	3	do_t_e_s
dotted	8	47	1752	3	dott_e_d
dotter	7	44	1934	3	dott_e_r
dottier	8	39	1092	3	dottie_r
dottiest	9	26	1139	3	dottiest
dottily	11	4	728	3	dott_ily
dottiness	10	5	804	3	dottiness
dottle	7	42	1250	3	dott__le
dowels	10	48	1334	3	do__wels
fortress	11	3	675	3	fortress
goitres	8	38	956	3	goitre_s
gomerels	11	4	456	3	gomerels
hostels	10	37	1231	3	host_els
hotels	9	45	1551	3	ho_t_els
hotpress	13	4	430	3	hotpress
hotties	10	30	1696	3	hottie_s
jotters	14	34	1380	3	jott_ers
kestrels	12	3	581	3	kestrels
lotters	7	39	2106	3	lott_ers
lottes	6	53	2275	3	lott_e_s
mattress	10	3	653	3	mattress
mongrels	11	3	533	3	mongrels
morels	8	48	2001	3	mo__rels
motels	8	36	1689	3	mo_t_els
mottes	8	55	2369	3	mott_e_s
mottlers	10	38	818	3	mottlers
mottles	9	34	1580	3	mottle_s
mottoes	9	34	1219	3	mottoe_s
nostrils	8	4	818	3	nostrils
otters	6	40	2151	3	_ott_ers
petrels	9	27	937	3	_petrels
peytrels	13	6	337	3	peytrels
poitrel	9	3	619	3	poitrel_
portress	10	3	832	3	portress
potteens	10	25	679	3	potteens
potterers	11	21	866	3	potterers
potters	9	40	2434	3	pott_ers
potties	9	37	2354	3	pottie_s
pottles	9	38	1698	3	pottle_s
rotters	7	44	2139	3	rott_ers
rottes	6	45	2483	3	rott_e_s
sorels	6	39	2116	3	so__rels
sorrels	7	3	1072	3	so_rrels
totterers	9	18	681	3	totterers
totters	7	46	1873	3	tott_ers
votaress	11	4	422	3	votaress
votress	10	3	548	3	vo_tress
wastrels	11	3	620	3	wastrels

Search took 8 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.420	425454.8
2	DLD Change Limit	146162	82	7.440	19645.4
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.890	22647.8