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

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

87 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
bleater	9	45	1530	(None)
beater	8	47	2939	1	b_eater
bleaker	13	35	1053	1	bleaker
bleated	10	40	1597	1	bleated
bleaters	10	34	1232	1	bleaters
bloater	9	40	1342	1	bloater
pleater	9	39	1633	1	pleater
alerter	7	21	1151	2	alerter
beader	9	46	2379	2	b_eader
beaker	12	55	2069	2	b_eaker
bearer	8	53	2391	2	b_earer
beaten	8	46	1706	2	b_eaten
beaters	9	49	2504	2	b_eaters
beaver	11	48	1925	2	b_eaver
belated	10	35	2001	2	belated
belayer	12	33	950	2	belayer
belter	8	47	2096	2	b_elter
better	8	47	2370	2	b_etter
blader	9	36	1858	2	bl_ader
blamer	10	44	1714	2	bl_amer
blaster	9	40	1730	2	blaster
blate	7	59	3378	2	bl_ate_
blather	12	53	1420	2	bl_ather
blatter	9	44	1565	2	blatter
blazer	17	44	1402	2	bl_azer
bleacher	15	35	888	2	bleacher
blear	7	59	1868	2	blea__r
bleared	10	42	1125	2	bleared
blearier	10	3	733	2	blearier
bleat	7	57	3700	2	bleat__
bleats	8	55	1861	2	bleat_s
bleeder	10	35	964	2	bleeder
bleeper	11	45	825	2	bleeper
blender	10	46	1384	2	blender
blesser	9	32	929	2	blesser
blether	12	45	991	2	blether
blister	9	44	1531	2	blister
bloated	10	45	1343	2	bloated
bloaters	10	33	1102	2	bloaters
blotter	9	46	1285	2	blotter
blunter	9	45	1203	2	blunter
blurter	9	41	983	2	blurter
bluster	9	42	1531	2	bluster
boater	8	46	2209	2	b_oater
breaker	13	39	1292	2	breaker
breather	13	36	1059	2	breather
cheater	12	48	1696	2	cheater
cleaner	9	37	1230	2	cleaner
clearer	9	37	1082	2	clearer
cleated	10	34	1784	2	cleated
cleaver	12	41	1080	2	cleaver
eater	5	46	3984	2	__eater
elater	6	47	2420	2	el_ater
feater	9	52	2405	2	_feater
fleeter	10	32	1036	2	fleeter
floater	10	44	1335	2	floater
gleamer	10	32	851	2	gleamer
gleaner	8	37	977	2	gleaner
gloater	8	37	1101	2	gloater
greater	8	44	1649	2	greater
heater	9	48	2830	2	_heater
later	5	48	4392	2	_l_ater
leader	7	48	2465	2	_leader
leaker	10	46	2007	2	_leaker
leaner	6	40	2219	2	_leaner
leaper	8	81	1894	2	_leaper
leaser	6	53	2267	2	_leaser
leather	10	38	1578	2	_leather
leaver	9	43	2151	2	_leaver
lefter	9	36	1343	2	_lefter
letter	6	37	2258	2	_letter
neater	6	44	2431	2	_neater
oleaster	8	3	726	2	oleaster
oleate	6	3	1888	2	oleate_
oleates	7	4	1783	2	oleates
plater	8	44	2769	2	pl_ater
pleader	10	35	1175	2	pleader
pleaser	9	39	1234	2	pleaser
pleated	10	38	1663	2	pleated
pleaters	10	36	1379	2	pleaters
pleather	13	5	665	2	pleather
relater	7	37	2314	2	relater
seater	6	45	3415	2	_seater
slater	6	44	2918	2	sl_ater
sweater	10	37	1272	2	sweater
theater	10	40	1425	2	theater
treater	7	42	1983	2	treater

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.126	1418182.5
2	DLD Change Limit	107671	87	2.873	37476.9
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	3.032	58935.0