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

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

267 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
spits	7	44	2955	(None)
pits	6	63	4874	1	_pits
shits	8	47	3117	1	shits
sits	4	50	5020	1	s_its
skits	9	47	2186	1	skits
slits	5	61	2885	1	slits
snits	5	41	2483	1	snits
spaits	8	50	1747	1	spaits
spats	7	50	3138	1	spats
spics	9	41	2324	1	spics
spies	7	60	3762	1	spies
spiks	11	41	1747	1	spiks
spins	7	53	2798	1	spins
spirts	8	53	1713	1	spirts
spit	6	55	4508	1	spit_
spite	7	54	3066	1	spite
spites	8	41	2733	1	spites
spitz	16	60	1797	1	spitz
spivs	10	51	1424	1	spivs
splits	8	54	1641	1	splits
spots	7	44	2411	1	spots
sprits	8	51	2253	1	sprits
suits	5	50	2805	1	suits
adits	6	65	2371	2	adits
aits	4	63	5553	2	_aits
aspics	10	42	1156	2	aspics
aspis	7	46	1814	2	aspi_s
baits	7	66	3058	2	baits
bits	6	61	4816	2	_bits
brits	7	64	3308	2	brits
chits	10	54	2457	2	chits
crits	7	55	2757	2	crits
dits	5	64	5052	2	_dits
doits	6	62	2367	2	doits
duits	6	50	2188	2	duits
edits	6	58	1903	2	edits
emits	7	54	2147	2	emits
epics	9	50	1428	2	epics
espies	8	37	1680	2	espies
esprits	9	3	839	2	esprits
exits	12	55	1591	2	exits
fits	7	60	4346	2	_fits
flits	8	56	2522	2	flits
frits	8	61	2910	2	frits
gaits	6	57	2601	2	gaits
gits	5	57	4459	2	_gits
grits	6	55	2958	2	grits
hits	7	55	4513	2	_hits
its	3	55	3883	2	__its
kits	8	64	4177	2	_kits
knits	9	39	1474	2	knits
lits	4	62	5249	2	_lits
nits	4	57	4164	2	_nits
obits	7	46	1755	2	obits
omits	7	50	1826	2	omits
opts	6	81	2474	2	op_ts
pats	6	64	6085	2	_pats
pets	6	62	4833	2	_pets
pias	6	65	4255	2	_pias
pics	8	56	3391	2	_pics
pies	6	69	4960	2	_pies
pigs	7	66	3422	2	_pigs
pins	6	55	5845	2	_pins
pints	7	59	3622	2	_pints
pipits	10	47	1306	2	pipits
pips	8	58	3713	2	_pips
pis	5	63	6203	2	_pi_s
piss	6	50	3333	2	_piss
pit	5	64	7192	2	_pit_
pita	6	54	3643	2	_pita
pitas	7	74	2767	2	_pitas
pith	9	54	3269	2	_pith
piths	10	58	1754	2	_piths
pity	9	60	3193	2	_pity
pots	6	64	5236	2	_pots
psis	6	81	2034	2	psi_s
puts	6	56	4175	2	_puts
quits	14	41	2235	2	quits
saids	6	53	2885	2	saids
sails	5	57	3810	2	sails
sains	5	56	3997	2	sains
saints	6	51	2242	2	saints
saith	8	58	2655	2	saith
salts	5	54	3188	2	salts
satis	5	56	3368	2	satis
scats	7	59	3060	2	scats
scots	7	40	2591	2	scots
scuts	7	45	2252	2	scuts
seats	5	48	4434	2	seats
sects	7	56	2289	2	sects
seifs	8	50	1933	2	seifs
seis	4	55	4239	2	sei_s
sepias	8	36	1610	2	sepias
septs	7	54	2060	2	septs
sets	4	55	4950	2	s_ets
setts	5	51	2432	2	setts
sexts	12	51	1838	2	sexts
shies	8	61	3655	2	shies
shifts	12	44	1294	2	shifts
shims	10	44	2255	2	shims
shins	8	51	3104	2	shins
ships	10	51	2377	2	ships
shirts	9	49	1834	2	shirts
shist	8	48	2961	2	shist
shists	9	65	1511	2	shists
shit	7	67	4594	2	shit_
shivs	11	50	1880	2	shivs
shots	8	47	3085	2	shots
shuts	8	56	2248	2	shuts
sibs	6	59	3354	2	s_ibs
sics	6	52	3409	2	s_ics
sifts	8	49	1892	2	sifts
silts	5	53	3082	2	silts
sims	6	57	3717	2	s_ims
sins	4	67	5527	2	s_ins
sipes	7	60	3695	2	sipes
sips	6	57	4010	2	s_ips
sirs	4	43	3833	2	s_irs
sis	3	73	6054	2	s_i_s
sit	3	58	7775	2	s_it_
site	4	70	5241	2	s_ite
sites	5	60	4543	2	s_ites
sith	7	54	3515	2	s_ith
situs	5	50	1923	2	s_itus
skats	9	46	2154	2	skats
skids	10	46	1533	2	skids
skies	9	50	2683	2	skies
skims	11	45	1719	2	skims
skins	9	47	2346	2	skins
skips	11	56	1660	2	skips
skirts	10	41	1150	2	skirts
skis	8	48	2529	2	ski_s
skit	8	54	3753	2	skit_
skite	9	51	2005	2	skite
skites	10	44	1804	2	skites
slats	5	54	3690	2	slats
slims	7	54	2365	2	slims
slips	7	60	2372	2	slips
slit	4	62	5010	2	slit_
slots	5	48	3053	2	slots
sluts	5	45	2398	2	sluts
smit	6	51	3841	2	smit_
smite	7	52	2487	2	smite
smites	8	39	2192	2	smites
smith	10	78	1805	2	smith
smiths	11	47	1102	2	smiths
smuts	7	54	1571	2	smuts
snibs	7	56	1376	2	snibs
snips	7	58	1801	2	snips
snit	4	63	4247	2	snit_
snots	5	52	2512	2	snots
softs	8	50	1923	2	softs
soils	5	53	2798	2	soils
soots	5	55	3621	2	soots
sopite	8	49	1771	2	sopite
sopites	9	38	1717	2	sopites
sorts	5	45	3666	2	sorts
sots	4	55	5245	2	s_ots
spaes	7	60	2997	2	spaes
spails	8	48	1782	2	spails
spait	7	56	3160	2	spait_
spams	9	49	2219	2	spams
spans	7	45	2873	2	spans
spars	7	54	3154	2	spars
spas	6	70	3672	2	sp_as
spat	6	65	4852	2	spat_
spate	7	47	3158	2	spate
spates	8	50	2817	2	spates
spays	10	55	2051	2	spays
specs	9	69	1667	2	specs
speils	8	41	1622	2	speils
speirs	8	50	1323	2	speirs
speiss	8	43	1164	2	speiss
spelts	8	46	1464	2	spelts
spews	10	50	1592	2	spews
spic	8	52	2743	2	spi_c
spica	9	47	1794	2	spica
spicas	10	47	1582	2	spicas
spice	9	55	2881	2	spice
spices	10	43	2603	2	spices
spick	13	45	1907	2	spick
spicks	14	48	1499	2	spicks
spicy	12	54	1771	2	spicy
spied	8	54	2771	2	spied
spiel	7	46	2391	2	spiel
spiels	8	53	1795	2	spiels
spier	7	57	2803	2	spier
spiers	8	44	2174	2	spiers
spiff	13	36	1640	2	spiff
spiffs	14	32	847	2	spiffs
spigots	10	3	779	2	spigots
spik	10	54	1971	2	spi_k
spike	11	49	2284	2	spike
spikes	12	45	2071	2	spikes
spiky	14	60	1411	2	spiky
spile	7	52	3008	2	spile
spiles	8	42	2791	2	spiles
spill	7	48	2116	2	spill
spills	8	47	1746	2	spills
spilt	7	55	3222	2	spilt
spilth	11	46	973	2	spilth
spilths	12	35	602	2	spilths
spin	6	62	3130	2	spi_n
spine	7	65	3442	2	spine
spines	8	51	3203	2	spines
spinets	9	47	1481	2	spinets
spinto	8	4	1066	2	spinto
spintos	9	3	913	2	spintos
spiny	10	49	2130	2	spiny
spire	7	58	2869	2	spire
spires	8	46	2811	2	spires
spirits	9	41	1262	2	spirits
spirt	7	50	3295	2	spirt
spiry	10	50	1735	2	spiry
spital	8	38	1387	2	spital
spitals	9	30	1159	2	spitals
spited	9	48	2044	2	spited
spitzes	18	4	918	2	spitzes
spiv	9	59	1779	2	spi_v
splats	8	48	1730	2	splats
splints	9	45	1174	2	splints
split	7	57	2901	2	split_
spoils	8	46	1453	2	spoils
sports	8	46	1918	2	sports
spot	6	55	4069	2	spot_
spouts	8	51	1511	2	spouts
sprats	8	58	1993	2	sprats
sprigs	9	48	1477	2	sprigs
sprints	9	41	1377	2	sprints
sprit	7	67	3640	2	sprit_
sprite	8	44	2177	2	sprite
sprites	9	42	2033	2	sprites
spritz	17	47	1442	2	spritz
spuds	8	51	1367	2	spuds
spues	7	50	2538	2	spues
spurs	7	46	2152	2	spurs
spurts	8	48	1497	2	spurts
sputa	7	46	1296	2	sputa
sris	4	54	3415	2	sri_s
stats	5	59	3336	2	stats
stets	5	54	2391	2	stets
sties	5	51	3298	2	sties
stilts	6	79	1531	2	stilts
stints	6	51	1976	2	stints
stirs	5	59	2162	2	stirs
stots	5	48	2855	2	stots
suets	5	51	2610	2	suets
suints	6	46	1778	2	suints
suit	4	56	4987	2	suit_
suite	5	48	2956	2	suite
suites	6	37	2740	2	suites
swats	8	57	2686	2	swats
swifts	12	40	817	2	swifts
swigs	9	62	1366	2	swigs
swims	10	55	1414	2	swims
swiss	8	67	1290	2	swiss
swith	11	59	1740	2	swith
swots	8	55	1843	2	swots
tits	4	61	4504	2	_tits
toits	5	53	2747	2	toits
twits	8	60	1579	2	twits
units	5	49	2343	2	units
waits	8	83	3352	2	waits
whits	11	59	2382	2	whits
wits	7	60	4487	2	_wits
writs	8	66	2438	2	writs
zits	13	60	3029	2	_zits

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.326	548131.9
2	DLD Change Limit	53800	267	2.330	23090.1
3	Display Results	267	267	0.156	1711.5
	(SQL Overall)	178691	267	2.812	63545.9