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

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

(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
dita	5	60	3253	(None)
data	5	60	2665	1	data
dicta	8	49	1563	1	dicta
dit	4	70	7134	1	dit_
ditas	6	59	2367	1	ditas
dite	5	55	4756	1	dite
dits	5	64	5053	1	dits
ditz	14	69	2952	1	ditz
diva	8	59	2089	1	diva
pita	6	54	3644	1	pita
vita	7	58	2853	1	vita
acta	6	95	2480	2	acta
adit	5	64	4366	2	adit_
adits	6	65	2371	2	adits
adyta	9	3	685	2	adyta
agita	6	3	1542	2	agita
ait	3	80	9391	2	ait_
aits	4	63	5554	2	aits
anta	4	68	3958	2	anta
beta	6	62	3413	2	beta
bima	8	67	2384	2	bima
biota	7	45	1682	2	biota
bit	5	70	7091	2	bit_
bite	6	65	4701	2	bite
bits	6	61	4817	2	bits
bitt	6	55	4582	2	bitt
bota	6	62	3650	2	bota
cite	6	56	4035	2	cite
city	9	51	2263	2	city
dada	6	64	2245	2	dada
date	5	64	4332	2	date
dato	5	61	2994	2	dato
deity	9	43	1677	2	deity
delta	6	61	1777	2	delta
deva	8	57	2098	2	deva
dial	5	59	3507	2	dial
dib	6	57	4695	2	di_b
dibs	7	62	3369	2	dibs
dice	7	58	4190	2	dice
dick	11	64	3239	2	dick
dicty	11	51	1629	2	dicty
did	5	68	5053	2	di_d
dido	6	65	2821	2	dido
didy	9	91	2152	2	didy
die	4	67	5966	2	di_e
died	6	61	3786	2	died
diel	5	90	3461	2	diel
dies	5	56	5353	2	dies
diet	5	73	5754	2	diet
diets	6	60	2664	2	diets
dif	7	68	4691	2	di_f
diff	11	62	2885	2	diff
difs	8	60	2733	2	difs
dig	5	75	4448	2	di_g
digs	6	60	3606	2	digs
dike	9	59	3577	2	dike
diktat	11	3	1069	2	diktat
dill	5	52	3998	2	dill
dim	6	81	4650	2	di_m
dime	7	62	3765	2	dime
dims	7	54	3503	2	dims
din	4	64	5947	2	di_n
dinar	6	63	1989	2	dinar
dine	5	55	5534	2	dine
ding	6	69	4096	2	ding
dink	9	71	3781	2	dink
dino	5	60	3676	2	dino
dins	5	66	5205	2	dins
dint	5	67	5906	2	dint
dints	6	74	3131	2	dints
diol	5	73	2914	2	diol
dip	6	78	4899	2	di_p
dips	7	55	3692	2	dips
dipt	7	73	3933	2	dipt
diram	8	44	1947	2	diram
dire	5	66	4415	2	dire
dirk	9	63	2684	2	dirk
dirl	5	74	3003	2	dirl
dirt	5	55	5039	2	dirt
dirts	6	68	2446	2	dirts
dirty	9	56	1780	2	dirty
dis	4	64	5990	2	di_s
disc	7	61	2324	2	disc
dish	8	63	2834	2	dish
disk	9	66	2584	2	disk
diss	5	64	3449	2	diss
distal	7	36	1577	2	distal
ditch	11	50	1509	2	ditch
dites	6	63	3915	2	dites
ditsy	9	56	1256	2	ditsy
ditto	6	53	1560	2	ditto
ditty	9	50	1929	2	ditty
ditzy	18	65	1328	2	ditzy
divan	9	61	1484	2	divan
divas	9	54	1858	2	divas
dive	8	56	3478	2	dive
diwan	9	57	1255	2	diwan
doat	5	69	4767	2	doat
doit	5	63	4785	2	doit_
doits	6	62	2367	2	doits
dona	5	55	2963	2	dona
dopa	7	72	2090	2	dopa
dot	4	75	7318	2	dot_
dotal	6	49	1962	2	dotal
dote	5	54	4288	2	dote
doth	8	62	2571	2	doth
dots	5	56	4766	2	dots
doty	8	61	2822	2	doty
drat	5	62	4783	2	drat
duit	5	62	4158	2	duit_
duits	6	50	2188	2	duits
duma	7	55	2445	2	duma
dura	5	52	3211	2	dura
duty	8	53	2145	2	duty
edit	5	49	3487	2	edit_
edits	6	58	1903	2	edits
eta	3	58	3419	2	_eta
feta	7	65	2890	2	feta
fiat	7	66	4665	2	fiat
fila	7	47	2914	2	fila
fit	6	63	6546	2	fit_
fits	7	60	4347	2	fits
geta	5	66	2744	2	geta
giga	6	67	2095	2	giga
git	4	62	6606	2	git_
gite	5	54	3862	2	gite
gits	5	57	4460	2	gits
hila	7	62	2836	2	hila
hit	6	65	6920	2	hit_
hits	7	55	4514	2	hits
idea	5	91	2278	2	idea
iota	4	51	2783	2	iota
it	2	84	5569	2	_it_
its	3	55	3884	2	_its
jota	11	64	2362	2	jota
kata	8	56	2603	2	kata
kina	8	56	3201	2	kina
kit	7	85	5989	2	kit_
kite	8	53	3825	2	kite
kith	11	58	2637	2	kith
kits	8	64	4178	2	kits
kiva	11	65	1642	2	kiva
lima	6	57	3414	2	lima
lipa	6	84	2593	2	lipa
lira	4	69	2869	2	lira
lit	3	93	7732	2	lit_
litai	5	52	1636	2	litai
litas	5	49	2377	2	litas
lite	4	70	5455	2	lite
lits	4	62	5250	2	lits
litu	4	76	3157	2	litu
lota	4	72	3350	2	lota
meta	6	59	3241	2	meta
mica	8	64	2826	2	mica
mina	6	51	3693	2	mina
mite	6	62	4942	2	mite
mitt	6	61	4550	2	mitt
mity	9	55	2822	2	mity
nipa	6	94	2164	2	nipa
nit	3	70	6595	2	nit_
nite	4	59	4359	2	nite
nits	4	57	4165	2	nits
nota	4	68	3077	2	nota
pia	5	68	4804	2	pi_a
pica	8	58	3150	2	pica
pieta	7	54	2175	2	pieta
pika	10	63	2296	2	pika
pima	8	54	2866	2	pima
pina	6	58	4264	2	pina
pinta	7	57	2705	2	pinta
pit	5	64	7193	2	pit_
pitas	7	74	2767	2	pitas
pith	9	54	3270	2	pith
pits	6	63	4875	2	pits
pitta	7	50	1869	2	pitta
pity	9	60	3194	2	pity
raita	5	46	2307	2	raita
ria	3	67	4551	2	ri_a
riata	5	46	1802	2	riata
rite	4	58	4946	2	rite
ritz	13	51	2999	2	ritz
rota	4	58	3434	2	rota
seta	4	56	3731	2	seta
sika	8	60	2133	2	sika
sima	6	47	3079	2	sima
sit	3	58	7776	2	sit_
sitar	5	48	2054	2	sitar
site	4	70	5242	2	site
sith	7	54	3516	2	sith
sits	4	50	5021	2	sits
ta	2	116	6245	2	__ta
tit	3	67	7106	2	tit_
titan	5	33	1817	2	titan
titi	4	71	3063	2	titi
tits	4	61	4505	2	tits
uta	3	74	2558	2	_uta
via	6	56	3625	2	vi_a
viga	8	56	2297	2	viga
vina	7	63	3181	2	vina
visa	7	63	2388	2	visa
vista	8	54	1660	2	vista
vitae	8	42	1763	2	vitae
vital	8	48	1967	2	vital
vitta	8	50	1517	2	vitta
viva	10	61	1910	2	viva
wit	6	65	6378	2	wit_
witan	8	38	1650	2	witan
wite	7	54	4328	2	wite
with	10	57	3048	2	with
wits	7	60	4488	2	wits
zeta	13	51	2164	2	zeta
zit	12	60	5000	2	zit_
ziti	13	60	2238	2	ziti
zits	13	60	3030	2	zits

Search took 2 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	29872	0.283	631417.0
2	DLD Change Limit	29872	214	0.856	34897.2
3	Display Results	214	214	0.046	4652.2
	(SQL Overall)	178691	214	1.185	150794.1