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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

214 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
fitchew	18	27	680	(None)
fitchee	15	27	1078	1	fitchee
fitches	15	35	1619	1	fitches
fitchet	15	31	1356	1	fitchet
fitchews	19	27	477	1	fitchews
aitches	12	30	1436	2	aitches
bitched	15	32	1292	2	bitched
bitchen	14	34	973	2	bitchen
bitches	14	41	1706	2	bitches
ditched	14	37	1190	2	ditched
ditcher	13	40	1200	2	ditcher
ditches	13	32	1571	2	ditches
fetched	16	37	1047	2	fetched
fetcher	15	35	1039	2	fetcher
fetches	15	34	1389	2	fetches
fiche	13	46	1674	2	fi_che_
fiches	14	52	1953	2	fi_ches
filched	16	30	742	2	filched
filcher	15	37	779	2	filcher
filches	15	34	1072	2	filches
finches	15	39	1419	2	finches
fitch	13	48	1687	2	fitch__
fitchets	16	30	741	2	fitchets
fitchy	17	43	762	2	fitch_y
flitched	17	25	629	2	flitched
flitches	16	38	846	2	flitches
hitched	16	33	1225	2	hitched
hitcher	15	37	1200	2	hitcher
hitches	15	36	1627	2	hitches
itched	12	38	1202	2	_itched
itches	11	49	1621	2	_itches
kitchen	16	28	768	2	kitchen
pitched	15	35	1292	2	pitched
pitcher	14	38	1371	2	pitcher
pitches	14	36	1775	2	pitches
witched	16	30	1219	2	witched
witches	15	27	1579	2	witches
aircrew	12	11	391	3	aircrew
aitch	10	52	1616	3	aitch__
batched	15	41	1424	3	batched
batcher	14	44	1485	3	batcher
batches	14	40	1961	3	batches
birched	15	34	991	3	birched
birchen	14	34	788	3	birchen
birches	14	34	1232	3	birches
bitch	12	50	1776	3	bitch__
bitchery	18	23	656	3	bitchery
bitchier	15	30	773	3	bitchier
bitchy	16	47	920	3	bitch_y
botched	15	36	1190	3	botched
botcher	14	36	1322	3	botcher
botches	14	37	1602	3	botches
britches	15	27	868	3	britches
butcher	14	34	1116	3	butcher
butches	14	43	1536	3	butches
catcher	14	31	1582	3	catcher
catches	14	43	2077	3	catches
chew	12	66	2213	3	___chew
cinched	15	39	1086	3	cinched
cinches	14	42	1577	3	cinches
cither	11	46	1668	3	cit_her
cutches	14	32	1646	3	cutches
ditch	11	50	1509	3	ditch__
ditchers	14	36	1036	3	ditchers
dither	10	44	1768	3	dit_her
either	9	45	1742	3	eit_her
eschew	14	3	633	3	_eschew
etched	12	36	1370	3	_etched
etcher	11	39	1294	3	_etcher
etches	11	42	1776	3	_etches
faithed	14	3	716	3	fait_hed
father	12	51	1671	3	fat_her
fetch	13	49	1347	3	fetch__
fetchers	16	32	886	3	fetchers
fetiches	16	3	695	3	fetiches
fiacre	11	3	762	3	fiacre_
fiacres	12	3	725	3	fiacres
fice	9	57	3711	3	fi_c_e_
fices	10	60	3116	3	fi_c_es
fichu	13	48	1066	3	fi_ch_u
fichus	14	38	811	3	fi_chus
ficoes	11	46	1346	3	fi_coes
filch	13	48	1332	3	filch__
filchers	16	28	686	3	filchers
finch	13	54	1697	3	finch__
fished	13	43	1631	3	fi_shed
fisher	12	49	1714	3	fi_sher
fishes	12	52	2134	3	fi_shes
fitted	10	47	1666	3	fit_ted
fitter	9	41	2003	3	fit_ter
fleche	14	29	930	3	fleche_
fleches	15	34	1144	3	fleches
fletched	17	30	669	3	fletched
fletcher	16	30	666	3	fletcher
fletches	16	30	885	3	fletches
flinched	17	31	670	3	flinched
flincher	16	25	658	3	flincher
flinches	16	35	895	3	flinches
flitch	14	92	817	3	flitch__
glitches	14	29	665	3	glitches
hatched	16	34	1446	3	hatched
hatchel	15	35	1075	3	hatchel
hatcher	15	33	1472	3	hatcher
hatches	15	34	2027	3	hatches
hatchet	15	33	1756	3	hatchet
hitch	13	45	1547	3	hitch__
hitchers	16	37	999	3	hitchers
hither	12	44	1725	3	hit_her
hotched	16	36	1092	3	hotched
hotches	15	38	1436	3	hotches
hutched	16	35	988	3	hutched
hutches	15	36	1352	3	hutches
inched	12	45	1448	3	_inched
incher	11	41	1403	3	_incher
inches	11	44	1967	3	_inches
itch	9	56	1917	3	_itch__
itchier	12	24	767	3	_itchier
itchy	13	44	901	3	_itch_y
ither	8	46	1760	3	_it_her
ketches	16	40	1219	3	ketches
kimchee	18	4	560	3	kimchee
kitchens	17	19	578	3	kitchens
kithe	12	59	1745	3	kit_he_
kithed	14	46	1301	3	kit_hed
kithes	13	50	1665	3	kit_hes
kitsches	17	3	407	3	kitsches
latched	13	39	1406	3	latched
latches	12	33	2012	3	latches
latchet	12	31	1790	3	latchet
letched	13	39	1205	3	letched
letches	12	40	1548	3	letches
lichee	11	40	1797	3	li_chee
lichen	11	40	1274	3	li_chen
liches	11	47	2429	3	li_ches
litchi	11	3	789	3	litch_i
litchis	12	3	837	3	litchis
lithe	8	49	2201	3	lit_he_
lither	9	45	2095	3	lit_her
matched	15	35	1396	3	matched
matcher	14	32	1428	3	matcher
matches	14	32	1978	3	matches
miche	12	62	1924	3	mi_che_
miched	14	39	1339	3	mi_ched
miches	13	43	2073	3	mi_ches
mither	11	42	1856	3	mit_her
mutches	14	33	1428	3	mutches
niche	10	50	1679	3	ni_che_
niched	12	55	1406	3	ni_ched
niches	11	44	1914	3	ni_ches
nitchie	12	4	723	3	nitchie
nitchies	13	3	907	3	nitchies
notched	13	42	1030	3	notched
notcher	12	36	1093	3	notcher
notches	12	35	1365	3	notches
patched	15	35	1462	3	patched
patcher	14	35	1514	3	patcher
patches	14	33	2038	3	patches
pinched	15	38	1245	3	pinched
pincher	14	38	1271	3	pincher
pinches	14	41	1793	3	pinches
pitch	12	50	1841	3	pitch__
pitchers	15	32	1148	3	pitchers
pitchier	15	36	827	3	pitchier
pitchmen	17	4	433	3	pitchmen
pitchy	16	47	967	3	pitch_y
pithed	12	46	1561	3	pit_hed
quitches	22	3	619	3	quitches
ratches	12	36	2046	3	ratches
ratchet	12	42	1833	3	ratchet
rechew	14	3	1021	3	_rechew
retched	13	38	1427	3	retched
retches	12	33	1851	3	retches
richen	11	38	1251	3	ri_chen
richer	11	40	1504	3	ri_cher
riches	11	50	2208	3	ri_ches
rotche	11	43	1198	3	rotche_
rotches	12	35	1570	3	rotches
satchel	12	33	1030	3	satchel
snitched	14	16	686	3	snitched
snitcher	13	15	737	3	snitcher
snitches	13	14	898	3	snitches
stitched	14	14	820	3	stitched
stitcher	13	16	839	3	stitcher
stitches	13	14	1059	3	stitches
switched	17	15	713	3	switched
switcher	16	17	768	3	switcher
switches	16	15	913	3	switches
tetched	13	30	1077	3	tetched
thew	10	82	2623	3	__t_hew
tithe	8	53	1970	3	tit_he_
tithed	10	41	1559	3	tit_hed
tither	9	49	2028	3	tit_her
tithes	9	47	2021	3	tit_hes
twitched	17	15	503	3	twitched
twitcher	16	13	534	3	twitcher
twitches	16	15	637	3	twitches
vetches	15	34	1126	3	vetches
watched	16	30	1282	3	watched
watcher	15	31	1340	3	watcher
watches	15	30	1737	3	watches
wiches	14	44	1875	3	wi_ches
winched	16	31	1059	3	winched
wincher	15	34	1065	3	wincher
winches	15	47	1437	3	winches
witch	13	45	1756	3	witch__
witchery	19	23	609	3	witchery
witchier	16	30	788	3	witchier
witchy	17	46	859	3	witch_y
withe	11	52	2023	3	wit_he_
withed	13	44	1623	3	wit_hed
wither	12	43	2135	3	wit_her
withes	12	46	2084	3	wit_hes
zilches	21	32	630	3	zilches
zither	18	38	1308	3	zit_her

Search took 7 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	134027	0.140	1276364.3
2	DLD Change Limit	134027	214	5.876	22809.2
3	Display Results	214	214	0.076	2815.8
	(SQL Overall)	178691	214	6.092	29332.1