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

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

332 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
profit	11	30	1627	(None)
probit	10	32	1835	1	probit
profits	12	29	1124	1	profits
prosit	8	51	2459	1	prosit
croft	10	56	2268	2	crof_t
droit	6	51	2712	2	dro_it
posit	7	58	3333	2	p_osit
prefix	18	35	685	2	prefix
probits	11	27	1257	2	probits
probity	14	29	968	2	probity
prof	9	61	3466	2	prof__
profile	12	32	1115	2	profile
profited	14	27	997	2	profited
profiter	13	27	1020	2	profiter
profs	10	51	2089	2	prof_s
projet	15	3	1518	2	projet
prolix	15	3	868	2	prolix
prompt	12	3	1301	2	prompt
prost	7	54	3410	2	pro_st
protist	9	3	2022	2	protist
refit	8	42	3006	2	_refit
adroit	7	5	1878	3	adro_it
aloft	8	4	2343	3	alof_t
aprotic	11	27	1523	3	aprotic
armpit	10	8	1109	3	armpit
aroid	6	54	2833	3	aro_id
aroint	6	3	2815	3	aroint
aroynt	9	3	1289	3	aroynt
barefit	12	4	972	3	barefit
befit	10	52	2266	3	_befit
brit	6	63	5015	3	br__it
broil	7	49	1822	3	bro_il
bromic	12	24	1269	3	bromic
bromid	11	26	1289	3	bromid
bromin	10	26	1569	3	bromin
bruit	7	61	2672	3	br_uit
coft	9	79	3968	3	_cof_t
comfit	13	31	1242	3	comfit
confit	11	33	1640	3	confit
craft	10	53	2766	3	craf_t
credit	9	3	1519	3	credit
crit	6	57	4371	3	cr__it
croci	9	58	1813	3	croci_
crofts	11	49	1059	3	crofts
crojik	19	3	411	3	crojik
doit	5	63	4785	3	_do_it
draft	9	55	2668	3	draf_t
drift	9	57	2284	3	drif_t
droid	7	42	1853	3	dro_id
droits	7	43	1431	3	dro_its
dropt	8	69	2443	3	dro_pt
erotic	8	26	2026	3	erotic
fit	6	63	6545	3	___fit
forfeit	13	3	920	3	forfeit
forrit	9	19	1662	3	forrit
frit	7	70	4447	3	fr__it
frolic	11	4	920	3	frolic
front	8	50	2922	3	fro_nt
frost	8	47	2783	3	fro_st
frowst	12	55	1207	3	frowst
fruit	8	51	2222	3	fr_uit
graft	9	53	2720	3	graf_t
grift	9	59	2446	3	grif_t
grit	5	52	4724	3	gr__it
groat	6	55	3197	3	gro_at
groin	6	55	2108	3	gro_in
grot	5	59	4205	3	gro__t
grout	6	53	3042	3	gro_ut
haffit	15	3	853	3	haffit
ironic	8	3	1377	3	ironic
ironist	7	3	1484	3	ironist
kraft	12	57	2101	3	kraf_t
krait	9	47	2677	3	kr_ait
loft	7	65	3914	3	_lof_t
misfit	11	28	1383	3	misfit
nonprofit	14	5	454	3	~~non~~profit
obit	6	68	3707	3	__obit
oft	6	77	4406	3	__of_t
omit	6	53	3736	3	__omit
orbit	7	36	2205	3	or_bit
outfit	9	30	1494	3	outfit
pandit	9	38	2075	3	pandit
parfait	12	3	1205	3	parfait
parodic	12	23	1172	3	parodic
parodist	11	4	1276	3	parodist
parotic	11	25	1803	3	parotic
parotid	10	29	1550	3	parotid
peewit	11	11	1090	3	peewit
permit	10	3	2168	3	permit
peroxid	17	3	1026	3	peroxid
petit	7	43	3265	3	p_etit
pewit	10	46	2279	3	p_ewit
pfft	12	3	1188	3	p__fft
phobia	13	27	859	3	phobia
phobic	15	30	1006	3	phobic
phonic	13	33	1520	3	phonic
phot	9	55	3435	3	pho__t
photic	13	33	1642	3	photic
piolet	8	32	2564	3	piolet
pionic	10	35	1595	3	pionic
piosity	12	6	864	3	piosity
pipit	9	52	2487	3	p_ipit
pirogi	9	29	901	3	pirogi_
pit	5	64	7192	3	p___it
plait	7	56	3157	3	p_lait
plot	6	61	4123	3	plo__t
podia	8	4	1528	3	p_odia
podite	9	33	1535	3	p_odite
poet	6	55	5290	3	p_o_et
poi	5	72	4466	3	p_o_i_
point	7	53	3873	3	p_oint
pois	6	65	3904	3	p_o_is
polio	7	57	2255	3	p_olio
polis	7	47	3116	3	p_olis
polite	8	36	2507	3	p_olite
polity	11	30	1586	3	p_olity
poof	9	55	4166	3	poof__
poofs	10	52	2279	3	poof_s
poofy	13	62	1327	3	poof_y
poori	7	48	1623	3	poori_
pooris	8	39	1684	3	pooris
porosity	13	4	859	3	porosity
port	6	60	5963	3	p_o_rt
posits	8	57	1871	3	p_osits
post	6	79	5336	3	p_o_st
pot	5	80	7843	3	p_o__t
poult	7	69	2887	3	p_oult
pout	6	57	5255	3	p_o_ut
prat	6	59	5204	3	pr__at
praxis	15	40	1225	3	praxis
preact	10	32	2039	3	preact
prebid	11	35	1284	3	prebid
precis	10	34	1670	3	precis
precut	10	20	1653	3	precut
predict	12	3	1532	3	predict
preedit	10	5	1245	3	preedit
prefab	13	3	624	3	prefab
prefect	14	10	1107	3	prefect
prefer	11	38	1320	3	prefer
prefight	17	4	639	3	prefight
prefile	12	34	1318	3	prefile
prefire	12	40	1281	3	prefire
prelim	10	3	1142	3	prelim
premie	10	36	1799	3	premie
premix	17	37	1033	3	premix
premixt	18	35	1066	3	premixt
preriot	9	3	1641	3	preriot
preset	8	44	3098	3	preset
presift	12	3	1222	3	presift
prest	7	57	3635	3	pr_est
priest	8	41	2542	3	priest
prig	7	59	2487	3	pr__ig
prim	8	51	3220	3	pr__im
primi	9	50	1740	3	primi_
print	7	48	3746	3	pr_int
priority	13	4	744	3	priority
privet	11	38	2134	3	privet
privity	15	26	831	3	privity
pro	5	58	3726	3	pro___
proa	6	62	2996	3	pro__a
proas	7	50	2880	3	pro_as
probate	11	4	1448	3	probate
probe	9	43	2081	3	pro_be
probed	11	41	1482	3	probed
prober	10	45	1607	3	prober
probes	10	41	1945	3	probes
probing	12	33	1444	3	probing
prod	7	61	2950	3	pro__d
prodigy	14	3	557	3	prodigy
prods	8	55	2355	3	pro_ds
product	12	7	923	3	product
proem	9	48	1827	3	pro_em
proems	10	47	1116	3	proems
proette	9	3	1236	3	proette
profane	12	21	1186	3	profane
profanity	17	4	479	3	profanity
profess	12	3	771	3	profess
proffer	15	12	693	3	proffer
profiled	14	33	852	3	profiled
profiler	13	28	764	3	profiler
profiles	13	32	1123	3	profiles
profiteer	14	27	449	3	profit~~eer~~
profiters	14	22	831	3	profit~~ers~~
profiting	15	4	998	3	profit~~ing~~
profuse	12	3	715	3	profuse
prog	7	57	2900	3	pro__g
progs	8	66	2415	3	pro_gs
progun	9	6	878	3	progun
prohibit	15	4	719	3	prohibit
project	18	3	845	3	project
projets	16	3	916	3	projets
prolan	8	4	1469	3	prolan
prolate	9	4	1979	3	prolate
prole	7	45	2779	3	pro_le
proleg	9	46	1211	3	proleg
proles	8	46	2720	3	proles
prolific	15	4	674	3	prolific
proline	9	23	2159	3	proline
prolog	9	42	1297	3	prolog
prom	8	76	3169	3	pro__m
promine	11	28	1944	3	promine
promise	11	34	1584	3	promise
promo	9	56	1999	3	pro_mo
promos	10	51	1642	3	promos
promote	11	3	1314	3	promote
prompts	13	3	747	3	prompts
proms	9	54	2640	3	pro_ms
pronate	9	4	1887	3	pronate
prone	7	53	3262	3	pro_ne
prong	8	52	1811	3	pro_ng
prongs	9	43	1448	3	prongs
pronota	9	3	976	3	pronota
pronto	8	3	1399	3	pronto
proof	10	52	2153	3	pro_of
proofed	13	13	872	3	proofed
proofer	12	14	910	3	proofer
proofing	14	3	931	3	proofing
proofs	11	45	1168	3	proofs
prop	8	59	3281	3	pro__p
propel	10	37	1406	3	propel
proper	10	43	1995	3	proper
prophet	14	3	1603	3	prophet
propine	11	30	2021	3	propine
propjet	18	3	991	3	propjet
propria	11	4	993	3	propria
props	9	57	2688	3	pro_ps
propyl	13	35	818	3	propyl
prorate	9	4	1873	3	prorate
pros	6	57	4278	3	pro__s
prosaic	11	3	1116	3	prosaic
prosaist	10	6	1158	3	prosaist
prose	7	58	3512	3	pro_se
prosect	11	3	1339	3	prosect
prosed	9	49	2109	3	prosed
proser	8	42	2346	3	proser
proses	8	47	3347	3	proses
prosier	9	38	1748	3	prosier
prosiest	10	4	1652	3	prosiest
prosily	12	6	1163	3	prosily
prosing	10	33	1938	3	prosing
proso	7	72	2241	3	pro_so
prosos	8	57	1855	3	prosos
pross	7	65	2940	3	pro_ss
prossie	9	18	1295	3	prossie
prostie	9	16	1774	3	prostie
prosy	10	63	1925	3	pro_sy
protea	8	22	1476	3	protea
protect	11	3	1363	3	protect
protei	8	26	1530	3	protei
proteid	10	35	1366	3	proteid
protein	9	24	1472	3	protein
protest	9	3	1753	3	protest
protists	10	3	1335	3	protists
protium	11	3	1228	3	protium
proton	8	43	1889	3	proton
protyl	11	30	821	3	protyl
proud	8	46	1548	3	pro_ud
prove	10	48	2319	3	pro_ve
proved	12	50	1603	3	proved
proven	11	43	1477	3	proven
prover	11	38	1972	3	prover
proves	11	43	2225	3	proves
provide	13	3	985	3	provide
proving	13	42	1407	3	proving
proviso	12	3	731	3	proviso
provost	12	3	857	3	provost
prow	9	70	3038	3	pro__w
prowar	11	41	1094	3	prowar
prower	11	42	1812	3	prower
prowest	12	3	1153	3	prowest
prowl	10	56	1512	3	pro_wl
prowls	11	55	1108	3	prowls
prows	10	63	2701	3	pro_ws
proxies	16	30	1493	3	proxies
proximo	18	4	514	3	proximo
proxy	17	50	1101	3	pro_xy
prutot	8	3	1182	3	prutot
psoai	7	46	992	3	psoai_
psocid	11	3	725	3	psocid
ptosis	8	36	1182	3	ptosis
ptotic	10	27	1336	3	ptotic
puffin	14	114	900	3	puffin
pulpit	10	3	1093	3	pulpit
pundit	9	29	1418	3	pundit
pursuit	9	4	827	3	pursuit
pyoid	11	5	1375	3	pyo_id
pyosis	11	40	1212	3	pyosis
pyrosis	12	4	1165	3	pyrosis
quoit	14	38	1986	3	quo_it
raft	7	62	4591	3	_raf_t
recit	7	52	3510	3	_recit
refits	9	40	1765	3	_refits
refix	15	52	1248	3	_refix
reft	7	51	4127	3	_ref_t
relit	5	53	4068	3	_relit
remit	7	57	3722	3	_remit
resit	5	42	4104	3	_resit
retrofit	11	4	830	3	retrofit
rift	7	56	4233	3	_rif_t
roast	5	62	3014	3	_roast
robin	7	48	2027	3	_robin
robot	7	3	2597	3	_robot
roil	4	62	3529	3	_ro_il
roofie	9	34	1117	3	roofie
roost	5	57	3093	3	_roost
root	4	56	5592	3	_ro_ot
roset	5	59	4524	3	_roset
rosin	5	53	2531	3	_rosin
rot	3	72	8295	3	_ro__t
roti	4	63	3292	3	_roti_
rotis	5	63	2705	3	_rotis
roust	5	55	3206	3	_roust
rout	4	61	5328	3	_ro_ut
soffit	12	3	787	3	soffit
soft	7	69	4282	3	_sof_t
sprit	7	67	3640	3	spr__it
sprout	8	4	1940	3	spro_ut
toft	7	74	4165	3	_tof_t
toit	4	63	5306	3	_to_it
trait	5	69	4084	3	tr_ait
trifid	10	3	906	3	trifid
trois	5	72	2609	3	tro_is
tropic	10	30	1419	3	tropic
tropin	8	33	1675	3	tropin
trot	4	63	5131	3	tro__t
trout	5	73	3257	3	tro_ut
unfit	8	45	1856	3	_unfit
uproot	8	3	1412	3	upro_ot
urolith	10	4	878	3	urolith
vomit	10	26	2257	3	_vomit
worrit	9	23	1331	3	worrit
writ	7	55	3791	3	wr__it

Search took 8 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.140	1276364.3
2	DLD Change Limit	112716	332	6.906	16321.5
3	Display Results	332	332	0.220	1509.1
	(SQL Overall)	178691	332	7.266	24592.8