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

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

117 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
fliting	11	35	1461	(None)
flinting	12	34	1234	1	flinting
flirting	12	31	901	1	flirting
flitting	12	30	1088	1	flitting
fluting	11	38	1509	1	fluting
flyting	14	37	855	1	flyting
alining	8	19	1704	2	alining
baiting	10	39	1888	2	baiting
biting	9	53	2182	2	_biting
blitzing	20	3	590	2	blitzing
citing	9	42	2018	2	_citing
editing	9	3	1313	2	editing
elating	8	34	2308	2	elating
eliding	9	34	1434	2	eliding
eluting	8	41	1529	2	eluting
eviting	11	5	1137	2	eviting
exiting	15	3	1139	2	exiting
failing	11	35	2133	2	failing
fainting	12	33	1216	2	fainting
fairing	11	36	1401	2	fairing
faithing	15	3	715	2	faithing
farting	11	41	2075	2	farting
fasting	11	45	2283	2	fasting
fating	10	53	2867	2	f_ating
fatting	11	38	1870	2	fatting
feinting	12	34	1083	2	feinting
felting	11	35	1521	2	felting
feting	10	44	1779	2	f_eting
fetting	11	35	1787	2	fetting
fifing	13	42	1234	2	f_ifing
fileting	12	3	930	2	fileting
filiating	13	3	924	2	filiating
filing	10	38	2376	2	f_iling
filling	11	35	2080	2	filling
filming	13	32	1035	2	filming
fining	10	42	2321	2	f_ining
firing	10	40	2172	2	f_iring
fisting	11	38	1812	2	fisting
fitting	11	35	1656	2	fitting
fixing	17	48	1378	2	f_ixing
flailing	12	29	892	2	flailing
flaking	15	41	1449	2	flaking
flaming	13	42	1644	2	flaming
flaring	11	41	1680	2	flaring
flatling	12	34	1001	2	flatling
flatting	12	35	1125	2	flatting
flawing	14	38	1256	2	flawing
flaying	14	39	1446	2	flaying
fleeing	11	35	1129	2	fleeing
fleeting	12	29	1032	2	fleeting
flexing	18	35	899	2	flexing
fleying	14	32	987	2	fleying
flicking	18	41	1004	2	flicking
flighting	17	3	610	2	flighting
fling	9	70	2351	2	fl__ing
flinging	13	33	1005	2	flinging
flipping	16	30	766	2	flipping
flitching	18	26	534	2	flitching
floating	12	31	1188	2	floating
flouting	12	26	1047	2	flouting
flowing	14	34	1176	2	flowing
fluking	15	44	1051	2	fluking
fluming	13	35	1279	2	fluming
flutings	12	35	737	2	flutings
fluxing	18	39	892	2	fluxing
flying	13	46	1215	2	fl_ying
flytings	15	30	479	2	flytings
foiling	11	33	1765	2	foiling
foining	11	30	1345	2	foining
foisting	12	29	1050	2	foisting
foliating	13	3	925	2	foliating
folioing	12	3	757	2	folioing
footing	11	50	1759	2	footing
fritting	12	35	1070	2	fritting
frizing	20	33	1087	2	frizing
fruiting	12	22	906	2	fruiting
gaiting	9	37	1658	2	gaiting
gliding	10	39	1184	2	gliding
gliming	11	33	1013	2	gliming
glinting	10	32	1005	2	glinting
glitzing	19	3	497	2	glitzing
hilting	11	33	1689	2	hilting
jilting	15	32	1174	2	jilting
kilting	12	32	1385	2	kilting
kiting	11	41	1709	2	_kiting
lifting	11	33	1327	2	_lifting
liking	11	43	1958	2	_liking
lilting	8	35	1538	2	_lilting
liming	9	40	2124	2	_liming
lining	7	45	2680	2	_lining
linting	8	38	2098	2	_linting
listing	8	40	2059	2	_listing
living	10	43	1832	2	_living
luting	7	52	2175	2	_luting
milting	10	36	1912	2	milting
plaiting	11	31	1351	2	plaiting
plating	10	38	2307	2	plating
silting	8	33	2048	2	silting
siting	7	41	2662	2	_siting
skiting	12	38	1250	2	skiting
slating	8	37	2465	2	slating
slicing	10	35	1464	2	slicing
sliding	9	31	1455	2	sliding
sliming	10	29	1395	2	sliming
sliping	10	33	1441	2	sliping
slitting	9	30	1258	2	slitting
smiting	10	30	1444	2	smiting
spiting	10	39	1762	2	spiting
suiting	8	34	1900	2	suiting
tilting	8	34	1710	2	tilting
toiting	8	32	1709	2	toiting
uniting	8	3	1582	2	uniting
waiting	11	36	1895	2	waiting
whiting	14	33	1130	2	whiting
wilting	11	35	1591	2	wilting
witing	10	35	2282	2	_witing
writing	11	37	1389	2	writing

Search took 4 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	107671	0.406	440125.6
2	DLD Change Limit	107671	117	3.390	31761.4
3	Display Results	117	117	0.046	2543.5
	(SQL Overall)	178691	117	3.842	46509.9