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

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

219 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
lemmings	13	25	473	(None)
lemming	12	26	939	1	lemming_
gemming	13	28	915	2	gemming_
hemming	15	26	997	2	hemming_
lamming	12	30	1458	2	lamming_
leadings	10	35	1124	2	leadings
leanings	9	40	1018	2	leanings
leasings	9	37	984	2	leasings
leavings	12	40	749	2	leavings
leggings	11	31	619	2	leggings
seemings	11	33	764	2	seemings
slammings	14	23	412	2	slammings
ammines	11	3	1267	3	_ammines
armings	10	38	1150	3	_armings
bamming	14	46	1181	3	bamming_
beadings	12	37	1178	3	beadings
beaming	12	36	1880	3	beaming_
bearings	11	39	1225	3	bearings
beatings	11	41	1323	3	beatings
becomings	16	4	378	3	becomings
beddings	13	40	792	3	beddings
beings	9	46	1303	3	be__ings
bellings	11	38	1115	3	bellings
beltings	11	36	925	3	beltings
berming	12	36	1483	3	berming_
blebbings	13	24	278	3	blebbings
bleedings	13	26	464	3	bleedings
blessings	12	3	372	3	blessings
bombings	15	26	649	3	bombings
bumming	14	34	1078	3	bumming_
campings	15	40	1020	3	campings
ceilings	11	39	799	3	ceilings
clamming	15	32	937	3	clamming_
clearings	12	28	606	3	clearings
coamings	13	34	929	3	coamings
combings	15	34	832	3	combings
comings	12	40	1353	3	_comings
cummins	13	5	896	3	cummin_s
cymlings	16	3	421	3	cymlings
damming	13	38	1274	3	damming_
dampings	14	37	752	3	dampings
dealings	10	35	1070	3	dealings
deckings	16	34	668	3	deckings
deeming	11	39	1312	3	deeming_
demoing	11	3	1175	3	demoing_
dimming	13	33	959	3	dimming_
dumpings	14	29	576	3	dumpings
earings	8	45	1771	3	_earings
eatings	8	46	1644	3	_eatings
edgings	10	25	624	3	_edgings
emptings	13	6	482	3	_emptings
endings	9	29	1044	3	_endings
ermines	9	4	1667	3	_ermines
farmings	14	29	822	3	farmings
feelings	12	33	893	3	feelings
feltings	12	31	790	3	feltings
fencings	14	22	566	3	fencings
flamming	16	35	715	3	flamming_
fleshings	16	33	538	3	fleshings
framings	14	33	813	3	framings
gamings	11	46	1091	3	_gamings
gamming	13	31	1262	3	gamming_
gearings	10	35	950	3	gearings
geldings	11	31	616	3	geldings
gemminess	14	6	464	3	gemminess
gleaming	12	27	793	3	gleaming_
gleanings	11	24	464	3	gleanings
gleyings	13	28	365	3	gle_yings
gloamings	13	25	409	3	gloamings
glomming	14	27	592	3	glomming_
gloomings	13	28	397	3	gloomings
gumming	13	38	1019	3	gumming_
hamming	15	30	1409	3	hamming_
headings	13	35	1049	3	headings
hearings	12	36	1185	3	hearings
heelings	12	35	975	3	heelings
helming	13	37	1200	3	helming_
helpings	14	25	565	3	helpings
hemins	11	34	1757	3	he_min_s
hemlines	13	3	1062	3	hemlines
herrings	12	37	953	3	herrings
humming	15	33	1067	3	humming_
impings	12	34	855	3	_impings
jamming	19	32	979	3	jamming_
jemmies	18	31	833	3	jemmi_es
jemmying	23	3	231	3	jemmying_
jestings	16	36	802	3	jestings
keepings	15	34	594	3	keepings
keglings	14	24	523	3	keglings
kennings	13	31	527	3	kennings
lacings	10	50	1365	3	l_acings
ladings	9	38	1413	3	l_adings
laggings	11	29	840	3	laggings
lakings	12	47	1351	3	l_akings
lambing	12	34	1241	3	lambing_
laminas	9	36	1587	3	l_aminas
laming	9	45	2836	3	l_aming_
lamping	12	31	1600	3	lamping_
landings	10	31	1007	3	landings
lapwings	14	27	497	3	lapwings
lashings	12	44	1225	3	lashings
lastings	9	42	1442	3	lastings
lathings	12	46	985	3	lathings
lawings	11	36	1147	3	l_awings
leading	9	34	1955	3	leading_
leafing	11	33	1358	3	leafing_
leaking	12	36	1697	3	leaking_
leaning	8	37	2120	3	leaning_
leaping	10	32	1599	3	leaping_
learnings	10	9	432	3	learnings
leasing	8	39	2016	3	leasing_
leaving	11	42	1685	3	leaving_
leching	13	46	1365	3	leching_
lectins	9	25	1500	3	lectin_s
leering	8	34	1764	3	leering_
legging	10	39	1264	3	legging_
leggins	9	25	947	3	leggin_s
legongs	9	3	454	3	le_gongs
legumins	11	4	499	3	legumin_s
lekking	11	30	650	3	lekking_
lemans	8	53	1639	3	le_man_s
lemmas	10	34	916	3	lemm__as
lemons	8	44	1505	3	le_mon_s
lempiras	12	4	385	3	lempiras
lending	9	41	1853	3	lending_
lensing	8	40	1510	3	lensing_
leptins	9	24	1269	3	leptin_s
letting	8	32	1853	3	letting_
leucines	10	3	727	3	leucines
leucins	9	3	810	3	leucin_s
levins	9	45	1465	3	le_vin_s
levying	14	3	587	3	levying_
lickings	15	29	814	3	lickings
likings	12	53	941	3	l_ikings
limbing	12	34	1042	3	limbing_
liming	9	40	2124	3	l_iming_
limning	10	37	1032	3	limning_
limping	12	46	1411	3	limping_
lings	6	71	3577	3	l___ings
linings	8	43	1307	3	l_inings
lippings	13	29	609	3	lippings
listings	9	33	1004	3	listings
livings	11	40	892	3	l_ivings
loadings	10	37	838	3	loadings
loaming	10	36	1373	3	loaming_
loanings	9	34	801	3	loanings
lodgings	11	33	624	3	lodgings
loggings	11	39	823	3	loggings
lomeins	9	6	948	3	lomein_s
longings	10	40	856	3	longings
looming	10	28	1485	3	looming_
lordings	10	36	850	3	lordings
losings	8	28	1062	3	l_osings
lowings	11	37	1007	3	l_owings
lumping	12	33	1464	3	lumping_
lutings	8	33	1105	3	l_utings
lyings	10	48	850	3	l__yings
meanings	11	32	916	3	meanings
meetings	11	28	741	3	meetings
mendings	12	33	830	3	mendings
mumming	11	40	1002	3	mumming_
neckings	15	34	611	3	neckings
nervings	12	25	632	3	nervings
nettings	9	28	810	3	nettings
nimming	12	35	814	3	nimming_
peelings	11	33	952	3	peelings
pembinas	14	5	414	3	pembinas
perming	12	34	1609	3	perming_
pettings	11	34	970	3	pettings
pleadings	13	28	554	3	pleadings
plumbings	16	21	336	3	plumbings
primings	13	33	814	3	primings
ramming	12	31	1506	3	ramming_
readings	10	35	1264	3	readings
reaming	10	39	2401	3	reaming_
redwings	13	30	573	3	redwings
reedings	10	35	1036	3	reedings
reelings	9	40	1256	3	reelings
remains	9	41	1791	3	remain_s
reminds	10	46	1479	3	re_minds
remints	9	51	1729	3	re_mints
rimming	12	34	1107	3	rimming_
seaming	10	32	2211	3	seaming_
seatings	9	36	1430	3	seatings
seeings	8	44	1129	3	se_eings
seeming	10	32	1626	3	seeming_
seisings	9	39	852	3	seisings
seizings	18	32	647	3	seizings
sergings	10	29	921	3	sergings
servings	12	24	922	3	servings
settings	9	38	1007	3	settings
sewings	11	36	917	3	se_wings
skimmings	18	24	326	3	skimmings
slamming	13	33	1000	3	slamming_
sleddings	12	26	378	3	sleddings
sleepings	12	33	588	3	sleepings
slimming	13	28	809	3	slimming_
slumming	13	27	838	3	slumming_
stemming	13	40	820	3	stemming_
summing	12	29	1238	3	summing_
swimmings	17	26	315	3	swimmings
teaming	10	39	1759	3	teaming_
teeming	10	35	1309	3	teeming_
temping	12	27	1069	3	temping_
terming	10	40	1600	3	terming_
terminus	10	3	739	3	terminus
timings	10	27	930	3	_timings
tomming	12	35	924	3	tomming_
trimmings	14	25	445	3	trimmings
veilings	12	35	731	3	veilings
veinings	12	30	643	3	veinings
vestings	12	35	914	3	vestings
webbings	16	3	324	3	webbings
weddings	14	35	553	3	weddings
weepings	14	34	648	3	weepings
weltings	12	38	820	3	weltings
westings	12	42	980	3	westings
wettings	12	34	840	3	wettings
yealings	12	25	770	3	yealings

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	219	7.500	19488.3
3	Display Results	219	219	0.080	2737.5
	(SQL Overall)	178691	219	8.000	22336.4