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

Here are the results of your fuzzy-string dictionary search for “machinee” with Change Limit: [1] [2] [3] [4]

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.

74 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
machine	14	3	1349	1	machin_e
machined	16	3	730	1	machined
machines	15	3	1289	1	machines
machinate	16	4	795	2	machinate
machinery	19	4	309	2	machinery
machree	14	3	851	2	mach_ree
manchineel	17	5	211	2	manchineel
matinee	9	24	1561	2	ma_tinee
vaccinee	15	4	485	2	vaccinee
achene	11	3	1381	3	_achen_e
achenes	12	3	1349	3	_achenes
achier	11	39	1426	3	_achi_er
achieve	15	4	502	3	_achieve
achiness	13	3	970	3	_achiness
aching	12	65	2197	3	_achin_g
achiote	12	3	921	3	_achiote
archine	12	58	1705	3	archin_e
archines	13	38	1525	3	archines
baching	15	60	1775	3	bachin_g
caching	15	63	1750	3	cachin_g
chine	10	52	3172	3	__chin_e
chined	12	56	2006	3	__chined
chines	11	50	2917	3	__chines
kachina	16	3	766	3	kachin_a
kachinas	17	3	634	3	kachinas
macchie	16	4	719	3	macchi__e
mache	12	59	2530	3	mach___e
maches	13	48	2723	3	mach__es
machete	14	3	1088	3	mach_ete
machetes	15	3	963	3	machetes
machinable	19	4	426	3	machinable
machinated	18	4	566	3	machinated
machinates	17	4	732	3	machinates
machineable	20	5	217	3	machine~~abl~~e
machinelike	22	5	181	3	machine~~lik~~e
machineries	18	5	379	3	machineries
machining	17	4	693	3	machining
machinist	16	4	848	3	machinist
machismo	17	5	420	3	machismo
machrees	15	4	550	3	machrees
macing	11	42	2155	3	mac_in_g
mackinaw	19	4	310	3	mackinaw
maline	8	45	2908	3	ma_lin_e
malines	9	36	2560	3	ma_lines
manchineels	18	5	125	3	manchineels
marching	16	43	1219	3	marchin_g
margined	12	3	774	3	margined
marine	8	42	3040	3	ma_rin_e
mariner	9	33	1599	3	ma_riner
marines	9	39	2801	3	ma_rines
marline	9	33	2095	3	marlin_e
marlines	10	38	1871	3	marlines
martinet	10	3	1964	3	martinet
mashie	11	3	1593	3	mashi__e
mashies	12	3	1825	3	mashi_es
mashing	13	44	2224	3	mashin_g
matching	16	35	1239	3	matchin_g
matinees	10	21	1042	3	ma_tinees
miching	15	29	1180	3	michin_g
pachinko	19	4	230	3	pachinko
rachides	14	15	1122	3	rachides
rachises	13	14	1241	3	rachises
tachinid	14	4	624	3	tachinid
tachisme	15	5	469	3	tachisme
tachiste	13	5	621	3	tachiste
tacrine	9	3	1129	3	tacrin_e
tacrines	10	3	1056	3	tacrines
vaccine	14	3	732	3	vaccin_e
vaccinees	16	4	284	3	vaccinees
vaccines	15	3	650	3	vaccines
vahine	12	36	1211	3	va_hin_e
vahines	13	34	1052	3	va_hines
wahine	12	38	1301	3	wa_hin_e
wahines	13	31	1117	3	wa_hines

Search took 8 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	146162	0.436	409841.7
2	DLD Change Limit	146162	74	7.410	19725.0
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	7.876	22688.0