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

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

66 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
loather	10	37	1100	(None)
lather	9	51	2435	1	l_ather
leather	10	38	1578	1	leather
loathe	9	42	1138	1	loathe_
loathed	11	41	944	1	loathed
loathers	11	33	1044	1	loathers
loathes	10	35	1324	1	loathes
bather	11	53	2251	2	_bather
blather	12	53	1420	2	blather
bloater	9	40	1342	2	bloat_er
boater	8	46	2209	2	boat_er
bother	11	52	1806	2	bo_ther
coacher	14	37	1412	2	coacher
coater	8	43	2957	2	coat_er
couther	12	39	1463	2	couther
father	12	51	1671	2	_father
feather	13	36	1350	2	feather
floater	10	44	1335	2	float_er
floatier	11	3	698	2	floatier
gather	10	41	1585	2	_gather
gloater	8	37	1101	2	gloat_er
goatherd	13	3	526	2	goatherd
heather	13	39	1485	2	heather
lasher	9	48	2453	2	l_asher
later	5	48	4392	2	l_at_er
lathe	8	56	2671	2	l_athe_
lathed	10	47	1845	2	l_athed
lathers	10	43	2188	2	l_athers
lathery	13	39	1112	2	l_athery
lathes	9	51	2749	2	l_athes
lathier	10	3	1083	2	l_athier
latter	6	50	2789	2	l_atter
leacher	12	40	1484	2	leacher
leathern	11	39	891	2	leathern
leathers	11	42	1508	2	leathers
leathery	14	43	897	2	leathery
lither	9	45	2095	2	l_ither
loaches	12	36	1398	2	loaches
loader	7	43	1631	2	loa_der
loafer	9	36	1094	2	loa_fer
loamier	9	34	916	2	loamier
loaner	6	44	1650	2	loa_ner
loath	8	49	1860	2	loath__
loathly	13	3	471	2	loathly
locater	9	31	1360	2	locat_er
lofter	9	46	1472	2	loft_er
loftier	10	3	776	2	loftier
loiter	6	46	1917	2	loit_er
looter	6	42	2232	2	loot_er
lotter	6	40	2560	2	lo_tter
mother	11	37	1864	2	mo_ther
mouther	12	38	1281	2	mouther
norther	10	3	973	2	norther
nother	9	38	1596	2	no_ther
oater	5	54	3373	2	_oat_er
other	8	42	1910	2	_o_ther
pleather	13	5	665	2	pleather
poacher	14	39	1232	2	poacher
pother	11	38	1885	2	po_ther
rather	9	43	1974	2	_rather
slather	10	38	1607	2	slather
soother	10	42	1504	2	soother
souther	10	41	1630	2	souther
swather	13	42	1360	2	swather
tother	9	41	1714	2	to_ther
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.376	475242.0
2	DLD Change Limit	107671	66	3.313	32499.5
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	3.719	48048.1