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

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

63 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
birches	14	34	1232	(None)
birched	15	34	991	1	birched
birchen	14	34	788	1	birchen
bitches	14	41	1706	1	bitches
aitches	12	30	1436	2	aitches
arches	11	48	2204	2	_arches
baches	13	54	2694	2	b_aches
batches	14	40	1961	2	batches
beaches	14	41	2065	2	beaches
beeches	14	34	1388	2	beeches
belches	14	35	1434	2	belches
benches	14	39	1860	2	benches
bices	9	50	2996	2	bi_c_es
birch	12	49	1402	2	birch__
birdies	10	40	1621	2	birdies
biremes	11	3	877	2	biremes
birkies	13	37	1243	2	birkies
birles	8	49	2064	2	bir_les
birses	8	47	1773	2	bir_ses
birthed	13	22	859	2	birthed
births	11	57	1360	2	birth_s
bitched	15	32	1292	2	bitched
bitchen	14	34	973	2	bitchen
boches	13	46	1852	2	b_oches
borsches	15	3	600	2	borsches
botches	14	37	1602	2	botches
braches	14	46	2122	2	braches
brioches	15	22	725	2	brioches
britches	15	27	868	2	britches
bunches	14	41	1603	2	bunches
butches	14	43	1536	2	butches
cinches	14	42	1577	2	cinches
circles	11	3	990	2	circles
curches	14	35	1274	2	curches
ditches	13	32	1571	2	ditches
fiches	14	52	1953	2	fi_ches
filches	15	34	1072	2	filches
finches	15	39	1419	2	finches
fitches	15	35	1619	2	fitches
girshes	11	24	829	2	girshes
hitches	15	36	1627	2	hitches
inches	11	44	1967	2	_inches
itches	11	49	1621	2	_itches
kirsches	17	4	384	2	kirsches
larches	12	44	1644	2	larches
liches	11	47	2429	2	li_ches
lurches	12	33	1166	2	lurches
marches	14	39	2117	2	marches
merches	14	40	1376	2	merches
miches	13	43	2073	2	mi_ches
niches	11	44	1914	2	ni_ches
parches	14	37	2000	2	parches
perches	14	37	1795	2	perches
pinches	14	41	1793	2	pinches
pitches	14	36	1775	2	pitches
porches	14	38	1567	2	porches
riches	11	50	2208	2	ri_ches
smirches	15	3	599	2	smirches
torches	12	37	1543	2	torches
wiches	14	44	1875	2	wi_ches
winches	15	47	1437	2	winches
witches	15	27	1579	2	witches
zilches	21	32	630	2	zilches

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	63	3.156	34116.3
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	3.545	50406.5