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

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

71 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
mousier	9	37	1246	(None)
lousier	7	24	1162	1	lousier
mossier	9	44	1381	1	mossier
mouser	8	58	2244	1	mous_er
blousier	10	5	566	2	blousier
bossier	9	37	1242	2	bossier
bouvier	12	7	743	2	bouvier
busier	8	52	1972	2	_busier
cosier	8	44	2375	2	co_sier
courier	9	36	1787	2	courier
dossier	8	37	1169	2	dossier
douser	7	56	2163	2	dous_er
goosier	8	35	1256	2	goosier
gorsier	8	38	1107	2	gorsier
goutier	8	26	1235	2	goutier
horsier	10	30	1324	2	horsier
hosier	9	42	1961	2	ho_sier
houser	9	53	2228	2	hous_er
jouster	14	33	1104	2	jouster
massier	9	36	1522	2	massier
messier	9	34	1292	2	messier
mobster	11	29	921	2	mobster
moister	9	40	1537	2	moister
moldier	10	31	1003	2	moldier
momser	10	40	1141	2	moms_er
monsieur	10	4	331	2	monsieur
monster	9	32	1459	2	monster
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	mo_sher
mosser	8	46	1827	2	mo_sser
mothier	12	19	1021	2	mothier
motlier	9	20	1058	2	motlier
moulder	10	38	980	2	moulder
mouldier	11	5	495	2	mouldier
moulter	9	38	1242	2	moulter
mounter	9	37	1317	2	mounter
mourner	9	3	808	2	mourner
mouse	7	71	3300	2	mous_e_
moused	9	44	2330	2	mous_ed
mousers	9	52	1644	2	mous_ers
mouses	8	55	3142	2	mous_es
mousey	11	52	1619	2	mous_ey
mousiest	10	27	1176	2	mousiest
mousily	12	3	939	2	mousily
mousing	10	38	1627	2	mousing
mousse	8	48	1303	2	mousse_
moussed	10	33	891	2	moussed
mousses	9	40	1270	2	mousses
mouther	12	38	1281	2	mouther
mouthier	13	20	817	2	mouthier
muser	7	60	2412	2	m_us_er
musher	11	38	2057	2	m_usher
mushier	12	38	1358	2	m_ushier
muskier	13	43	1272	2	m_uskier
mussier	9	33	1435	2	mussier
muster	8	47	2452	2	m_uster
mustier	9	40	1795	2	m_ustier
noisier	7	5	945	2	noisier
nosier	6	37	1632	2	no_sier
osier	5	35	1801	2	_o_sier
ouster	6	42	2373	2	_ouster
poutier	9	32	1532	2	poutier
rosier	6	42	2126	2	ro_sier
roupier	9	31	949	2	roupier
rouser	6	52	2408	2	rous_er
rouster	7	35	1708	2	rouster
sonsier	7	7	1174	2	sonsier
soupier	9	31	1175	2	soupier

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.123	1452772.4
2	DLD Change Limit	107671	71	3.483	30913.3
3	Display Results	71	71	0.016	4437.5
	(SQL Overall)	178691	71	3.622	49334.9