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

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

154 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
whir	10	55	1928	(None)
thir	7	64	2054	1	thir
wair	7	58	3005	1	wair
weir	7	60	1992	1	weir
whid	11	54	1887	1	whid
whig	11	55	1642	1	whig
whim	12	62	2053	1	whim
whin	10	52	2569	1	whin
whip	12	55	2184	1	whip
whirl	11	49	1382	1	whirl
whirr	11	46	1119	1	whirr
whirs	11	52	1809	1	whirs
whit	10	48	3417	1	whit
whiz	19	59	1994	1	whiz
ahi	6	80	4023	2	ahi_
ahis	7	61	3538	2	ahis
air	3	80	5839	2	_air
amir	6	51	2975	2	amir
awhirl	12	6	467	2	awhirl
chair	10	55	1963	2	chair
char	9	51	3215	2	char
chi	8	62	2865	2	chi_
chia	9	60	2662	2	chia
chic	11	59	2520	2	chic
chid	10	66	2640	2	chid
chin	9	69	3474	2	chin
chip	11	67	2642	2	chip
chirk	14	45	1618	2	chirk
chirm	12	53	1706	2	chirm
chiro	10	53	2034	2	chiro
chirp	12	47	1716	2	chirp
chirr	10	50	1590	2	chirr
chiru	10	53	1715	2	chiru
chis	9	59	3331	2	chis
chit	9	69	3746	2	chit
choir	10	53	1360	2	choir
coir	6	63	2724	2	coir
emir	6	59	1870	2	emir
fair	7	63	3252	2	fair
fir	6	67	4489	2	_fir
flir	7	64	2220	2	flir
ghi	7	70	1988	2	ghi_
ghis	8	50	2016	2	ghis
hair	7	63	3014	2	hair
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
hi	5	79	4758	2	_hi_
hic	8	65	4056	2	_hic
hid	7	62	4838	2	_hid
hie	6	76	5270	2	_hie
him	8	62	4766	2	_him
hin	6	75	5956	2	_hin
hip	8	67	5043	2	_hip
hire	7	55	3896	2	_hire
his	6	63	5950	2	_his
hit	6	65	6919	2	_hit
keir	8	62	1787	2	keir
khi	10	63	1830	2	khi_
khis	11	70	1798	2	khis
kir	7	65	3568	2	_kir
lair	4	59	3415	2	lair
mair	6	61	3378	2	mair
mir	5	70	4677	2	_mir
noir	4	67	2243	2	noir
ohia	7	57	1936	2	ohia
pair	6	60	3151	2	pair
phi	8	65	2420	2	phi_
phis	9	57	2490	2	phis
phiz	18	67	1884	2	phiz
shier	8	54	2894	2	shier
shim	9	58	2786	2	shim
shin	7	56	3431	2	shin
ship	9	52	2824	2	ship
shire	8	47	2713	2	shire
shirk	12	48	1784	2	shirk
shirr	8	47	1692	2	shirr
shirt	8	45	3390	2	shirt
shit	7	67	4594	2	shit
shiv	10	57	2117	2	shiv
shri	7	60	2170	2	shri
sir	3	57	4667	2	_sir
stir	4	57	2325	2	stir
their	8	55	1215	2	their
thin	7	67	3239	2	thin
thio	7	72	2541	2	thio
third	9	59	1249	2	third
thirl	8	54	1682	2	thirl
this	7	60	2738	2	this
vair	7	56	2414	2	vair
waif	10	58	3675	2	waif
wail	7	52	3882	2	wail
wain	7	58	4020	2	wain
wairs	8	64	2406	2	wairs
wait	7	55	5369	2	wait
war	6	72	6242	2	w_ar
waur	7	68	1990	2	waur
wear	7	58	3672	2	wear
weer	7	55	3509	2	weer
weird	9	51	1128	2	weird
weirs	8	43	1649	2	weirs
wha	9	64	2207	2	wh_a
wham	12	53	2169	2	wham
whap	12	51	1964	2	whap
wharf	14	3	1582	2	wharf
what	10	54	3407	2	what
whee	10	54	2959	2	whee
when	10	57	2304	2	when
where	11	70	1942	2	where
whet	10	51	3378	2	whet
whew	13	76	1878	2	whew
whey	13	50	1871	2	whey
which	16	39	1008	2	which
whids	12	54	1398	2	whids
whiff	17	3	1006	2	whiff
whigs	12	56	1264	2	whigs
while	11	54	1869	2	while
whims	13	45	1533	2	whims
whine	11	60	2281	2	whine
whiner	12	45	1663	2	whiner
whins	11	49	2233	2	whins
whiny	14	49	1557	2	whiny
whips	13	49	1708	2	whips
whipt	13	53	1742	2	whipt
whirls	12	47	1053	2	whirls
whirly	15	44	886	2	whirly
whirrs	12	40	859	2	whirrs
whirry	15	47	706	2	whirry
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whist	11	53	2295	2	whist
white	11	49	2030	2	white
whiter	12	43	1639	2	whiter
whits	11	59	2382	2	whits
whity	14	55	1347	2	whity
whizz	19	42	1032	2	whizz
who	9	55	2677	2	wh_o
whoa	10	66	1520	2	whoa
whom	12	70	1818	2	whom
whop	12	55	2092	2	whop
whore	11	60	1804	2	whore
whorl	11	46	1245	2	whorl
whort	11	46	2369	2	whort
whup	12	57	1416	2	whup
why	12	69	2001	2	wh_y
whys	13	70	1166	2	whys
wig	7	67	4038	2	w_ig
win	6	64	5629	2	w_in
wire	7	58	3981	2	w_ire
wiry	10	64	2283	2	w_iry
wis	6	65	5233	2	w_is
wit	6	65	6377	2	w_it
wiz	15	64	3415	2	w_iz
wrier	8	45	2175	2	wrier
writ	7	55	3791	2	writ

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.296	603685.8
2	DLD Change Limit	29872	154	0.890	33564.0
3	Display Results	154	154	0.033	4666.7
	(SQL Overall)	178691	154	1.219	146588.2