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

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

144 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
white	11	49	2030	(None)
while	11	54	1869	1	while
whine	11	60	2281	1	whine
whit	10	48	3417	1	whit_
whited	13	48	1408	1	whited
whiten	12	41	1192	1	whiten
whiter	12	43	1639	1	whiter
whites	12	39	1988	1	whites
whitey	15	49	1188	1	whitey
whits	11	59	2382	1	whits
whity	14	55	1347	1	whity
wite	7	54	4328	1	w_ite
write	8	55	2283	1	write
awhile	12	5	779	2	awhile
axite	12	52	1825	2	axite
bite	6	65	4701	2	_bite
blite	7	62	2535	2	blite
boite	7	44	2632	2	boite
chide	11	53	2102	2	chide
chile	10	56	2689	2	chile
chime	12	53	2259	2	chime
chine	10	52	3172	2	chine
chit	9	69	3746	2	chit_
chits	10	54	2457	2	chits
chive	13	51	1762	2	chive
chute	10	43	1646	2	chute
cite	6	56	4035	2	_cite
dite	5	55	4756	2	_dite
elite	5	62	3018	2	elite
evite	8	53	1768	2	evite
flite	8	54	2496	2	flite
gite	5	54	3862	2	_gite
hate	7	84	5017	2	_hate
hide	8	51	3465	2	_hide
hie	6	76	5271	2	_hi_e
hike	11	68	3040	2	_hike
hire	7	55	3897	2	_hire
hit	6	65	6920	2	_hit_
hits	7	55	4514	2	_hits
hive	10	60	2968	2	_hive
hyte	10	90	1894	2	_hyte
kite	8	53	3825	2	_kite
lite	4	70	5455	2	_lite
mite	6	62	4942	2	_mite
nite	4	59	4359	2	_nite
ophite	11	4	1056	2	ophite
quite	14	46	2146	2	quite
rite	4	58	4946	2	_rite
shine	8	55	3309	2	shine
shire	8	47	2713	2	shire
shit	7	67	4594	2	shit_
shits	8	47	3117	2	shits
shive	11	44	2342	2	shive
shote	8	55	2610	2	shote
shute	8	45	2035	2	shute
site	4	70	5242	2	_site
skite	9	51	2006	2	skite
smite	7	52	2487	2	smite
spite	7	54	3066	2	spite
suite	5	48	2956	2	suite
thine	8	50	2686	2	thine
trite	5	47	3003	2	trite
unite	5	48	2838	2	unite
unwhite	13	3	681	2	unwhite
wahine	12	38	1301	2	wahine
wait	7	55	5369	2	wait_
waited	10	38	1977	2	waited
waiter	9	43	2125	2	waiter
waits	8	83	3352	2	waits
waive	11	42	1460	2	waive
waste	8	61	2505	2	waste
whale	11	55	1743	2	whale
what	10	54	3407	2	what_
whats	11	77	1899	2	whats
whee	10	54	2959	2	wh_ee
where	11	70	1943	2	where
whet	10	51	3378	2	whet_
whets	11	50	1961	2	whets
which	16	39	1008	2	which
whid	11	54	1888	2	whi_d
whids	12	54	1399	2	whids
whiff	17	3	1006	2	whiff
whig	11	55	1642	2	whi_g
whigs	12	56	1264	2	whigs
whiled	13	45	1413	2	whiled
whiles	12	44	1801	2	whiles
whim	12	62	2053	2	whi_m
whims	13	45	1533	2	whims
whin	10	52	2569	2	whi_n
whined	13	47	1520	2	whined
whiner	12	45	1663	2	whiner
whines	12	51	2010	2	whines
whiney	15	50	1264	2	whiney
whinge	13	43	1154	2	whinge
whins	11	49	2233	2	whins
whiny	14	49	1557	2	whiny
whip	12	55	2184	2	whi_p
whips	13	49	1708	2	whips
whipt	13	53	1742	2	whipt
whir	10	55	1928	2	whi_r
whirl	11	49	1382	2	whirl
whirr	11	46	1119	2	whirr
whirs	11	52	1809	2	whirs
whish	14	45	1292	2	whish
whisk	15	45	1014	2	whisk
whist	11	53	2295	2	whist
whisted	14	40	1001	2	whisted
whistle	13	10	753	2	whistle
whists	12	46	1381	2	whists
whitely	16	34	647	2	whitely
whitens	13	42	873	2	whitens
whitest	13	37	1011	2	whitest
whiteys	16	39	615	2	whiteys
whither	16	35	1025	2	whither
whitier	13	33	1106	2	whitier
whities	13	31	1325	2	whities
whitter	13	91	1089	2	whitter
whittle	13	10	610	2	whittle
whiz	19	59	1994	2	whi_z
whizz	19	42	1032	2	whizz
whole	11	44	1809	2	whole
whore	11	60	1804	2	whore
whose	11	49	1453	2	whose
wide	8	52	3542	2	w_ide
wife	10	52	2803	2	w_ife
wile	7	59	4438	2	w_ile
wine	7	49	5343	2	w_ine
wipe	9	48	3029	2	w_ipe
wire	7	58	3982	2	w_ire
wise	7	57	3735	2	w_ise
wit	6	65	6378	2	w_it_
wited	9	47	2714	2	w_ited
wites	8	55	3696	2	w_ites
with	10	57	3048	2	w_ith
withe	11	52	2023	2	w_ithe
wits	7	60	4488	2	w_its
wive	10	59	3176	2	w_ive
writ	7	55	3791	2	writ_
writer	9	44	1651	2	writer
writes	9	44	2033	2	writes
writhe	12	53	1070	2	writhe
writs	8	66	2438	2	writs
wrote	8	47	1748	2	wrote
wyte	10	60	1864	2	w_yte

Search took 3 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	53800	0.343	520965.0
2	DLD Change Limit	53800	144	1.656	32487.9
3	Display Results	144	144	0.046	3130.4
	(SQL Overall)	178691	144	2.045	87379.5