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

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

339 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
assign	7	3	678	(None)
assigns	8	3	619	1	assigns
align	6	50	1650	2	a_lign
ashing	10	78	2409	2	ashing
asking	11	60	1723	2	asking
assignat	9	4	568	2	assignat
assigned	10	4	463	2	assigned
assignee	9	4	484	2	assignee
assigner	9	4	485	2	assigner
assignor	9	4	299	2	assignor
assist	6	3	1460	2	assist
assize	15	3	863	2	assize
cosign	9	5	878	2	cosign
design	8	40	893	2	design
ensign	7	3	752	2	ensign
gassing	9	42	1633	2	gassing
massing	10	43	1802	2	massing
passing	10	43	1842	2	passing
passion	9	3	1088	2	passion
reassign	9	5	542	2	reassign
resign	7	42	1258	2	resign
sasin	5	46	2657	2	sasi_n
sassing	8	46	1555	2	sassing
sign	5	55	2305	2	__sign
aahing	10	190	1576	3	aahing
abasing	10	6	1067	3	abasing
abusing	10	4	911	3	abusing
abying	12	44	1041	3	abying
aching	12	65	2197	3	aching
acing	8	74	2915	3	a_cing
actin	7	49	2255	3	acti_n
acting	9	59	2098	3	acting
action	8	47	1968	3	action
adding	9	39	1496	3	adding
adzing	17	41	1001	3	adzing
again	6	52	1812	3	agai_n
ageing	8	42	1340	3	ageing
agin	5	61	3271	3	a_gi_n
aging	7	70	2635	3	a_ging
ahing	9	89	2835	3	a_hing
aiding	8	44	2361	3	aiding
ailing	7	43	3101	3	ailing
aiming	9	43	2084	3	aiming
ain	3	75	7909	3	a__i_n
airing	7	49	2750	3	airing
airn	4	64	3383	3	a__irn
akin	8	63	2803	3	a_ki_n
algin	6	57	1876	3	algi_n
alien	5	64	2558	3	a_lien
aligns	7	53	1295	3	a_ligns
aloin	5	52	2742	3	aloi_n
alsike	10	4	791	3	alsike
amain	7	49	2291	3	amai_n
amassing	11	3	800	3	amassing
amiga	8	55	1481	3	a_miga
amigo	8	65	1547	3	a_migo
amin	6	60	4225	3	a_mi_n
amnion	8	48	1205	3	amnion
amping	11	43	1757	3	amping
amusing	10	3	938	3	amusing
anion	5	50	2881	3	a_nion
antigen	8	3	1112	3	antigen
antigun	8	4	796	3	antigun
anting	7	58	2702	3	anting
apian	7	50	1833	3	a_pian
aping	8	73	2723	3	a_ping
apsis	7	57	1829	3	apsi_s
arcing	9	58	1964	3	arcing
arisen	6	53	1679	3	arisen
arising	8	36	1997	3	arising
arming	9	47	1980	3	arming
arraign	8	4	506	3	arraign
arshin	9	3	1217	3	arshin
arsine	6	40	2104	3	arsine
arsino	6	41	1351	3	arsino
arsis	5	57	2242	3	arsi_s
arson	5	51	1883	3	ars_on
asci	6	65	1914	3	asci__
asdic	8	38	1409	3	asdi_c
asdics	9	43	986	3	asdics
ashcan	11	3	584	3	ashcan
ashen	8	78	1867	3	a_shen
ashier	9	47	1483	3	ashier
ashman	11	4	838	3	ashman
ashmen	11	6	817	3	ashmen
aside	6	51	2208	3	a_side
askings	12	51	917	3	askings
aspen	7	52	1609	3	a_spen
aspic	9	51	1473	3	aspi_c
aspics	10	42	1156	3	aspics
aspire	8	6	1212	3	aspire
aspirin	9	3	782	3	aspirin
aspis	7	46	1814	3	aspi_s
aspish	11	48	1033	3	aspish
ass	3	78	4406	3	ass___
assagai	8	4	390	3	assagai
assai	5	7	1154	3	ass_ai
assail	6	6	1015	3	assail
assails	7	6	909	3	assails
assais	6	7	1196	3	assais
assay	8	7	1028	3	ass_ay
assaying	12	3	600	3	assaying
assays	9	7	790	3	assays
assegai	8	4	335	3	assegai
assent	6	51	1995	3	assent
assert	6	49	2257	3	assert
asses	5	56	2928	3	ass_es
assess	6	57	1046	3	assess
asset	5	59	3226	3	ass_et
assets	6	56	1766	3	assets
assignats	10	4	400	3	assign~~ats~~
assignees	10	4	350	3	assign~~ees~~
assigners	10	4	441	3	assign~~ers~~
assigning	11	4	467	3	assigning
assignors	10	4	324	3	assign~~ors~~
assists	7	3	847	3	assists
assizes	16	3	845	3	assizes
asslike	11	3	737	3	asslike
assoil	6	8	854	3	assoil
assoils	7	7	666	3	assoils
assort	6	49	1637	3	assort
assuage	8	3	568	3	assuage
assume	8	9	756	3	assume
assuming	11	3	514	3	assuming
assure	6	6	1077	3	assure
assuring	9	3	777	3	assuring
asswage	11	4	467	3	asswage
astern	6	48	1581	3	astern
astir	5	55	1709	3	asti_r
aswirl	9	3	509	3	aswirl
aswoon	9	4	701	3	aswoon
auding	8	36	1693	3	auding
auxin	12	14	1191	3	auxi_n
avian	8	46	1605	3	a_vian
avion	8	42	1834	3	a_vion
aweigh	13	3	493	3	aweigh
aweing	10	39	1125	3	aweing
awing	9	68	2732	3	a_wing
awning	10	50	1339	3	awning
axing	13	85	2137	3	a_xing
axion	12	113	1691	3	a_xion
ayin	7	63	3174	3	a_yi_n
bashing	13	54	2258	3	bashing
basin	7	50	2692	3	basi_n
basing	9	54	2766	3	basing
basion	8	43	1585	3	basion
basking	14	47	1861	3	basking
bassi	7	70	1932	3	bassi__
bassist	9	3	1274	3	bassist
bassoon	9	3	761	3	bassoon
basting	10	42	2720	3	basting
bastion	9	3	1247	3	bastion
benign	9	3	831	3	benign
biassing	11	30	726	3	biassing
bossing	10	37	1460	3	bossing
brassing	11	26	1230	3	brassing
busing	9	64	2059	3	busing
bussing	10	36	1462	3	bussing
casein	8	32	1645	3	casei_n
cashing	13	50	2255	3	cashing
casing	9	48	2910	3	casing
casking	14	43	1735	3	casking
cassia	8	37	1476	3	cassi_a
cassias	9	35	1434	3	cassias
cassina	9	41	1316	3	cassina
cassine	9	38	1728	3	cassine
cassino	9	35	1243	3	cassino
cassis	8	48	1885	3	cassi_s
casting	10	46	2834	3	casting
causing	10	36	1441	3	causing
cessing	10	38	1481	3	cessing
cession	9	3	981	3	cession
classing	11	32	1179	3	classing
coign	8	50	1391	3	_coign
consign	10	3	877	3	consign
cosigns	10	4	751	3	cosigns
cussing	10	38	1427	3	cussing
dashing	12	59	1789	3	dashing
dassie	7	46	1557	3	dassi_e
dassies	8	44	1866	3	dassies
deign	7	43	1280	3	_deign
designs	9	32	831	3	designs
dissing	9	45	1768	3	dissing
dosing	8	39	2027	3	dosing
dossing	9	33	1327	3	dossing
easing	7	49	2646	3	easing
easting	8	49	2430	3	easting
eloign	7	45	698	3	eloign
ensigns	8	3	635	3	ensigns
eosin	5	52	2092	3	eosi_n
essoin	6	3	819	3	essoin
fashing	14	49	1879	3	fashing
fashion	13	3	784	3	fashion
fasting	11	45	2283	3	fasting
feign	9	42	1071	3	_feign
fessing	11	38	1286	3	fessing
fission	10	3	873	3	fission
fusing	10	44	1595	3	fusing
fusion	9	3	977	3	fusion
fussing	11	36	1168	3	fussing
gashing	12	51	1923	3	gashing
gaskin	11	36	1058	3	gaski_n
gasking	13	44	1591	3	gasking
gasping	11	37	1436	3	gasping
gassier	8	38	1257	3	gassier
gassily	11	3	781	3	gassily
gassings	10	43	840	3	gassings
gasting	9	50	2276	3	gasting
glassing	10	32	997	3	glassing
grassing	10	33	1197	3	grassing
hashing	14	50	2016	3	hashing
hasping	13	44	1490	3	hasping
hassium	12	3	613	3	hassium
hassling	12	3	680	3	hassling
hasting	11	47	2519	3	hasting
hessian	10	3	585	3	hessian
hissing	11	42	1314	3	hissing
hosing	10	34	2110	3	hosing
indign	8	30	847	3	indign
insigne	8	3	767	3	insigne
isling	7	12	1388	3	isling
issuing	8	3	605	3	issuing
jasmin	15	3	807	3	jasmi_n
jassid	14	6	722	3	jassi_d
jassids	15	8	614	3	jassids
jessing	15	37	1062	3	jessing
kamsin	12	3	832	3	kamsi_n
kissing	12	29	1105	3	kissing
lapsing	10	35	1116	3	lapsing
lashing	11	44	2289	3	lashing
lasing	7	47	2798	3	lasing
lassi	5	63	1685	3	lassi__
lassie	6	49	1774	3	lassi_e
lassies	7	44	2010	3	lassies
lassis	6	52	1670	3	lassi_s
lassoing	9	4	638	3	lassoing
lasting	8	47	2524	3	lasting
lesion	6	47	1506	3	lesion
losing	7	40	2287	3	losing
lysin	8	45	1278	3	lysi_n
lysing	10	47	1044	3	lysing
malign	9	3	985	3	malign
mansion	9	6	1154	3	mansion
mashing	13	44	2224	3	mashing
masking	14	51	1661	3	masking
massage	10	3	989	3	massage
massier	9	36	1522	3	massier
massif	11	4	1253	3	massi_f
massifs	12	3	774	3	massifs
massive	12	28	977	3	massive
masting	10	43	2582	3	masting
mesian	8	43	1550	3	mesian
messing	10	39	1639	3	messing
misassign	12	4	322	3	~~mis~~assign
missing	10	36	1907	3	missing
mission	9	3	1274	3	mission
mossing	10	39	1542	3	mossing
musing	9	39	1950	3	musing
mussing	10	40	1554	3	mussing
nasion	6	39	1408	3	nasion
nosing	7	34	1984	3	nosing
opsin	7	6	1347	3	opsi_n
ossein	6	3	659	3	ossein
ossia	5	37	1040	3	ossi_a
ossify	12	4	497	3	ossify
parsing	10	38	1955	3	parsing
pashing	13	51	2051	3	pashing
passage	10	3	980	3	passage
passim	10	4	1028	3	passi_m
passings	11	40	987	3	passings
passions	10	3	1058	3	passions
passive	12	23	959	3	passive
pasting	10	38	2655	3	pasting
pausing	10	39	1281	3	pausing
pissing	10	39	1480	3	pissing
posing	9	39	2264	3	posing
preassign	12	4	457	3	~~pre~~assign
quassin	16	4	594	3	quassi_n
raisin	6	27	1692	3	raisi_n
raising	8	32	2053	3	raising
rasing	7	43	3083	3	rasing
rasping	10	43	1625	3	rasping
rassling	9	3	901	3	rassling
reassigns	10	7	435	3	reassigns
reign	6	50	1519	3	_reign
resigns	8	39	1096	3	resigns
resin	5	41	3105	3	resi_n
rising	7	40	2588	3	rising
rosin	5	53	2531	3	rosi_n
rosing	7	39	2559	3	rosing
sabin	7	49	2495	3	sabi_n
saiga	6	47	1793	3	_saiga
sain	4	55	5129	3	_sai_n
saning	7	51	2764	3	saning
sarin	5	52	3925	3	sari_n
sashing	11	46	2147	3	sashing
sasins	6	49	2310	3	sasins
sassier	7	34	1323	3	sassier
sassies	7	47	1926	3	sassies
sassily	10	3	872	3	sassily
satin	5	59	3521	3	sati_n
sating	7	47	3545	3	sating
savin	8	46	2508	3	savi_n
saving	10	47	2451	3	saving
sawing	10	43	2381	3	sawing
saying	10	43	2554	3	saying
scion	7	22	1499	3	_scion
session	7	3	976	3	session
shin	7	56	3430	3	_shi_n
sigh	8	56	2589	3	__sigh
signa	6	61	1470	3	__signa
signs	6	55	1632	3	__signs
sin	3	62	6589	3	__si_n
sing	5	75	4417	3	__sing
skin	8	59	2752	3	_ski_n
sling	6	60	2880	3	_sling
soigne	7	43	1003	3	_soigne
spin	6	62	3130	3	_spi_n
sting	6	53	3024	3	_sting
suing	6	50	2636	3	_suing
sussing	8	40	1370	3	sussing
swig	8	58	1802	3	_swig_
swigs	9	62	1366	3	_swigs
swing	9	61	2484	3	_swing
tasking	12	46	1632	3	tasking
tassie	6	60	1702	3	tassi_e
tassies	7	49	1893	3	tassies
tasting	8	46	2421	3	tasting
tawsing	11	3	867	3	tawsing
tossing	8	36	1256	3	tossing
tsking	11	42	1042	3	tsking
using	6	63	1796	3	_using
vising	10	39	1587	3	vising
vision	9	3	1131	3	vision
washing	14	51	1928	3	washing
wasting	11	44	2284	3	wasting
wising	10	33	1822	3	wising
wissing	11	32	1294	3	wissing
yessing	11	32	1006	3	yessing

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.123	1452772.4
2	DLD Change Limit	112716	339	6.313	17854.6
3	Display Results	339	339	0.110	3081.8
	(SQL Overall)	178691	339	6.546	27297.7