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

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

281 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
congii	9	5	736	(None)
confit	11	33	1640	2	confit
conga	8	54	1987	2	cong_a
congas	9	44	1703	2	congas
conge	8	52	2759	2	cong_e
congee	9	60	2447	2	congee
conger	9	50	2427	2	conger
conges	9	49	2817	2	conges
congius	10	32	1007	2	congius
congo	8	56	2313	2	cong_o
congos	9	42	1988	2	congos
congou	9	43	1324	2	congou
coni	6	55	3480	2	con__i
conic	9	53	2979	2	con_ic
conin	7	62	3272	2	con_in
conoid	9	8	1888	2	conoid
corgi	8	3	1608	2	corg_i
corgis	9	3	1441	2	corgis
hongi	9	67	1587	2	hong_i
pongid	10	41	1158	2	pongid
bogie	8	95	2410	3	bo_gie
bonaci	10	3	1096	3	bonaci
bong	7	56	3341	3	bong__
bonged	10	57	1960	3	bonged
bonging	11	33	1637	3	bonging
bongo	8	57	2094	3	bong_o
bongos	9	53	1665	3	bongos
bongs	8	78	2842	3	bong_s
bonnie	8	53	1485	3	bonnie
bonsai	8	3	846	3	bonsai
boogie	9	35	1599	3	boogie
bougie	9	36	1327	3	bougie
candid	10	45	1785	3	candid
cangue	9	10	1244	3	cangue
canid	8	55	2634	3	can_id
cannie	8	38	1936	3	cannie
canthi	11	3	1097	3	canthi
cantic	10	39	2054	3	cantic
centai	8	48	1478	3	centai
clonic	10	49	1467	3	clon_ic
coati	7	56	2464	3	co_ati
coatis	8	51	2260	3	coatis
cobia	9	41	1751	3	co_bia
cocain	10	13	1501	3	cocain
cocci	8	28	1267	3	co_cci
coccic	8	29	894	3	coccic
coccid	10	29	1074	3	coccid
cochin	13	13	1320	3	cochin
codeia	9	41	1219	3	codeia
codein	9	49	1672	3	codein
codger	10	58	1487	3	codger
codlin	9	45	1644	3	codlin
coedit	9	3	1624	3	coedit
coenuri	9	4	545	3	coenuri
coffin	14	33	981	3	coffin
cog	6	95	5290	3	co_g__
cogged	11	64	1661	3	cogged
cogging	12	35	1371	3	cogging
cogito	9	3	920	3	co_gito
cognac	11	5	727	3	cognac
cognise	10	5	968	3	cognise
cognize	19	5	768	3	cognize
cogon	8	91	2090	3	co_gon
cogs	7	73	4003	3	co_g_s
coheir	11	3	758	3	coheir
coif	9	63	3791	3	co__if
coign	8	50	1391	3	coig_n
coigne	9	46	1219	3	coigne
coigns	9	44	1006	3	coigns
coil	6	64	3965	3	co__il
coin	6	66	4535	3	co__in
coir	6	63	2724	3	co__ir
cojoin	15	3	950	3	cojoin
colic	9	57	2617	3	co_lic
colin	7	62	3169	3	co_lin
collie	8	36	2199	3	collie
colobi	10	50	1108	3	colobi
coloni	8	56	1920	3	coloni
comfit	13	31	1242	3	comfit
comic	11	47	2181	3	co_mic
comix	16	35	1320	3	co_mix
commie	12	42	1552	3	commie
commit	12	40	1670	3	commit
commix	19	40	776	3	commix
con	5	102	6802	3	con___
conceit	11	32	1807	3	conceit
conch	12	46	2007	3	con_ch
concha	13	42	1328	3	concha
conchie	14	33	1268	3	conchie
concho	13	44	1426	3	concho
conchs	13	47	1490	3	conchs
conchy	16	37	1022	3	conchy
concise	11	3	1447	3	concise
concur	10	4	1110	3	concur
condign	11	4	773	3	condign
condo	8	53	2259	3	con_do
condom	11	42	1536	3	condom
condor	9	46	1697	3	condor
condos	9	43	2233	3	condos
conduit	10	7	1308	3	conduit
cone	6	72	5696	3	con__e
coned	8	60	4005	3	con_ed
cones	7	64	5742	3	con_es
coney	10	59	3288	3	con_ey
coneys	11	52	1842	3	coneys
confab	13	4	706	3	confab
confer	11	40	1868	3	confer
confide	13	3	1020	3	confide
confine	12	3	1558	3	confine
confirm	14	3	736	3	confirm
confits	12	28	1142	3	confits
congaed	11	39	974	3	congaed
congaing	12	3	982	3	congaing
congeal	10	40	1168	3	congeal
congeed	11	32	1231	3	congeed
congees	10	35	1792	3	congees
congers	10	42	2323	3	congers
congest	10	46	1877	3	congest
congoes	10	36	1730	3	congoes
congous	10	36	1508	3	congous
conics	10	39	2059	3	conics
conidia	10	6	930	3	conidia
conies	8	43	3859	3	conies
coniine	9	3	1680	3	coniine
conine	8	45	2855	3	conine
coning	9	43	3182	3	coning
conins	8	43	2723	3	conins
conium	10	4	1531	3	conium
conjoin	16	3	820	3	conjoin
conk	10	65	3144	3	con__k
conked	13	50	1911	3	conked
conker	12	47	2155	3	conker
conking	14	36	1845	3	conking
conks	11	55	2570	3	con_ks
conky	14	58	1874	3	con_ky
conn	6	62	2913	3	con__n
conned	9	51	1970	3	conned
conner	8	44	2396	3	conner
conning	10	37	1875	3	conning
connive	12	3	899	3	connive
conns	7	50	2423	3	con_ns
conoids	10	8	1388	3	conoids
cons	6	60	5769	3	con__s
consign	10	3	877	3	consign
consist	9	3	1603	3	consist
consol	8	26	1411	3	consol
consul	8	23	1230	3	consul
contagia	11	5	677	3	contagia
contain	9	3	1583	3	contain
conte	7	66	3320	3	con_te
contes	8	44	3291	3	contes
conto	7	60	2717	3	con_to
contos	8	49	2323	3	contos
contra	8	33	1470	3	contra
conus	7	67	2653	3	con_us
convex	18	36	774	3	convex
convey	14	46	1022	3	convey
convict	14	34	1098	3	convict
convoy	14	34	854	3	convoy
cony	9	65	3783	3	con__y
cookie	12	37	1604	3	cookie
coolie	8	38	2160	3	coolie
coontie	9	3	1142	3	coontie
cootie	8	42	2309	3	cootie
corbie	10	36	1820	3	corbie
coria	7	58	2832	3	co_ria
corrie	8	36	2122	3	corrie
cortin	8	24	2315	3	cortin
corvid	12	3	1047	3	corvid
cosie	7	47	2826	3	co_sie
cosign	9	5	878	3	cosign
cosmic	12	4	1034	3	cosmic
cosmid	11	8	1064	3	cosmid
cougar	9	5	878	3	cougar
cough	11	58	1964	3	coug_h
coughs	12	55	1454	3	coughs
coulis	8	40	1876	3	coulis
council	11	3	747	3	council
cousin	8	5	1716	3	cousin
covin	10	56	2112	3	co_vin
cowgirl	13	5	327	3	cowgirl
cowpie	13	35	1151	3	cowpie
cowrie	11	38	1428	3	cowrie
cozie	16	35	1913	3	co_zie
cynic	12	47	1242	3	cyn_ic
doggie	9	39	1089	3	doggie
dogie	7	52	2279	3	do_gie
dong	6	60	3165	3	dong__
donga	7	67	1842	3	dong_a
dongas	8	49	1461	3	dongas
dongle	8	36	1249	3	dongle
dongs	7	65	2581	3	dong_s
donsie	7	6	1364	3	donsie
fogie	9	67	1900	3	fo_gie
fungi	9	50	1413	3	fung_i
fungic	12	38	781	3	fungic
genii	6	45	1417	3	gen_ii
gingili	9	30	603	3	gingili
gong	6	68	2719	3	gong__
gonged	9	71	1591	3	gonged
gonging	10	37	1303	3	gonging
gongs	7	49	2161	3	gong_s
gonia	6	41	1753	3	gon_ia
gonif	9	43	2092	3	gon_if
hoagie	10	23	1001	3	hoagie
hong	8	58	3395	3	hong__
hongied	12	30	816	3	hongied
hongies	11	27	1647	3	hongies
hongiing	13	3	560	3	hongiing
hongs	9	51	2620	3	hong_s
honkie	13	30	1167	3	honkie
iconic	10	4	1159	3	icon_ic
ionic	7	46	2266	3	ion_ic
loggia	8	45	705	3	loggia
loggie	8	40	1199	3	loggie
logia	6	81	1660	3	lo_gia
logic	8	82	1783	3	lo_gic
login	6	60	2500	3	lo_gin
logoi	6	97	1594	3	lo_goi
long	5	69	3334	3	long__
longan	7	56	1236	3	longan
longe	6	66	2646	3	long_e
longed	8	71	2137	3	longed
longer	7	58	2320	3	longer
longes	7	59	2557	3	longes
longies	8	29	1655	3	longies
longing	9	39	1578	3	longing
longish	11	22	909	3	longish
longly	10	27	960	3	longly
longs	6	55	2706	3	long_s
lungi	6	55	1605	3	lung_i
lungis	7	71	1302	3	lungis
lungyi	10	52	509	3	lungyi
moggie	10	32	1010	3	moggie
monger	9	44	1833	3	monger
mongo	8	101	2241	3	mong_o
mongoe	9	42	1498	3	mongoe
mongol	9	49	1253	3	mongol
mongos	9	43	1862	3	mongos
mongst	9	35	1260	3	mongst
monie	7	56	3165	3	mon_ie
noggin	8	28	888	3	noggin
nongay	10	16	915	3	nongay
noogie	7	36	1231	3	noogie
onagri	7	5	496	3	_onagri
ontic	7	44	1857	3	_ontic
orgic	8	3	1182	3	_orgic
pong	7	62	3114	3	pong__
ponged	10	56	1935	3	ponged
pongee	9	49	2019	3	pongee
pongids	11	34	741	3	pongids
ponging	11	34	1615	3	ponging
pongs	8	55	2634	3	pong_s
pontil	8	3	1546	3	pontil
sengi	6	40	1651	3	seng_i
song	5	51	3367	3	song__
songs	6	77	2555	3	song_s
sonic	7	52	2529	3	son_ic
sonsie	6	6	1486	3	sonsie
spongin	10	3	637	3	spongin
tondi	6	57	1614	3	ton_di
tong	5	64	3435	3	tong__
tonga	6	56	1969	3	tong_a
tongas	7	43	1552	3	tongas
tonged	8	65	1890	3	tonged
tonger	7	47	1968	3	tonger
tonging	9	33	1451	3	tonging
tongs	6	59	2846	3	tong_s
tongue	7	4	1009	3	tongue
tonic	7	47	2765	3	ton_ic
tonsil	6	3	1187	3	tonsil
torii	5	55	2159	3	to_rii
vogie	9	51	1666	3	vo_gie
yogi	8	61	2042	3	yo_g_i
yogic	11	61	1493	3	yo_gic
yogin	9	83	1774	3	yo_gin
yogini	10	44	914	3	yo_gini
yogis	9	56	1774	3	yo_gis
yoni	7	75	2439	3	yon__i
yonic	10	59	2084	3	yon_ic
yonis	8	50	2082	3	yon_is

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.373	479064.3
2	DLD Change Limit	112716	281	6.033	18683.2
3	Display Results	281	281	0.093	3021.5
	(SQL Overall)	178691	281	6.499	27495.2