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

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

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.

71 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
southerlies	14	5	327	(None)
northerlies	14	7	344	2	northerlies
smitheries	15	4	605	3	smither_ies
southerly	15	4	418	3	southerl__y
southernness	15	5	248	3	southernness
southerns	12	34	721	3	souther__ns
southers	11	42	1445	3	souther___s
superlies	11	3	1455	3	s_u_perlies
booteries	11	3	1277	4	boot_er_ies
botcheries	17	4	605	4	botcher_ies
butcheries	17	4	507	4	_butcher_ies
butleries	11	7	1007	4	_butler_ies
butterflies	16	5	265	4	_butterflies
butteries	11	7	1176	4	_butter_ies
cauteries	11	6	1539	4	caut_er_ies
coteries	10	4	2270	4	co_t_er_ies
cutcheries	17	4	508	4	_cutcher_ies
cutleries	11	7	921	4	_cutler_ies
diathermies	17	5	326	4	diathermies
easterlies	10	4	671	4	east_erlies
gaucheries	16	4	453	4	gaucher_ies
hostelries	13	4	542	4	host_elries
hourlies	11	3	834	4	hou___rlies
houseflies	16	4	475	4	hou_seflies
isotheres	12	4	633	4	iso_ther__es
lotteries	9	3	1107	4	lo_tter_ies
monthlies	14	4	651	4	month__lies
motherless	15	4	409	4	mo_therless
motherliness	17	5	308	4	mo_therliness
mouthers	13	38	1130	4	mouther___s
orderlies	10	4	545	4	_o_rderlies
otherwise	15	10	320	4	_o_therwise
outbullies	12	4	310	4	_outbullies
outcries	10	3	1357	4	_out_cr_ies
outflies	11	3	1015	4	_out__flies
outlies	7	24	2199	4	_out___lies
outserves	12	14	737	4	_outser_ves
outwearies	13	4	535	4	_outwearies
overlies	11	24	1704	4	_o__verlies
potbellies	14	4	339	4	po_tbellies
potteries	11	3	1359	4	po_tter_ies
roughdries	15	5	268	4	roughdr_ies
sauternes	9	4	702	4	saut_er_nes
scouthered	16	4	364	4	scouther__ed
scouthering	17	4	348	4	scouther_ing
scouthers	14	4	599	4	scouther___s
sculleries	12	4	483	4	sculler_ies
sherries	11	18	1289	4	s___herries
shutterless	14	5	213	4	shutterless
snuggeries	12	9	384	4	snugger_ies
soapberries	15	5	275	4	soapberries
soldieries	11	4	559	4	soldier_ies
soothers	11	39	1343	4	soother___s
sorceries	11	4	993	4	so_rcer_ies
souters	7	44	2260	4	sout_er___s
southeaster	14	5	363	4	southeaster
southeasters	15	5	330	4	southeasters
southeasts	13	4	423	4	southe_asts
souther	10	41	1630	4	souther____
southern	11	43	891	4	souther___n
southernmost	17	6	149	4	southernmost
southrons	12	4	584	4	south_r_ons
sowbellies	15	4	284	4	so_wbellies
steelies	8	3	1255	4	s__t_eelies
stitcheries	16	5	307	4	stitcher_ies
subseries	11	3	1293	4	s_ubser_ies
superlie	10	3	1212	4	s_u_perlie_
surgeries	10	3	1136	4	s_urger_ies
tusheries	12	4	689	4	_tusher_ies
underlies	10	14	1420	4	__underlies
westerlies	13	4	561	4	west_erlies

Search took 9 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	148819	0.406	440125.6
2	DLD Change Limit	148819	71	8.263	18010.3
3	Display Results	71	71	0.033	2151.5
	(SQL Overall)	178691	71	8.702	20534.5