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

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

311 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
foison	9	4	893	(None)
foisons	10	4	761	1	foisons
poison	8	3	1222	1	poison
bison	7	57	1698	2	_bison
bolson	8	4	1068	2	bolson
boson	7	60	1973	2	bo_son
dobson	9	3	659	2	dobson
foin	7	72	3156	2	foi__n
foist	8	57	3097	2	fois_t
foists	9	54	1398	2	foists
frisson	10	4	531	2	frisson
fusion	9	3	977	2	fusion
godson	8	5	738	2	godson
grison	7	3	1010	2	grison
orison	6	4	1166	2	orison
poisons	9	3	1035	2	poisons
prison	8	5	1402	2	prison
unison	6	4	903	2	unison
anion	5	50	2881	3	ani_on
arisen	6	53	1679	3	arisen
arson	5	51	1883	3	_arson
avion	8	42	1834	3	avi_on
aviso	8	57	1396	3	aviso_
avisos	9	54	1048	3	avisos
axion	12	113	1691	3	axi_on
basion	8	43	1585	3	basion
benison	9	3	712	3	benison
bisons	8	39	1437	3	_bisons
blouson	9	7	489	3	blouson
bolsons	9	6	948	3	bolsons
bonbon	10	3	1007	3	bonbon
boon	6	71	4217	3	bo__on
boron	7	67	2714	3	bo_ron
bosom	9	55	1692	3	bo_som
bosons	8	50	1665	3	bo_sons
boston	8	5	1304	3	boston
bosun	7	51	1359	3	bo_sun
bouton	8	3	1153	3	bouton
caisson	9	3	659	3	caisson
chiton	11	26	1239	3	chiton
cion	6	133	3091	3	_ci_on
cocoon	10	3	1226	3	cocoon
codon	8	65	2285	3	co_don
cogon	8	91	2090	3	co_gon
coign	8	50	1391	3	coi_gn
coin	6	66	4535	3	coi__n
coition	9	3	1431	3	coition
colon	7	86	3019	3	co_lon
common	12	3	1080	3	common
consol	8	26	1411	3	consol
coon	6	72	4894	3	co__on
cordon	9	50	1729	3	cordon
cosign	9	5	878	3	cosign
cotton	8	3	1299	3	cotton
coupon	10	28	1099	3	coupon
cousin	8	5	1716	3	cousin
crimson	11	3	564	3	crimson
daikon	11	21	724	3	daikon
daimon	9	25	971	3	daimon
damson	9	3	806	3	damson
disown	10	3	695	3	_disown
doblon	9	3	801	3	doblon
dobsons	10	3	620	3	dobsons
donjon	14	3	646	3	donjon
eikon	9	3	946	3	_eikon
elision	7	23	1110	3	elision
empoison	12	4	384	3	empoison
eosin	5	52	2092	3	eo_sin
epigon	9	3	796	3	epigon
erosion	7	3	1111	3	erosion
fain	7	58	4056	3	fai__n
falcon	11	3	1029	3	falcon
fanion	9	45	1432	3	fanion
fanon	8	46	1901	3	f_anon
fatso	8	51	1349	3	fatso_
fatsos	9	38	942	3	fatsos
feign	9	42	1071	3	fei_gn
feijoa	16	4	222	3	feijoa
feist	8	62	3007	3	feis_t
feists	9	49	1531	3	feists
feisty	12	44	929	3	feisty
felon	8	46	1929	3	f_elon
ficin	10	35	1672	3	f_icin
fico	9	58	2459	3	f_ico_
fido	8	77	2639	3	f_ido_
fidos	9	58	1905	3	f_idos
filo	7	60	3428	3	f_ilo_
filos	8	61	2538	3	f_ilos
fin	6	64	5803	3	f_i__n
fino	7	60	3469	3	f_ino_
finos	8	62	2695	3	f_inos
firn	7	69	2750	3	f_i_rn
fisc	9	68	1975	3	f_is_c
fiscs	10	53	1188	3	f_iscs
fish	10	69	2627	3	f_is_h
fishy	14	60	1166	3	f_ishy
fission	10	3	873	3	fission
fist	7	62	4842	3	f_is_t
fists	8	55	2754	3	f_ists
flacon	11	3	863	3	flacon
flagon	10	3	798	3	flagon
fobs	9	60	3427	3	fobs__
foehn	11	23	632	3	fo_ehn
foeman	11	3	1123	3	foeman
foemen	11	3	1052	3	foemen
foes	7	65	4344	3	foes__
foetor	9	3	956	3	foetor
fogbow	15	4	478	3	fogbow
fogdog	12	3	422	3	fogdog
foghorn	14	4	543	3	foghorn
fogs	8	70	3500	3	fogs__
fohn	10	61	1655	3	fo__hn
foible	11	4	1038	3	foible
foil	7	64	3391	3	foi__l
foiled	10	46	1840	3	foiled
foiling	11	33	1765	3	foiling
foils	8	50	2581	3	foi_ls
foilsman	13	5	377	3	foilsman
foilsmen	13	5	410	3	foilsmen
foined	10	59	1501	3	foined
foining	11	30	1345	3	foining
foins	8	55	2338	3	foi_ns
foisted	11	32	1060	3	foisted
foisting	12	29	1050	3	foisting
folio	8	38	2088	3	folio_
folios	9	39	1546	3	folios
foliose	10	37	801	3	foliose
folksong	16	4	246	3	folksong
follow	12	40	1035	3	follow
fon	6	63	5227	3	f___on
fons	7	69	4389	3	fons__
food	8	68	3057	3	fo__od
fool	7	53	3059	3	fo__ol
foot	7	62	4801	3	fo__ot
fops	9	65	3268	3	fops__
fordo	9	72	1865	3	fordo_
fordone	11	4	938	3	fordone
forgo	9	44	1833	3	forgo_
forgone	11	3	934	3	forgone
forgot	10	43	1813	3	forgot
forlorn	10	9	642	3	forlorn
formol	11	29	1033	3	formol
forsook	14	4	600	3	forsook
forsworn	14	12	575	3	forsworn
forworn	13	10	778	3	forworn
foss	7	64	3164	3	fo_s_s
fossa	8	58	1263	3	fo_ssa
fossae	9	55	1037	3	fossae
fossas	9	46	1070	3	fossas
fosse	8	61	1946	3	fo_sse
fosses	9	60	2208	3	fosses
fossil	9	37	935	3	fossil
fourgon	11	3	486	3	fourgon
foxskin	21	4	313	3	foxskin
foys	10	56	2829	3	foys__
frijol	16	3	412	3	frijol
frise	8	53	2245	3	fris_e
frisee	9	42	1799	3	frisee
frises	9	41	2427	3	frises
frisk	12	53	1237	3	fris_k
frisks	13	47	926	3	frisks
frisky	16	40	667	3	frisky
frissons	11	4	504	3	frissons
frivol	12	3	511	3	frivol
fronton	10	3	720	3	fronton
fusions	10	3	915	3	fusions
futon	8	31	1377	3	f_uton
gibson	9	3	512	3	gibson
gipon	8	42	1241	3	_gipon
giron	6	61	1899	3	_giron
godsons	9	6	666	3	godsons
gonion	7	36	1283	3	gonion
goon	5	72	3617	3	go__on
gorgon	8	3	1024	3	gorgon
gossan	7	4	723	3	gossan
gossoon	8	6	566	3	gossoon
grisons	8	3	899	3	grisons
guidon	8	3	737	3	guidon
hisn	7	96	2093	3	_his_n
hoiden	10	36	1233	3	hoiden
hoise	8	52	2477	3	hois_e
hoised	10	51	1743	3	hoised
hoises	9	48	2367	3	hoises
hoising	11	34	1441	3	hoising
hoist	8	64	3321	3	hois_t
hoists	9	55	1602	3	hoists
horizon	19	5	576	3	horizon
hosen	8	56	2388	3	ho_sen
hyson	11	3	869	3	_hyson
icon	6	69	2204	3	__icon
ikon	8	58	1495	3	__ikon
inion	5	46	2018	3	ini_on
ion	3	60	5102	3	__i_on
iron	4	67	2846	3	__iron
johnson	17	4	233	3	johnson
join	11	67	2483	3	joi__n
joist	12	51	2565	3	jois_t
joists	13	47	1103	3	joists
jomon	14	6	1008	3	jo_mon
kelson	10	3	815	3	kelson
kois	8	51	2940	3	kois__
lesion	6	47	1506	3	lesion
lesson	6	44	1204	3	lesson
liaison	7	4	447	3	liaison
lion	4	63	3444	3	_li_on
logion	7	60	1372	3	logion
logon	6	159	2231	3	lo_gon
loin	4	68	3872	3	loi__n
loon	4	73	4479	3	lo__on
loosen	6	66	1596	3	loosen
lotion	6	57	1652	3	lotion
malison	9	3	969	3	malison
mason	7	48	2018	3	_mason
meson	7	41	1831	3	_meson
miso	6	72	2990	3	_miso_
misos	7	65	2329	3	_misos
moist	7	60	3358	3	mois_t
moisten	9	31	1014	3	moisten
monsoon	9	3	849	3	monsoon
moon	6	71	4081	3	mo__on
morion	8	62	1773	3	morion
moron	7	69	2542	3	mo_ron
mosso	7	47	1518	3	mosso_
motion	8	52	1755	3	motion
mouton	8	4	1085	3	mouton
nasion	6	39	1408	3	nasion
nelson	6	3	842	3	nelson
ninon	5	55	1738	3	_ninon
niton	5	54	1828	3	_niton
noise	5	57	2373	3	nois_e
noised	7	54	1623	3	noised
noises	6	50	2185	3	noises
noising	8	36	1517	3	noising
noisome	9	4	797	3	noisome
noisy	8	68	1336	3	nois_y
noniron	7	3	837	3	noniron
noon	4	71	3462	3	no__on
notion	6	45	1658	3	notion
odeon	6	4	1148	3	_odeon
onion	5	43	2097	3	_onion
opsin	7	6	1347	3	_opsin
orisons	7	3	1056	3	orisons
orlon	5	4	1500	3	_orlon
owsen	8	42	1019	3	_owsen
paisan	8	44	1707	3	paisan
parson	8	38	1790	3	parson
person	8	35	1787	3	person
pinon	7	60	2453	3	_pinon
pion	6	72	3529	3	_pi_on
piso	6	67	2756	3	_piso_
pisos	7	60	2106	3	_pisos
piston	8	35	1592	3	_piston
piton	7	61	2158	3	_piton
plosion	9	3	911	3	plosion
pocoson	11	5	675	3	pocoson
podsol	9	4	685	3	podsol
pois	6	65	3904	3	pois__
poise	7	51	2789	3	pois_e
poised	9	49	1847	3	poised
poiser	8	42	1724	3	poiser
poises	8	42	2654	3	poises
poisha	11	3	572	3	poisha
poising	10	36	1710	3	poising
poisoned	11	3	695	3	poisoned
poisoner	10	4	698	3	poisoner
pompon	12	3	894	3	pompon
ponton	8	32	1764	3	ponton
poon	6	73	4126	3	po__on
potion	8	45	1957	3	potion
prion	7	51	1999	3	pri_on
prisons	9	3	1322	3	prisons
ptisan	8	41	797	3	ptisan
raisin	6	27	1692	3	raisin
ramson	8	3	1046	3	ramson
reason	6	26	1633	3	reason
risen	5	46	2188	3	_risen
ronion	6	33	1564	3	ronion
ronyon	9	30	913	3	ronyon
rosin	5	53	2531	3	ro_sin
scion	7	22	1499	3	sci_on
season	6	27	1490	3	season
seisin	6	37	1512	3	seisin
seisor	6	37	1233	3	seisor
solion	6	6	1638	3	solion
soliton	7	4	1023	3	soliton
solon	5	50	2613	3	so_lon
son	3	77	6195	3	___son
soon	4	62	4050	3	so__on
sponson	9	3	538	3	sponson
telson	6	3	1029	3	telson
tigon	6	39	1444	3	_tigon
tocsin	8	3	1100	3	tocsin
toon	4	77	4063	3	to__on
torsion	7	3	1080	3	torsion
torso	5	69	2214	3	torso_
torsos	6	48	1573	3	torsos
toyon	8	67	1567	3	to_yon
trigon	7	45	1310	3	trigon
triton	6	39	1489	3	triton
union	5	45	1979	3	uni_on
unisons	7	4	842	3	unisons
venison	10	3	644	3	venison
vision	9	3	1131	3	_vision
visor	8	25	1283	3	_visor
voudon	10	3	587	3	voudon
warison	10	3	708	3	warison
weason	9	32	1082	3	weason
wonton	9	34	1096	3	wonton
worsen	9	55	1387	3	worsen
youpon	11	36	600	3	youpon
zoon	13	73	2698	3	zo__on

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.126	1418182.5
2	DLD Change Limit	112716	311	6.123	18408.6
3	Display Results	311	311	0.093	3344.1
	(SQL Overall)	178691	311	6.342	28175.8