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

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

56 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
boarder	10	39	1032	(None)
boarded	11	39	1050	1	boarded
boarders	11	40	862	1	boarders
border	9	44	1997	1	bo_rder
hoarder	11	32	923	1	hoarder
awarder	11	3	589	2	awarder
badder	10	38	1751	2	b_adder
balder	9	53	1886	2	b_alder
bander	9	39	2822	2	b_ander
barber	10	44	1932	2	b_arber
barde	8	53	3077	2	b_arde_
barded	10	54	2642	2	b_arded
bardes	9	50	2693	2	b_ardes
barer	7	45	3580	2	b_ar_er
barker	12	48	2286	2	b_arker
barter	8	55	2537	2	b_arter
beader	9	46	2379	2	bea_der
bearded	11	42	1213	2	bearded
bearer	8	53	2391	2	bear_er
birder	9	49	1549	2	b_irder
bladder	11	42	915	2	bladder
blader	9	36	1858	2	bla_der
blander	10	37	1516	2	blander
board	8	55	2300	2	board__
boardmen	13	4	407	2	boardmen
boards	9	46	1693	2	board_s
boaster	9	46	1643	2	boaster
boater	8	46	2209	2	boa_ter
bolder	9	48	2093	2	bo_lder
bombarder	16	14	358	2	bombarder
bonder	9	53	2478	2	bo_nder
bordel	9	45	1457	2	bo_rdel
borders	10	43	1753	2	bo_rders
borer	7	51	3127	2	bo_r_er
boulder	10	34	1134	2	boulder
bounder	10	42	1553	2	bounder
bowlder	13	40	748	2	bowlder
braider	10	51	1299	2	braider
brander	10	39	1582	2	brander
broader	10	34	1261	2	broa_der
carder	9	45	2418	2	_carder
coarser	9	32	1120	2	coarser
corder	9	43	2288	2	co_rder
guarder	9	3	646	2	guarder
harder	10	50	2240	2	_harder
hoarded	12	36	834	2	hoarded
hoarders	12	30	743	2	hoarders
hoarier	10	42	1174	2	hoarier
hoarser	10	38	839	2	hoarser
larder	7	37	2097	2	_larder
loader	7	43	1631	2	loa_der
order	6	50	1936	2	_o_rder
roarer	6	39	1433	2	roar_er
soarer	6	45	2224	2	soar_er
warder	10	40	2027	2	_warder
yarder	10	38	1397	2	_yarder

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.390	458182.1
2	DLD Change Limit	107671	56	3.330	32333.6
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	3.750	47650.9