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

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

241 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
litchi	11	3	789	(None)
lichi	10	44	1295	1	li_chi
litchis	12	3	837	1	litchis
aitch	10	52	1616	2	aitch_
bitch	12	50	1776	2	bitch_
bitchy	16	47	920	2	bitchy
ditch	11	50	1509	2	ditch_
fitch	13	48	1687	2	fitch_
fitchy	17	43	762	2	fitchy
flitch	14	92	817	2	flitch_
glitch	12	28	635	2	glitch_
glitchy	16	28	308	2	glitchy
hitch	13	45	1547	2	hitch_
itch	9	56	1917	2	_itch_
itchy	13	44	901	2	_itchy
kimchi	17	4	380	2	kimchi
latch	10	46	2046	2	latch_
lathi	8	54	1720	2	lat_hi
letch	10	52	1580	2	letch_
lich	9	62	3084	2	li_ch_
lichis	11	52	1259	2	li_chis
licht	10	47	2349	2	li_cht
litai	5	52	1636	2	lit_ai
lithe	8	49	2201	2	lit_he
lithia	9	3	933	2	lit_hia
lithic	11	3	949	2	lit_hic
litho	8	65	1378	2	lit_ho
nitchie	12	4	723	2	nitchie
pitch	12	50	1841	2	pitch_
pitchy	16	47	967	2	pitchy
witch	13	45	1756	2	witch_
witchy	17	46	859	2	witchy
aitches	12	30	1436	3	aitches
batch	12	46	2010	3	batch_
biochip	16	4	532	3	biochip
birch	12	49	1402	3	birch_
bitched	15	32	1292	3	bitched
bitchen	14	34	973	3	bitchen
bitches	14	41	1706	3	bitches
bitchier	15	30	773	3	bitchier
bitchily	18	4	453	3	bitchily
bitching	16	36	1062	3	bitching
blithe	11	58	1086	3	blit_he
blotch	13	19	714	3	blotch_
blotchy	17	29	397	3	blotchy
botch	12	67	1745	3	botch_
botchy	16	53	782	3	botchy
butch	12	54	1654	3	butch_
catch	12	51	2037	3	catch_
catchy	16	55	958	3	catchy
chi	8	62	2865	3	___chi
chichi	16	3	709	3	chichi
cinch	12	45	1624	3	cinch_
cliche	13	37	1245	3	cli_che
clinch	13	39	1035	3	clinch_
clutch	13	36	775	3	clutch_
clutchy	17	32	389	3	clutchy
cutch	12	51	1619	3	cutch_
datcha	12	6	656	3	datcha
disci	8	58	1502	3	disc_i
ditched	14	37	1190	3	ditched
ditcher	13	40	1200	3	ditcher
ditches	13	32	1571	3	ditches
ditching	15	34	994	3	ditching
dutch	11	47	1382	3	dutch_
elenchi	12	4	472	3	elenchi
etch	9	54	1914	3	_etch_
fetch	13	49	1347	3	fetch_
fiaschi	15	4	279	3	fiaschi
fiche	13	46	1674	3	fi_che
fichu	13	48	1066	3	fi_chu
filch	13	48	1332	3	filch_
finch	13	54	1697	3	finch_
fitchee	15	27	1078	3	fitchee
fitches	15	35	1619	3	fitches
fitchet	15	31	1356	3	fitchet
fitchew	18	27	680	3	fitchew
fletch	14	38	819	3	fletch_
flinch	14	40	1010	3	flinch_
flitched	17	25	629	3	flitched
flitches	16	38	846	3	flitches
flitching	18	26	534	3	flitching
glitches	14	29	665	3	glitches
glitchier	15	4	279	3	glitchier
gotcha	12	3	463	3	gotcha
hatch	13	57	1959	3	hatch_
hibachi	17	4	420	3	hibachi
hitched	16	33	1225	3	hitched
hitcher	15	37	1200	3	hitcher
hitches	15	36	1627	3	hitches
hitching	17	33	1052	3	hitching
hotch	13	62	1473	3	hotch_
hutch	13	54	1409	3	hutch_
ich	8	62	2774	3	_i_ch_
ichs	9	62	1471	3	_i_chs
inch	9	54	2082	3	_inch_
ischia	11	3	639	3	_ischia
itched	12	38	1202	3	_itched
itches	11	49	1621	3	_itches
itchier	12	24	767	3	_itchier
itchily	15	7	449	3	_itchily
itching	13	40	1168	3	_itching
ketch	14	49	1202	3	ketch_
kimchis	18	4	373	3	kimchis
kitchen	16	28	768	3	kitchen
kith	11	58	2636	3	kit_h_
kithe	12	59	1745	3	kit_he
kiths	12	58	1497	3	kit_hs
kitsch	15	3	335	3	kitsch_
kitschy	19	4	198	3	kitschy
klatch	15	44	593	3	klatch_
laich	10	59	2071	3	laich_
laichs	11	51	1089	3	laichs
laith	8	57	2210	3	lait_h_
larch	10	59	1979	3	larch_
latched	13	39	1406	3	latched
latches	12	33	2012	3	latches
latchet	12	31	1790	3	latchet
latching	14	37	1202	3	latching
lath	7	66	4038	3	lat_h_
lathe	8	56	2671	3	lat_he
lathis	9	55	1617	3	lat_his
laths	8	60	2240	3	lat_hs
lathy	11	52	1506	3	lat_hy
lati	4	64	3827	3	lat__i
leach	10	54	2252	3	leach_
leachy	14	41	973	3	leachy
lech	9	68	2544	3	l_ech_
leech	10	49	1321	3	leech_
letched	13	39	1205	3	letched
letches	12	40	1548	3	letches
letching	14	38	1026	3	letching
lethe	8	57	1730	3	let_he
libri	7	46	1011	3	li_bri
lice	6	60	4506	3	li_c_e
lichee	11	40	1797	3	li_chee
lichen	11	40	1274	3	li_chen
liches	11	47	2429	3	li_ches
lichts	11	37	1238	3	li_chts
licit	7	43	2768	3	li_cit
lick	10	69	3507	3	li_c_k
licks	11	53	2539	3	li_cks
lictor	8	36	1085	3	lictor
light	9	44	2960	3	li_ght
limbi	9	65	1381	3	li_mbi
limuli	8	3	634	3	limuli
linchpin	15	5	370	3	linchpin
liri	4	51	2825	3	li__ri
lit	3	93	7731	3	lit___
litany	9	3	905	3	litany
litas	5	49	2377	3	lit_as
lite	4	70	5454	3	lit__e
liter	5	47	3634	3	lit_er
liters	6	54	2988	3	liters
lither	9	45	2095	3	lither
lithias	10	3	882	3	lit_hias
lithify	16	4	476	3	lit_hify
lithium	12	4	582	3	lit_hium
lithoid	11	4	877	3	lithoid
lithos	9	42	1255	3	lithos
litmus	8	3	632	3	litmus
litotic	9	3	924	3	litotic
litre	5	54	2146	3	lit_re
litres	6	52	2039	3	litres
lits	4	62	5249	3	lit__s
litten	6	40	1487	3	litten
litter	6	43	2485	3	litter
little	6	33	1216	3	little
litu	4	76	3156	3	lit__u
loach	10	51	1636	3	loach_
loch	9	55	2713	3	l_och_
lochia	11	5	831	3	l_ochia
lochs	10	67	1551	3	l_ochs
loci	6	61	2628	3	l_oc_i
lotah	8	53	1585	3	lotah_
lotahs	9	47	987	3	lotahs
loth	7	61	3213	3	lot_h_
loti	4	64	3184	3	lot__i
louche	11	52	1266	3	louche
lunch	10	49	1724	3	lunch_
lurch	10	48	1463	3	lurch_
lych	12	60	1576	3	l_ych_
lynch	13	46	898	3	lynch_
match	12	56	2110	3	match_
miche	12	62	1924	3	mi_che
milch	12	44	1337	3	milch_
milchig	15	4	365	3	milchig
mutch	12	50	1617	3	mutch_
natch	10	50	1822	3	natch_
niche	10	50	1679	3	ni_che
nitchies	13	3	907	3	nitchies
notch	10	56	1332	3	notch_
outchid	13	3	872	3	outchid
patch	12	52	2122	3	patch_
patchy	16	50	957	3	patchy
pinch	12	56	1930	3	pinch_
pitched	15	35	1292	3	pitched
pitcher	14	38	1371	3	pitcher
pitches	14	36	1775	3	pitches
pitchier	15	36	827	3	pitchier
pitchily	18	5	501	3	pitchily
pitching	16	34	1111	3	pitching
pith	9	54	3269	3	pit_h_
piths	10	58	1754	3	pit_hs
pithy	13	56	1446	3	pit_hy
quitch	20	3	641	3	quitch_
ratch	10	42	2136	3	ratch_
retch	10	48	1830	3	retch_
rich	9	70	2554	3	ri_ch_
rishi	8	3	1125	3	ri_shi
rotch	10	58	1593	3	rotch_
rotche	11	43	1198	3	rotche
sitcom	10	3	690	3	sitcom
sith	7	54	3515	3	sit_h_
slatch	11	45	1053	3	slatch_
snitch	11	35	794	3	snitch_
stich	10	41	1792	3	stich_
stichic	14	4	624	3	stichic
stichs	11	45	1165	3	stichs
stitch	11	41	910	3	stitch_
switch	14	45	891	3	switch_
tetchy	14	3	600	3	tetchy
tithe	8	53	1970	3	tit_he
titi	4	71	3062	3	tit__i
twitch	14	40	616	3	twitch_
twitchy	18	39	357	3	twitchy
vetch	13	44	1184	3	vetch_
vichy	16	3	904	3	vi_chy
watch	13	56	1706	3	watch_
wich	12	57	2474	3	wi_ch_
winch	13	50	1666	3	winch_
witched	16	30	1219	3	witched
witches	15	27	1579	3	witches
witchier	16	30	788	3	witchier
witching	17	34	1063	3	witching
with	10	57	3047	3	wit_h_
withe	11	52	2023	3	wit_he
within	12	36	1138	3	wit_hin
withy	14	48	1376	3	wit_hy
zilch	19	43	812	3	zilch_
ziti	13	60	2237	3	zit__i

Search took 6 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	112716	0.390	458182.1
2	DLD Change Limit	112716	241	4.846	23259.6
3	Display Results	241	241	0.076	3171.1
	(SQL Overall)	178691	241	5.312	33639.1