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

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

45 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
mothier	12	19	1021	(None)
mother	11	37	1864	1	moth_er
motlier	9	20	1058	1	motlier
mouthier	13	20	817	1	mouthier
mythier	15	12	518	1	mythier
botchier	15	28	714	2	botchier
bother	11	52	1806	2	both_er
bothies	12	4	1478	2	bothies
clothier	13	3	536	2	clothier
cottier	9	38	1417	2	cottier
couthier	13	21	891	2	couthier
dotier	7	39	1703	2	dot_ier
dottier	8	39	1092	2	dottier
frothier	14	3	595	2	frothier
lathier	10	3	1083	2	lathier
luthier	10	3	823	2	luthier
matier	8	43	2152	2	mat_ier
meshier	12	34	1085	2	meshier
metier	8	35	1769	2	met_ier
mither	11	42	1856	2	mith_er
mitier	8	36	2067	2	mit_ier
moldier	10	31	1003	2	moldier
moodier	10	32	1220	2	moodier
moonier	9	37	1410	2	moonier
moorier	9	31	1307	2	moorier
mopier	10	39	1478	2	mo_pier
mosher	11	47	1979	2	mosh_er
mossier	9	44	1381	2	mossier
mothers	12	37	1762	2	moth_ers
mothery	15	37	1051	2	moth_ery
mothiest	13	3	1103	2	mothiest
mottler	9	44	1034	2	mottler
mousier	9	37	1246	2	mousier
mouther	12	38	1281	2	mouth_er
mushier	12	38	1359	2	mushier
nother	9	38	1596	2	noth_er
other	8	42	1910	2	_oth_er
pithier	12	30	1029	2	pithier
pother	11	38	1885	2	poth_er
pottier	9	35	1649	2	pottier
smother	12	35	1021	2	smoth_er
toothier	11	3	642	2	toothier
tother	9	41	1714	2	toth_er
withier	13	29	1049	2	withier
worthier	14	3	671	2	worthier

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.406	440125.6
2	DLD Change Limit	107671	45	3.546	30364.1
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	3.968	45033.0