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

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

80 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
sixte	12	62	1658	(None)
site	4	70	5241	1	si_te
sixtes	13	36	1240	1	sixtes
sixth	15	55	1223	1	sixth
sixty	15	49	1273	1	sixty
axite	12	52	1825	2	axite
bite	6	65	4699	2	bi_te
cite	6	56	4034	2	ci_te
dite	5	55	4755	2	di_te
fixate	16	3	873	2	fixate
fixt	14	107	2971	2	fixt_
gite	5	54	3861	2	gi_te
ixtle	12	16	801	2	_ixtle
kite	8	53	3823	2	ki_te
lite	4	70	5454	2	li_te
mite	6	62	4940	2	mi_te
mixt	13	68	3191	2	mixt_
nite	4	59	4358	2	ni_te
nixe	11	57	2202	2	nix_e
nixie	12	51	1494	2	nixie
piste	7	58	2460	2	piste
pixie	14	54	1552	2	pixie
rite	4	58	4945	2	ri_te
sate	4	55	5610	2	s_ate
saute	5	50	2808	2	saute
scute	7	55	2094	2	scute
sente	5	64	3287	2	sente
sext	11	73	3809	2	sext_
sextet	13	9	1687	2	sextet
sexto	12	44	1545	2	sexto
sexts	12	51	1838	2	sexts
shote	8	55	2608	2	shote
shute	8	45	2034	2	shute
sice	6	55	4559	2	si_ce
side	5	54	4448	2	si_de
sidhe	9	53	1510	2	sidhe
sidle	6	51	2403	2	sidle
siege	6	67	1844	2	siege
sieve	8	49	1884	2	sieve
sift	7	107	4066	2	sift_
sifted	10	43	1367	2	sifted
sifter	9	45	1623	2	sifter
sifts	8	49	1892	2	sifts
sike	8	71	3878	2	si_ke
silt	4	65	5819	2	silt_
silted	7	40	2001	2	silted
silts	5	53	3082	2	silts
silty	8	47	2163	2	silty
since	7	50	2417	2	since
sine	4	65	6062	2	si_ne
singe	6	57	3113	2	singe
sinter	6	36	2592	2	sinter
sipe	6	73	4104	2	si_pe
sire	4	61	5041	2	si_re
siree	5	52	3881	2	siree
sister	6	44	2158	2	sister
sit	3	58	7775	2	si_t_
sited	6	51	3074	2	si_ted
sites	5	60	4543	2	si_tes
sith	7	54	3515	2	si_th
sits	4	50	5020	2	si_ts
sitten	6	41	1382	2	sitten
sitter	6	33	2338	2	sitter
six	10	53	3974	2	six__
sixes	12	45	2636	2	sixes
sixmo	14	4	830	2	sixmo
sixteen	14	3	411	2	sixteen
sixths	16	41	637	2	sixths
sixties	14	3	1097	2	sixties
size	13	56	3096	2	si_ze
skate	9	47	2154	2	skate
skite	9	51	2004	2	skite
slate	5	54	3828	2	slate
smite	7	52	2486	2	smite
smote	7	58	2027	2	smote
spate	7	47	3158	2	spate
spite	7	54	3066	2	spite
state	5	62	3733	2	state
suite	5	48	2956	2	suite
wite	7	54	4327	2	wi_te

Search took 3 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	80	1.860	28924.7
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	1.986	89975.3