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

Here are the results of your fuzzy-string dictionary search for “signor” 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
signor	7	35	1035	(None)
signer	7	40	1563	1	signer
signior	8	3	504	1	signior
signora	8	34	850	1	signora
signore	8	32	909	1	signore
signori	8	34	789	1	signori
signors	8	34	1091	1	signors
signory	11	42	752	1	signory
assignor	9	4	299	2	assignor
ignore	7	26	906	2	_ignore
mignon	9	3	795	2	mignon
minor	7	49	2006	2	mi_nor
pignora	10	30	636	2	pignora
rigor	6	27	1405	2	rig_or
segno	6	48	1474	2	segno_
segnos	7	36	1044	2	segnos
seignior	9	4	331	2	seignior
seignory	12	4	416	2	seignory
senor	5	38	2280	2	s_enor
sigher	10	38	1370	2	sigher
sigloi	7	3	774	2	sigloi
siglos	7	3	1147	2	siglos
sign	5	55	2305	2	sign__
signa	6	61	1470	2	sign_a
signal	7	37	1148	2	signal
signed	8	34	1375	2	signed
signee	7	36	1723	2	signee
signers	8	47	1444	2	signers
signet	7	36	2115	2	signet
signiori	9	4	335	2	signiori
signiors	9	4	492	2	signiors
signiory	12	4	356	2	signiory
signoras	9	30	655	2	signoras
signs	6	55	1632	2	sign_s
singer	7	42	2731	2	singer
sinner	6	43	2060	2	sinner
spinor	8	3	994	2	spinor
vigor	9	26	1242	2	vig_or
algor	6	5	1305	3	alg_or
alienor	7	11	630	3	alienor
aligner	8	10	831	3	aligner
assigner	9	4	485	3	assigner
assignors	10	4	324	3	assignors
bigger	10	43	1506	3	bigger
bighorn	13	4	606	3	bighorn
bigos	8	50	2001	3	big_os
bigot	8	48	2832	3	big_ot
biner	7	59	3069	3	bi_ner
binger	9	49	2345	3	binger
bingo	8	60	2009	3	bingo_
bingos	9	55	1479	3	bingos
chignon	13	4	462	3	chignon
cigar	8	9	1180	3	cig_ar
consignor	12	4	411	3	~~con~~signor
cosigner	11	3	595	3	cosigner
designer	10	3	654	3	designer
digger	9	46	1608	3	digger
diglot	8	30	1433	3	diglot
dinar	6	63	1989	3	di_nar
diner	6	56	3290	3	di_ner
dinger	8	53	2367	3	dinger
dingo	7	47	2079	3	dingo_
dinner	7	42	1716	3	dinner
dino	5	60	3675	3	di_no_
dinos	6	54	2806	3	di_nos
donor	6	44	1819	3	_donor
eggnog	9	4	197	3	eggnog
feigner	11	3	559	3	feigner
figwort	14	4	822	3	figwort
finer	8	54	3156	3	fi_ner
finger	10	49	2033	3	finger
fino	7	60	3469	3	fi_no_
finos	8	62	2695	3	fi_nos
giglot	8	40	1313	3	giglot
gigot	7	40	2307	3	gig_ot
ginger	8	49	2003	3	ginger
ginner	7	39	1582	3	ginner
gnar	5	60	2138	3	__gnar
gor	4	78	4826	3	__g_or
higher	13	46	1089	3	higher
hinger	10	47	2333	3	hinger
honor	8	57	1862	3	_honor
ichor	10	3	948	3	_ichor
igloo	6	4	1049	3	_igloo
ignitor	8	12	526	3	_ignitor
ignored	9	22	644	3	_ignored
ignorer	8	27	610	3	_ignorer
ignores	8	26	900	3	_ignores
ingot	6	12	2106	3	_ingot
inner	5	49	2063	3	_inner
inro	4	59	2079	3	_i_nro
jigger	15	53	1305	3	jigger
jingo	13	46	1521	3	jingo_
kino	8	62	3362	3	ki_no_
kinos	9	66	2614	3	ki_nos
kronor	10	41	723	3	kronor
lictor	8	36	1085	3	lictor
liger	6	50	2447	3	lig_er
lignan	7	55	1032	3	lignan
lignin	7	49	1119	3	lignin
limner	8	41	1287	3	limner
liner	5	59	3892	3	li_ner
linger	7	52	2600	3	linger
lingo	6	60	2211	3	lingo_
lino	4	63	4337	3	li_no_
linos	5	56	3150	3	li_nos
liquor	15	3	420	3	liquor
manor	7	80	2393	3	_manor
mignons	10	3	786	3	mignons
miner	7	69	3354	3	mi_ner
minnow	11	3	558	3	minnow
minors	8	51	1710	3	mi_nors
mirror	8	4	800	3	mirror
monsignor	12	5	235	3	~~mon~~signor
nigger	8	97	1357	3	nigger
nigher	10	36	1275	3	nigher
ninon	5	55	1738	3	ni_non
nor	3	80	4882	3	___nor
pawnor	11	35	724	3	pawnor
peignoir	11	4	287	3	peignoir
piano	7	61	1871	3	piano_
pianos	8	43	1593	3	pianos
pigeon	9	4	941	3	pigeon
pignoli	10	4	544	3	pignoli
pignus	9	3	795	3	pignus
pignut	9	3	1157	3	pignut
pinger	9	43	2409	3	pinger
pingo	8	71	2271	3	pingo_
pingos	9	53	1767	3	pingos
pinner	8	45	2150	3	pinner
pinon	7	60	2453	3	pi_non
pinot	7	87	3729	3	pi_not
resigner	9	3	779	3	resigner
rigger	8	56	1671	3	rigger
rigors	7	28	1371	3	rig_ors
rigour	7	25	802	3	rigour
ringer	7	45	2606	3	ringer
sager	6	54	3205	3	sag_er
saggar	8	40	1085	3	saggar
sagger	8	43	2107	3	sagger
sagier	7	37	1716	3	sagier
sago	5	63	3267	3	sag_o_
sagos	6	61	2387	3	sag_os
sailor	6	31	1375	3	sailor
salvor	9	47	1109	3	salvor
saner	5	43	3432	3	s_aner
sangar	7	36	1768	3	sangar
sanger	7	45	2456	3	sanger
sannop	8	3	737	3	sannop
sapor	7	51	1925	3	s_apor
sartor	6	3	1388	3	sartor
savior	9	7	1017	3	savior
savor	8	54	1794	3	s_avor
schnoz	20	3	565	3	schnoz
scissor	9	9	412	3	scissor
sector	8	34	1593	3	sector
seggar	8	35	781	3	seggar
segni	6	37	1248	3	segn_i
sego	5	65	2518	3	seg_o_
segos	6	49	1948	3	seg_os
seigneur	9	4	293	3	seigneur
seigniors	10	4	333	3	seigniors
seigniory	13	4	242	3	seigniory
seiner	6	46	2248	3	seiner
seisor	6	37	1234	3	seisor
seizor	15	42	853	3	seizor
senhor	9	30	1081	3	senhor
senior	6	32	1405	3	senior
senora	6	32	1616	3	s_enora
senors	6	36	2079	3	s_enors
sensor	6	38	1384	3	sensor
shiner	9	38	2087	3	shiner
sicker	12	40	2390	3	sicker
sicko	11	53	1539	3	sicko_
sickos	12	51	1203	3	sickos
siddur	8	3	457	3	siddur
sidler	7	47	1696	3	sidler
sienna	6	4	719	3	sienna
sieur	5	9	1189	3	si_eur
sifter	9	45	1623	3	sifter
siganid	9	4	720	3	siganid
sigh	8	56	2589	3	sig__h
sighed	11	37	1205	3	sighed
sighers	11	37	1218	3	sighers
sighs	9	54	1674	3	sig_hs
sight	9	46	2929	3	sig_ht
sighter	11	34	1211	3	sighter
sights	10	38	1801	3	sights
sigil	6	35	1550	3	sig_il
sigils	7	39	1236	3	sigils
sigla	6	45	1520	3	sig_la
siglum	9	3	656	3	siglum
sigma	8	45	1383	3	sig_ma
sigmas	9	41	1136	3	sigmas
sigmoid	11	4	611	3	sigmoid
signage	9	3	777	3	signage
signaler	9	4	545	3	signaler
signals	8	35	916	3	signals
signatory	13	4	462	3	signatory
signboard	13	4	377	3	signboard
signees	8	35	1080	3	signees
signets	8	33	1150	3	signets
signify	14	4	485	3	signify
signing	9	27	1396	3	signing
signories	10	10	785	3	signor~~ies~~
signorina	10	4	396	3	signor~~ina~~
signorine	10	4	517	3	signor~~ine~~
signpost	11	4	416	3	signpost
siker	9	53	2603	3	si_ker
siller	6	40	2606	3	siller
silo	4	60	3791	3	si_lo_
silos	5	60	2943	3	si_los
silver	9	38	1581	3	silver
simar	7	49	2081	3	si_mar
simmer	10	41	1535	3	simmer
simnel	8	5	702	3	simnel
simony	11	3	790	3	simony
simoom	10	3	750	3	simoom
simoon	8	5	806	3	simoon
simper	10	36	1629	3	simper
sin	3	62	6589	3	si_n__
since	7	50	2417	3	si_nce
sine	4	65	6062	3	si_n_e
sines	5	59	5482	3	si_nes
sinew	8	47	1892	3	si_new
sing	5	75	4417	3	si_n_g
singe	6	57	3113	3	si_nge
singed	8	54	2229	3	singed
singers	8	38	2470	3	singers
singes	7	43	2685	3	singes
single	7	45	2060	3	single
singly	10	40	1585	3	singly
sings	6	55	3270	3	si_ngs
sinh	7	62	3804	3	si_n_h
sinhs	8	67	1960	3	si_nhs
sink	8	66	4014	3	si_n_k
sinker	10	36	2090	3	sinker
sinks	9	55	2918	3	si_nks
sinned	7	38	1841	3	sinned
sinners	7	40	1902	3	sinners
sins	4	67	5527	3	si_n_s
sinter	6	36	2592	3	sinter
sinus	5	55	2385	3	si_nus
siphon	11	3	846	3	siphon
sipper	10	39	2099	3	sipper
sir	3	57	4667	3	si___r
sirdar	7	26	910	3	sirdar
sister	6	44	2158	3	sister
sitar	5	48	2054	3	si_tar
sitcom	10	3	690	3	sitcom
sitter	6	33	2338	3	sitter
siver	8	57	2861	3	si_ver
sixmo	14	4	830	3	sixmo_
sixmos	15	3	481	3	sixmos
sizar	14	52	1499	3	si_zar
sizer	14	55	2181	3	si_zer
sizier	15	148	1339	3	sizier
skinner	11	34	809	3	skinner
slinger	8	34	1383	3	slinger
snigger	9	32	837	3	snigger
snob	6	58	2559	3	s__nob
snog	5	56	2363	3	s__nog
snore	5	54	2495	3	s__nore
snort	5	48	3375	3	s__nort
snot	4	47	4545	3	s__not
snow	7	63	2479	3	s__now
soigne	7	43	1003	3	soign_e
soignee	8	27	913	3	soignee
sonar	5	65	2342	3	s_onar
sooner	6	42	2046	3	sooner
sopor	7	40	1649	3	s_opor
sordor	7	3	1022	3	sordor
sorner	6	47	2039	3	sorner
spigot	9	3	1260	3	spig_ot
spinner	9	39	1226	3	spinner
spinors	9	3	942	3	spinors
sponsor	9	3	497	3	sponsor
spoor	7	50	1635	3	s_poor
stanol	6	3	1072	3	stanol
stator	6	40	1548	3	stator
steno	5	47	1686	3	steno_
stenos	6	39	1577	3	stenos
stentor	7	3	938	3	stentor
stinger	8	43	1468	3	stinger
stingo	7	42	1216	3	stingo_
stingos	8	45	945	3	stingos
stoner	6	58	2320	3	stoner
stupor	8	3	601	3	stupor
succor	10	3	662	3	succor
sudor	6	3	1262	3	s_udor
sugar	6	3	1291	3	sug_ar
suitor	6	33	1105	3	suitor
swigger	12	33	845	3	swigger
swinger	11	38	1256	3	swinger
synod	9	6	1028	3	s_ynod
tenor	5	36	2025	3	_tenor
tiger	6	57	1863	3	tig_er
tiglon	7	3	792	3	tiglon
tigon	6	39	1444	3	tig_on
tigons	7	41	1226	3	tigons
tinner	6	41	1996	3	tinner
viator	9	32	1183	3	viator
victor	11	32	1067	3	victor
vigors	10	29	1148	3	vig_ors
vigour	10	25	680	3	vigour
vino	7	61	2843	3	vi_no_
vinos	8	47	2307	3	vi_nos
visor	8	25	1283	3	vi_sor
vizor	17	30	1009	3	vi_zor
wiener	9	45	1354	3	wiener
wigeon	10	3	722	3	wigeon
winger	10	41	2544	3	winger
winner	9	42	1993	3	winner
winnow	12	3	459	3	winnow
wino	7	59	3361	3	wi_no_
winos	8	46	2504	3	wi_nos
zinger	16	38	1670	3	zinger

Search took 7 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.406	440125.6
2	DLD Change Limit	112716	317	5.610	20092.0
3	Display Results	317	317	0.110	2881.8
	(SQL Overall)	178691	317	6.126	29169.3