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

Here are the results of your fuzzy-string dictionary search for “wise” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

349 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
wise	7	57	3735	(None)
bise	6	64	3711	1	bise
mise	6	60	4359	1	mise
rise	4	59	4524	1	rise
vise	7	56	3268	1	vise
wide	8	52	3542	1	wide
wife	10	52	2803	1	wife
wile	7	59	4438	1	wile
wine	7	49	5343	1	wine
wipe	9	48	3029	1	wipe
wire	7	58	3982	1	wire
wis	6	65	5234	1	wis_
wised	9	51	2334	1	wised
wiser	8	55	2280	1	wiser
wises	8	56	3319	1	wises
wish	10	72	2874	1	wish
wisp	9	71	2408	1	wisp
wiss	7	56	3055	1	wiss
wist	7	80	4930	1	wist
wite	7	54	4328	1	wite
wive	10	59	3176	1	wive
aide	5	60	4501	2	aide
ais	3	90	8358	2	ais_
aisle	5	52	2319	2	aisle
anise	5	51	2971	2	anise
apse	6	77	2538	2	apse
arise	5	64	3643	2	arise
arse	4	65	3927	2	arse
base	6	48	4702	2	base
bice	8	62	3557	2	bice
bide	7	60	4151	2	bide
bike	10	65	3261	2	bike
bile	6	61	4719	2	bile
bine	6	66	5087	2	bine
birse	7	45	1740	2	birse
bis	5	68	6067	2	bis_
bises	7	54	3562	2	bises
bisk	10	65	2336	2	bisk
bite	6	65	4701	2	bite
bize	15	59	2630	2	bize
case	6	58	4808	2	case
cine	6	62	4295	2	cine
cire	6	58	3638	2	cire
cis	5	77	4804	2	cis_
cist	6	72	4497	2	cist
cite	6	56	4035	2	cite
dice	7	58	4190	2	dice
die	4	67	5966	2	di_e
dies	5	56	5353	2	dies
dike	9	59	3577	2	dike
dime	7	62	3765	2	dime
dine	5	55	5534	2	dine
dire	5	66	4415	2	dire
dis	4	64	5990	2	dis_
disc	7	61	2324	2	disc
dish	8	63	2834	2	dish
disk	9	66	2584	2	disk
disme	8	57	1624	2	disme
diss	5	64	3449	2	diss
dite	5	55	4756	2	dite
dive	8	56	3478	2	dive
dose	5	64	4243	2	dose
dwine	9	56	1614	2	dwine
ease	4	50	4233	2	ease
eide	5	58	3225	2	eide
else	4	59	2308	2	else
fice	9	57	3712	2	fice
fie	6	71	5245	2	fi_e
fife	10	60	2771	2	fife
file	7	54	4665	2	file
fine	7	51	4796	2	fine
fire	7	62	4560	2	fire
fisc	9	68	1976	2	fisc
fish	10	69	2628	2	fish
fist	7	62	4843	2	fist
five	10	76	2975	2	five
frise	8	53	2245	2	frise
fuse	7	64	2999	2	fuse
gibe	7	59	2779	2	gibe
gie	4	71	4955	2	gi_e
gies	5	56	4143	2	gies
gist	5	60	4677	2	gist
gite	5	54	3862	2	gite
give	8	58	2936	2	give
guise	6	47	1771	2	guise
gwine	9	55	1366	2	gwine
hide	8	51	3465	2	hide
hie	6	76	5271	2	hi_e
hies	7	48	4284	2	hies
hike	11	68	3040	2	hike
hire	7	55	3897	2	hire
his	6	63	5951	2	his_
hisn	7	96	2094	2	hisn
hiss	7	56	2922	2	hiss
hist	7	65	5155	2	hist
hive	10	60	2968	2	hive
hoise	8	52	2477	2	hoise
hose	7	65	4724	2	hose
ice	5	67	3725	2	_ice
ire	3	69	4318	2	_ire
is	2	70	4822	2	_is_
isle	4	51	2170	2	_isle
ism	5	63	2239	2	_ism
iwis	7	71	1701	2	iwis_
jibe	13	63	2340	2	jibe
jism	13	55	1478	2	jism
jive	14	61	2360	2	jive
kibe	10	65	2346	2	kibe
kike	7	65	2480	2	kike
kine	8	56	4344	2	kine
kis	7	80	5149	2	kis_
kiss	8	52	2741	2	kiss
kist	8	65	4081	2	kist
kite	8	53	3825	2	kite
lase	4	61	4851	2	lase
lice	6	60	4507	2	lice
lie	3	82	6453	2	li_e
lies	4	64	5420	2	lies
life	7	54	3374	2	life
like	8	60	4085	2	like
lime	6	62	4494	2	lime
line	4	69	6558	2	line
lipe	6	68	3974	2	lipe
lire	4	78	4530	2	lire
lis	3	71	6228	2	lis_
lisle	5	39	1672	2	lisle
lisp	6	89	2689	2	lisp
list	4	70	5535	2	list
lite	4	70	5455	2	lite
live	7	65	4100	2	live
lose	4	51	4458	2	lose
lyse	7	63	2059	2	lyse
mice	8	74	4224	2	mice
mike	10	55	3530	2	mike
mile	6	63	5258	2	mile
mime	8	57	3641	2	mime
mine	6	72	5618	2	mine
mire	6	67	4824	2	mire
mis	5	81	6263	2	mis_
miser	7	54	3040	2	miser
mises	7	47	4056	2	mises
miso	6	72	2991	2	miso
miss	6	53	3943	2	miss
mist	6	61	5454	2	mist
mite	6	62	4942	2	mite
muse	6	71	3603	2	muse
nice	6	55	3472	2	nice
nide	5	55	3580	2	nide
nine	4	58	4218	2	nine
nisei	5	42	1435	2	nisei
nisi	4	58	2325	2	nisi
nite	4	59	4359	2	nite
nixe	11	57	2203	2	nixe
noise	5	57	2373	2	noise
nose	4	67	3936	2	nose
nowise	9	5	1107	2	nowise
ose	3	81	4734	2	_ose
owse	7	63	2162	2	owse
paise	7	50	2833	2	paise
pase	6	53	4686	2	pase
peise	7	58	2577	2	peise
pice	8	46	4110	2	pice
pie	5	54	5741	2	pi_e
pies	6	69	4961	2	pies
pike	10	63	3522	2	pike
pile	6	56	4970	2	pile
pine	6	77	5572	2	pine
pipe	8	64	3444	2	pipe
pis	5	63	6204	2	pis_
pish	9	61	2792	2	pish
piso	6	67	2757	2	piso
piss	6	50	3334	2	piss
piste	7	58	2460	2	piste
poise	7	51	2789	2	poise
pose	6	64	4173	2	pose
prise	7	46	3261	2	prise
qis	12	69	3439	2	qis_
raise	5	48	2805	2	raise
rase	4	61	4998	2	rase
rice	6	49	4292	2	rice
ride	5	59	4514	2	ride
rife	7	46	3233	2	rife
rile	4	56	5054	2	rile
rime	6	51	3889	2	rime
rinse	5	48	2097	2	rinse
ripe	6	60	3893	2	ripe
risen	5	46	2188	2	risen
riser	5	54	3105	2	riser
rises	5	52	4404	2	rises
risk	8	57	2411	2	risk
rite	4	58	4946	2	rite
rive	7	55	3773	2	rive
rose	4	61	4890	2	rose
ruse	4	59	3893	2	ruse
seise	5	47	2785	2	seise
sice	6	55	4560	2	sice
side	5	54	4450	2	side
sike	8	71	3879	2	sike
sine	4	65	6063	2	sine
sipe	6	73	4105	2	sipe
sire	4	61	5042	2	sire
sis	3	73	6055	2	sis_
sises	5	52	3383	2	sises
site	4	70	5242	2	site
size	13	56	3097	2	size
swine	8	56	2530	2	swine
swipe	10	52	1708	2	swipe
swish	11	51	1482	2	swish
swiss	8	67	1290	2	swiss
swive	11	53	1619	2	swive
tide	5	52	3739	2	tide
tie	3	65	5754	2	ti_e
ties	4	52	4832	2	ties
tike	8	55	3449	2	tike
tile	4	54	5145	2	tile
time	6	62	3502	2	time
tine	4	58	5514	2	tine
tire	4	61	4336	2	tire
tis	3	70	5665	2	tis_
twice	10	47	1112	2	twice
twine	8	58	2236	2	twine
twist	8	68	2098	2	twist
unwise	9	5	1080	2	unwise
use	3	68	3516	2	_use
vase	7	56	2965	2	vase
vibe	9	51	2451	2	vibe
vice	9	57	3286	2	vice
vide	8	54	3277	2	vide
vie	6	54	4764	2	vi_e
vies	7	52	3863	2	vies
vile	7	61	3981	2	vile
vine	7	56	4369	2	vine
vis	6	67	4762	2	vis_
visa	7	63	2388	2	visa
vised	9	55	1876	2	vised
vises	8	44	2777	2	vises
vive	10	54	2663	2	vive
wade	8	52	3707	2	wade
wae	6	75	5695	2	w_ae
waes	7	60	4860	2	waes
wage	8	48	3408	2	wage
waist	8	61	3238	2	waist
waive	11	42	1460	2	waive
wake	11	49	3570	2	wake
wale	7	45	4644	2	wale
wame	9	50	3548	2	wame
wane	7	63	4472	2	wane
ware	7	62	5472	2	ware
was	6	87	6756	2	was_
wash	10	60	3381	2	wash
wasp	9	56	2685	2	wasp
wast	7	56	5585	2	wast
waste	8	61	2505	2	waste
wave	10	52	3473	2	wave
we	5	70	4345	2	w__e
wee	6	67	6081	2	w_ee
wees	7	62	4912	2	wees
were	7	62	3833	2	were
west	7	57	4808	2	west
whee	10	54	2959	2	whee
while	11	54	1869	2	while
whine	11	60	2281	2	whine
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whist	11	53	2295	2	whist
white	11	49	2030	2	white
whose	11	49	1453	2	whose
wich	12	57	2475	2	wich
wick	13	57	2631	2	wick
widen	9	47	1798	2	widen
wider	9	48	2636	2	wider
wides	9	48	3283	2	wides
wifed	12	51	1774	2	wifed
wifes	11	45	2256	2	wifes
wifey	14	49	1367	2	wifey
wig	7	67	4039	2	wi_g
wigs	8	49	3126	2	wigs
wild	8	51	2652	2	wild
wiled	9	52	3155	2	wiled
wiles	8	54	3787	2	wiles
will	7	57	3752	2	will
wilt	7	62	4630	2	wilt
wily	10	64	2882	2	wily
wimp	11	55	2153	2	wimp
win	6	64	5630	2	wi_n
wince	10	52	2088	2	wince
wind	8	55	3386	2	wind
wined	9	44	3418	2	wined
wines	8	55	4686	2	wines
winey	11	53	2543	2	winey
wing	8	63	3923	2	wing
wink	11	64	3503	2	wink
wino	7	59	3362	2	wino
wins	7	59	4918	2	wins
winy	10	70	3433	2	winy
winze	17	50	1485	2	winze
wiped	11	47	2208	2	wiped
wiper	10	54	2129	2	wiper
wipes	10	48	2708	2	wipes
wired	9	53	2764	2	wired
wirer	8	51	2495	2	wirer
wires	8	60	3491	2	wires
wiry	10	64	2284	2	wiry
wisely	12	27	1171	2	wisely
wisent	9	35	1634	2	wisent
wisest	9	50	1644	2	wisest
wisha	11	49	1085	2	wisha
wished	13	44	1751	2	wished
wisher	12	36	1706	2	wisher
wishes	12	49	2095	2	wishes
wisped	12	34	1189	2	wisped
wisps	10	52	1418	2	wisps
wispy	13	72	1097	2	wispy
wissed	10	41	1464	2	wissed
wisses	9	46	1960	2	wisses
wisted	10	41	2027	2	wisted
wists	8	67	2852	2	wists
wit	6	65	6378	2	wi_t
wited	9	47	2714	2	wited
wites	8	55	3696	2	wites
with	10	57	3048	2	with
withe	11	52	2023	2	withe
wits	7	60	4488	2	wits
wived	12	51	2150	2	wived
wiver	11	59	2451	2	wiver
wives	11	53	2892	2	wives
wiz	15	64	3416	2	wi_z
wizen	17	58	1386	2	wizen
wizes	17	47	2334	2	wizes
woe	6	66	5124	2	w_oe
woes	7	64	4066	2	woes
woke	11	55	2796	2	woke
wore	7	71	4467	2	wore
worse	8	65	2526	2	worse
wos	6	69	5353	2	wos_
wost	7	65	4436	2	wost
wove	10	56	2431	2	wove
wries	8	58	2774	2	wries
wrist	8	48	2756	2	wrist
write	8	55	2283	2	write
wuss	7	52	1933	2	wuss
wye	9	63	3197	2	w_ye
wyes	10	57	2750	2	wyes
wyle	10	55	1938	2	wyle
wyte	10	60	1864	2	wyte
xis	10	69	3534	2	xis_
yipe	9	67	2219	2	yipe
ywis	10	53	1310	2	ywis_
zine	13	70	3616	2	zine

Search took 2 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	29872	0.283	631417.0
2	DLD Change Limit	29872	349	0.843	35435.3
3	Display Results	349	349	0.093	3752.7
	(SQL Overall)	178691	349	1.219	146588.2