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

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

93 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
litten	6	40	1487	(None)
bitten	8	47	1512	1	bitten
kitten	10	46	1148	1	kitten
latten	6	50	1820	1	latten
listen	6	48	1681	1	listen
litter	6	43	2485	1	litter
mitten	8	39	1409	1	mitten
sitten	6	41	1382	1	sitten
batten	8	52	1712	2	batten
bitted	9	44	1848	2	bitted
bitter	8	46	2267	2	bitter
bittern	9	48	1068	2	bittern
cittern	9	33	914	2	cittern
fatten	9	43	1490	2	fatten
fitted	10	47	1666	2	fitted
fitter	9	41	2003	2	fitter
flatten	10	42	965	2	flatten
flitted	11	40	1164	2	flitted
flitter	10	34	1390	2	flitter
gitted	8	40	1505	2	gitted
gittern	8	33	750	2	gittern
gittin	7	29	1055	2	gittin
glisten	8	41	808	2	glisten
glitter	8	42	1180	2	glitter
gotten	7	34	1011	2	gotten
hitmen	11	23	919	2	hitmen
hitter	9	44	1986	2	hitter
jitter	13	33	1499	2	jitter
kitted	11	51	1483	2	kitted
kittel	10	36	887	2	kittel
kittens	11	34	758	2	kittens
lateen	6	40	1486	2	lateen
laten	5	43	2834	2	l_aten
latte	5	54	2630	2	latte_
lattens	7	50	1467	2	lattens
latter	6	50	2789	2	latter
lattes	6	53	2420	2	lattes
lattin	6	43	1622	2	lattin
lenten	6	3	1288	2	lenten
letted	7	41	1854	2	letted
letter	6	37	2258	2	letter
lichen	11	40	1274	2	lichen
lien	4	53	3980	2	li__en
lifted	10	44	1352	2	lifted
lifter	9	38	1481	2	lifter
liftmen	12	3	423	2	liftmen
lighten	11	28	1152	2	lighten
liken	9	118	1884	2	li_ken
lilted	7	37	1537	2	lilted
limen	7	54	2603	2	li_men
linden	7	4	1145	2	linden
linen	5	57	2872	2	li_nen
linted	7	40	2182	2	linted
lintel	6	40	1399	2	lintel
linter	6	46	2534	2	linter
lippen	10	39	1140	2	lippen
listed	7	43	2283	2	listed
listee	6	42	2306	2	listee
listel	6	42	1474	2	listel
listens	7	40	1413	2	listens
lister	6	45	2725	2	lister
lite	4	70	5454	2	li_te_
liter	5	47	3634	2	li_ter
lithe	8	49	2201	2	lithe_
lither	9	45	2095	2	lither
litotes	7	3	1118	2	litotes
litre	5	54	2146	2	litre_
litres	6	52	2039	2	litres
litters	7	34	2257	2	litters
littery	10	37	1049	2	littery
little	6	33	1216	2	little
littler	7	34	855	2	littler
littles	7	32	1278	2	littles
liven	8	50	2173	2	li_ven
lotte	5	49	2385	2	lotte_
lotted	7	42	2240	2	lotted
lotter	6	40	2560	2	lotter
lottes	6	53	2275	2	lottes
mittens	9	34	988	2	mittens
patten	8	44	1819	2	patten
pitmen	10	25	1079	2	pitmen
pitted	9	43	1959	2	pitted
ratten	6	42	1738	2	ratten
ritter	6	38	2242	2	ritter
rotten	6	41	1543	2	rotten
sitter	6	33	2338	2	sitter
slitted	8	35	1331	2	slitted
slitter	7	36	1587	2	slitter
smitten	9	3	669	2	smitten
titmen	8	23	988	2	titmen
titter	6	34	2116	2	titter
witted	10	42	1681	2	witted
written	10	33	634	2	written

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	82551	0.690	258972.5
2	DLD Change Limit	82551	93	5.076	16263.0
3	Display Results	93	93	0.016	5812.5
	(SQL Overall)	178691	93	5.782	30904.7