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

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

81 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
blather	12	53	1420	(None)
bather	11	53	2251	1	b_ather
blathers	13	47	1379	1	blathers
blatter	9	44	1565	1	blatter
blether	12	45	991	1	blether
blither	12	48	1217	1	blither
lather	9	51	2435	1	_lather
slather	10	38	1607	1	slather
basher	11	51	2381	2	b_asher
batcher	14	44	1485	2	b_atcher
bathe	10	58	2288	2	b_athe_
bathed	12	55	1874	2	b_athed
bathers	12	47	2036	2	b_athers
bathes	11	65	2483	2	b_athes
batter	8	49	2887	2	b_atter
beater	8	47	2939	2	beat_er
blabber	10	41	892	2	blabber
blacker	15	45	1351	2	blacker
bladder	11	42	915	2	bladder
blader	9	36	1858	2	bla_der
blamer	10	44	1714	2	bla_mer
blancher	15	33	863	2	blancher
blander	10	37	1516	2	blander
blanker	13	46	1202	2	blanker
blaster	9	40	1730	2	blaster
blastier	10	24	949	2	blastier
blate	7	59	3378	2	blat_e_
blathered	15	16	835	2	blathered
blatherer	14	17	671	2	blatherer
blatted	10	48	1271	2	blatted
blatters	10	44	1409	2	blatters
blazer	17	44	1402	2	bla_zer
bleacher	15	35	888	2	bleacher
bleater	9	45	1530	2	bleat_er
blethers	13	42	961	2	blethers
blithe	11	58	1086	2	blithe_
blithers	13	47	1123	2	blithers
blitzer	18	44	766	2	blitzer
bloater	9	40	1342	2	bloat_er
blotter	9	46	1285	2	blotter
blucher	14	33	1022	2	blucher
blusher	12	41	1311	2	blusher
boater	8	46	2209	2	boat_er
bother	11	52	1806	2	b_other
brasher	12	45	1524	2	brasher
breather	13	36	1059	2	breather
brother	12	33	1133	2	brother
clasher	12	46	1551	2	clasher
clatter	9	40	1497	2	clatter
elater	6	47	2420	2	elat_er
father	12	51	1671	2	_father
feather	13	36	1350	2	feather
flasher	13	39	1406	2	flasher
flatter	10	38	1596	2	flatter
gather	10	41	1585	2	_gather
heather	13	39	1485	2	heather
lasher	9	48	2453	2	_lasher
later	5	48	4392	2	_lat_er
lathe	8	56	2671	2	_lathe_
lathed	10	47	1845	2	_lathed
lathers	10	43	2188	2	_lathers
lathery	13	39	1112	2	_lathery
lathes	9	51	2749	2	_lathes
lathier	10	3	1083	2	_lathier
latter	6	50	2789	2	_latter
leather	10	38	1578	2	leather
lither	9	45	2095	2	_lither
loather	10	37	1100	2	loather
plasher	12	42	1503	2	plasher
plater	8	44	2769	2	plat_er
platier	9	37	1629	2	platier
platter	9	39	1741	2	platter
pleather	13	5	665	2	pleather
rather	9	43	1974	2	_rather
slasher	10	45	1533	2	slasher
slater	6	44	2918	2	slat_er
slathers	11	39	1478	2	slathers
slatier	7	40	1681	2	slatier
slither	10	41	1298	2	slither
swather	13	42	1360	2	swather
weather	13	35	1322	2	weather

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.356	501941.0
2	DLD Change Limit	107671	81	3.266	32967.2
3	Display Results	81	81	0.016	5062.5
	(SQL Overall)	178691	81	3.638	49117.9