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

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

317 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
spigot	9	3	1260	(None)
spigots	10	3	779	1	spigots
bigot	8	48	2832	2	_bigot
epigon	9	3	796	2	epigon
gigot	7	40	2307	2	_gigot
picot	9	50	3101	2	_picot
pigout	9	3	1461	2	_pigout
pilot	7	74	3506	2	_pilot
pinot	7	87	3729	2	_pinot
pivot	10	65	2387	2	_pivot
sight	9	46	2929	2	s_ight
slight	10	34	1600	2	slight
spilt	7	55	3222	2	spi_lt
spinet	8	56	2975	2	spinet
spinor	8	3	994	2	spinor
spinout	9	3	1158	2	spinout
spinto	8	4	1066	2	spinto
spirit	8	35	1992	2	spirit
spirt	7	50	3295	2	spi_rt
spit	6	55	4508	2	spi__t
spot	6	55	4069	2	sp__ot
spright	13	20	1040	2	spright
alight	10	38	1686	3	alight
aliyot	9	36	1171	3	aliyot
amigo	8	65	1547	3	amigo_
amigos	9	45	1121	3	amigos
apricot	11	10	1018	3	apricot
argot	6	77	2865	3	_argot
aright	10	38	1766	3	aright
begot	8	46	2595	3	_begot
bight	11	87	2884	3	_bight
bigos	8	50	2001	3	_bigos
bigots	9	50	1513	3	_bigots
blight	12	41	1462	3	blight
bright	12	42	1592	3	bright
chigoe	12	3	753	3	chigoe
copilot	11	8	1126	3	copilot
dicot	8	54	2909	3	_dicot
dight	10	40	2700	3	_dight
digit	7	38	2527	3	_digit
diglot	8	30	1433	3	_diglot
divot	9	57	2307	3	_divot
eight	9	49	2805	3	_eight
epidote	10	3	739	3	epidote
epigone	10	5	784	3	epigone
epigoni	10	5	609	3	epigoni
epigons	10	4	818	3	epigons
epilog	9	7	646	3	epilog
epizoa	17	4	501	3	epizoa
ergot	6	54	2289	3	_ergot
faggot	11	3	905	3	faggot
fagot	9	3	2340	3	_fagot
fight	12	40	2709	3	_fight
flight	13	40	1481	3	flight
forgot	10	43	1813	3	forgot
fright	13	37	1524	3	fright
giglot	8	40	1313	3	_giglot
gigots	8	39	1195	3	_gigots
got	4	98	7044	3	___got
griot	6	53	2841	3	gri_ot
height	13	47	1343	3	height
hight	12	53	2723	3	_hight
idiot	6	7	1886	3	idi_ot
ingot	6	12	2106	3	_ingot
knight	14	3	817	3	knight
light	9	44	2960	3	_light
lirot	5	4	3003	3	_lirot
maggot	10	3	1171	3	maggot
magot	8	3	2639	3	_magot
might	11	38	2708	3	_might
night	9	43	2785	3	_night
pagod	9	50	1368	3	_pagod
phot	9	55	3436	3	_p_hot
picots	10	46	1644	3	_picots
pig	6	57	4497	3	_pig__
pigboat	12	4	782	3	_pigboat
pigeon	9	4	941	3	_pigeon
piggy	12	40	1143	3	_piggy
piglet	9	34	2092	3	_piglet
pigmy	13	29	943	3	_pigmy
pignut	9	3	1157	3	_pignut
pigouts	10	3	759	3	_pigouts
pigs	7	66	3422	3	_pig_s
pigsty	12	3	593	3	_pigsty
pilots	8	40	1887	3	_pilots
pingo	8	71	2271	3	_pingo_
pingos	9	53	1767	3	_pingos
pinon	7	60	2453	3	_pinon
pinots	8	59	2027	3	_pinots
pint	6	69	6317	3	_pi_nt
pinto	7	56	2575	3	_pinto
pion	6	72	3529	3	_pi_on
pipet	9	55	3332	3	_pipet
pipit	9	52	2487	3	_pipit
pirog	8	39	1367	3	_pirog
piso	6	67	2756	3	_piso_
pisos	7	60	2106	3	_pisos
pit	5	64	7192	3	_pi__t
piton	7	61	2158	3	_piton
pivots	11	51	1190	3	_pivots
plight	12	35	1336	3	plight
plot	6	61	4123	3	_p_lot
pot	5	80	7843	3	_p__ot
right	9	44	3050	3	_right
rigor	6	27	1405	3	_rigor
riot	4	59	4721	3	_ri_ot
sabot	7	9	3178	3	s_abot
sago	5	63	3267	3	s_ago_
sagos	6	61	2387	3	s_agos
saiga	6	47	1793	3	saig_a
saigas	7	41	1429	3	saigas
sailor	6	31	1375	3	sailor
saint	5	51	4707	3	sai_nt
sapient	9	4	1533	3	sapient
sargo	6	54	2441	3	sargo_
sargos	7	43	1827	3	sargos
scion	7	22	1499	3	sci_on
scoot	7	57	2915	3	s_coot
scot	6	62	4261	3	s__cot
sego	5	65	2518	3	s_ego_
segos	6	49	1948	3	s_egos
seisor	6	37	1234	3	seisor
seizor	15	42	853	3	seizor
serpigo	10	4	483	3	serpigo_
serpigos	11	4	384	3	serpigos
sexpot	15	3	954	3	sexpot
shiest	9	58	2152	3	shiest
shift	11	42	2514	3	shi_ft
shirt	8	45	3390	3	shi_rt
shist	8	48	2961	3	shi_st
shit	7	67	4594	3	shi__t
shoot	8	42	3591	3	s_hoot
shot	7	61	5026	3	s__hot
sift	7	107	4066	3	s_i_ft
sigh	8	56	2589	3	s_ig_h
sighs	9	54	1674	3	s_ighs
sights	10	38	1801	3	s_ights
sigil	6	35	1550	3	s_igil
sigla	6	45	1520	3	s_igla
sigloi	7	3	774	3	s_igloi
siglos	7	3	1147	3	s_iglos
sigma	8	45	1383	3	s_igma
sign	5	55	2305	3	s_ig_n
signa	6	61	1470	3	s_igna
signet	7	36	2115	3	s_ignet
signor	7	35	1035	3	s_ignor
signs	6	55	1632	3	s_igns
silo	4	60	3791	3	s_ilo_
silos	5	60	2943	3	s_ilos
silt	4	65	5819	3	s_i_lt
siphon	11	3	846	3	siphon
sippet	10	35	1939	3	sippet
sit	3	58	7775	3	s_i__t
skibob	14	3	342	3	skibob
skidoo	11	3	609	3	skidoo
skimo	11	63	1254	3	skimo_
skimos	12	54	880	3	skimos
skint	9	56	2922	3	ski_nt
skirt	9	56	2466	3	ski_rt
skit	8	54	3753	3	ski__t
sleight	11	27	902	3	sleight
sliest	6	66	2195	3	sliest
slights	11	28	1072	3	slights
slipout	9	4	908	3	slipout
slipt	7	66	2748	3	sli_pt
slit	4	62	5010	3	sli__t
slot	4	60	4983	3	s__lot
smit	6	51	3841	3	smi__t
sniglet	8	36	1241	3	sniglet
snit	4	63	4247	3	sni__t
snoot	5	50	3014	3	s_noot
snot	4	47	4545	3	s__not
soigne	7	43	1003	3	soigne
soot	4	57	6106	3	s__oot
sorgo	6	47	1972	3	sorgo_
sorgos	7	45	1466	3	sorgos
sot	3	103	8430	3	s___ot
sought	10	63	1505	3	sought
spado	8	37	1370	3	spado_
spait	7	56	3160	3	sp_ait
spambot	13	4	591	3	spambot
spat	6	65	4852	3	sp__at
spelt	7	54	3019	3	sp_elt
spent	7	55	3283	3	sp_ent
spic	8	52	2743	3	spi__c
spica	9	47	1794	3	spi_ca
spicae	10	43	1370	3	spicae
spicas	10	47	1582	3	spicas
spicate	11	32	1419	3	spicate
spice	9	55	2881	3	spi_ce
spiced	11	52	1831	3	spiced
spicer	10	47	1931	3	spicer
spices	10	43	2603	3	spices
spicey	13	44	1423	3	spicey
spick	13	45	1907	3	spi_ck
spicks	14	48	1499	3	spicks
spics	9	41	2324	3	spi_cs
spicy	12	54	1771	3	spi_cy
spider	9	45	1680	3	spider
spied	8	54	2771	3	spi_ed
spiegel	10	3	455	3	spiegel
spiel	7	46	2391	3	spi_el
spiels	8	53	1795	3	spiels
spier	7	57	2803	3	spi_er
spiers	8	44	2174	3	spiers
spies	7	60	3762	3	spi_es
spiff	13	36	1640	3	spi_ff
spiffs	14	32	847	3	spiffs
spiffy	17	32	622	3	spiffy
spik	10	54	1971	3	spi__k
spike	11	49	2284	3	spi_ke
spiked	13	49	1555	3	spiked
spiker	12	43	1566	3	spiker
spikes	12	45	2071	3	spikes
spikey	15	54	1133	3	spikey
spiks	11	41	1747	3	spi_ks
spiky	14	60	1411	3	spi_ky
spile	7	52	3008	3	spi_le
spiled	9	46	2199	3	spiled
spiles	8	42	2791	3	spiles
spill	7	48	2116	3	spi_ll
spills	8	47	1746	3	spills
spilth	11	46	973	3	spilth
spin	6	62	3130	3	spi__n
spinal	8	49	1531	3	spinal
spinate	9	31	1481	3	spinate
spine	7	65	3442	3	spi_ne
spined	9	54	2394	3	spined
spinel	8	53	1733	3	spinel
spines	8	51	3203	3	spines
spinets	9	47	1481	3	spinets
spinny	11	45	1018	3	spinny
spinoff	15	4	493	3	spinoff
spinors	9	3	942	3	spinors
spinose	9	3	794	3	spinose
spinous	9	3	1044	3	spinous
spinouts	10	3	602	3	spinouts
spins	7	53	2798	3	spi_ns
spintos	9	3	913	3	spintos
spiny	10	49	2130	3	spi_ny
spiral	8	37	1534	3	spiral
spirant	9	8	1429	3	spirant
spire	7	58	2869	3	spi_re
spirea	8	40	1563	3	spirea
spired	9	49	2186	3	spired
spirem	10	42	1416	3	spirem
spires	8	46	2811	3	spires
spirits	9	41	1262	3	spirits
spiroid	10	21	982	3	spiroid
spirts	8	53	1713	3	spirts
spiry	10	50	1735	3	spi_ry
spital	8	38	1387	3	spital
spite	7	54	3066	3	spi_te
spited	9	48	2044	3	spited
spites	8	41	2733	3	spites
spits	7	44	2955	3	spi_ts
spitz	16	60	1797	3	spi_tz
spiv	9	59	1779	3	spi__v
spivs	10	51	1424	3	spi_vs
spivvy	17	3	321	3	spivvy
splat	7	61	2934	3	sp_lat
splent	8	47	2019	3	splent
splint	8	52	2328	3	splint
split	7	57	2901	3	sp_lit
spoilt	8	50	1659	3	spoilt
spoof	10	50	1901	3	sp_oof
spook	11	54	1604	3	sp_ook
spool	7	52	1904	3	sp_ool
spoon	7	47	1944	3	sp_oon
spoor	7	50	1635	3	sp_oor
sport	7	59	3598	3	sp_ort
spots	7	44	2411	3	sp__ots
spout	7	50	2963	3	sp_out
sprat	7	66	3597	3	sp_rat
sprent	8	45	2238	3	sprent
spriest	9	27	1864	3	spriest
sprig	8	56	1774	3	sprig__
spriggy	14	37	421	3	spriggy
sprights	14	16	714	3	sprights
sprigs	9	48	1477	3	sprig_s
sprint	8	45	2679	3	sprint
sprit	7	67	3640	3	sp_rit
sprout	8	4	1940	3	sprout
spurt	7	72	2798	3	sp_urt
stigma	9	22	676	3	stigma
stilt	5	48	3198	3	sti_lt
stingo	7	42	1216	3	stingo_
stingos	8	45	945	3	stingos
stint	5	70	3766	3	sti_nt
stot	4	63	4733	3	s__tot
sublot	8	23	1552	3	sublot
suint	5	56	3818	3	sui_nt
suit	4	56	4987	3	sui__t
suitor	6	33	1105	3	suitor
sukkot	9	3	664	3	sukkot
swift	11	68	1805	3	swi_ft
swig	8	58	1802	3	swig__
swigs	9	62	1366	3	swig_s
swivet	12	36	1547	3	swivet
swot	7	51	3466	3	s__wot
tight	9	36	2650	3	_tight
tigon	6	39	1444	3	_tigon
tricot	8	3	1775	3	tricot
trigo	6	57	1605	3	trigo_
trigon	7	45	1310	3	trigon
trigos	7	42	1417	3	trigos
ungot	6	17	1806	3	_ungot
upgirt	9	11	726	3	upgirt
uplight	13	16	736	3	uplight
upright	13	17	829	3	upright
uproot	8	3	1412	3	uproot
upshot	11	3	845	3	upshot
uptight	13	17	603	3	uptight
vigor	9	26	1242	3	_vigor
weight	13	39	1418	3	weight
wight	12	37	2557	3	_wight
wright	13	37	1351	3	wright

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.373	479064.3
2	DLD Change Limit	112716	317	4.940	22817.0
3	Display Results	317	317	0.093	3408.6
	(SQL Overall)	178691	317	5.406	33054.2