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

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

422 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
maftir	11	3	649	(None)
maftirs	12	3	604	1	maftirs
after	8	57	1979	2	_after
astir	5	55	1709	2	_astir
dafter	10	48	1334	2	dafter
hafter	12	48	1588	2	hafter
kaffir	16	34	530	2	kaffir
kafir	12	48	890	2	kaf_ir
maffia	14	32	720	2	maffia
mafia	10	44	1803	2	maf_ia
mafic	12	56	1546	2	maf_ic
mair	6	61	3378	2	ma__ir
maltier	9	30	1548	2	maltier
mantic	10	41	2090	2	mantic
mantid	9	38	2038	2	mantid
mantis	8	39	2603	2	mantis
martin	8	41	2253	2	martin
martyr	11	3	569	2	martyr
master	8	48	3134	2	master
mastic	10	31	1917	2	mastic
mastix	15	23	1051	2	mastix
mater	7	44	3886	2	ma_ter
matier	8	43	2152	2	ma_tier
matin	7	51	3285	2	ma_tin
matter	8	43	2534	2	matter
mattin	8	44	1663	2	mattin
mufti	10	6	1054	2	mufti_
muftis	11	5	805	2	muftis
rafter	9	45	1758	2	rafter
santir	6	3	1525	2	santir
wafter	12	41	1461	2	wafter
zaffir	21	39	551	2	zaffir
zaftig	19	3	325	2	zaftig
actin	7	49	2255	3	_actin
actor	7	11	1608	3	_actor
afar	7	67	2078	3	_af_ar
affair	12	3	435	3	affair
affirm	14	3	552	3	_affirm
affix	18	3	600	3	_affix
afire	8	62	1591	3	_af_ire
afrit	8	3	2317	3	_afrit
aft	6	68	4901	3	_aft__
afters	9	47	1707	3	_afters
air	3	80	5840	3	_a__ir
altar	5	55	2064	3	_altar
alter	5	48	2850	3	_alter
amir	6	51	2975	3	_a_mir
anti	4	55	3636	3	_anti_
antiar	6	3	1717	3	_antiar
antic	7	57	2886	3	_antic
antis	5	50	3331	3	_antis
apter	7	61	2020	3	_apter
artier	6	34	1973	3	_artier
aster	5	54	3489	3	_aster
attar	5	65	1669	3	_attar
attic	7	56	1835	3	_attic
attire	6	24	1238	3	_attire
baiter	8	44	2256	3	baiter
banter	8	48	2534	3	banter
barter	8	55	2538	3	barter
baster	8	53	3360	3	baster
batik	11	6	1473	3	ba_tik
batter	8	49	2888	3	batter
battier	9	35	1572	3	battier
battik	12	3	809	3	battik
bawtie	11	38	1214	3	bawtie
bestir	8	3	1116	3	bestir
cacti	9	3	1864	3	cacti_
caftan	11	17	1012	3	caftan
canter	8	52	3011	3	canter
cantic	10	39	2054	3	cantic
cantor	8	56	2152	3	cantor
captor	10	49	1460	3	captor
carter	8	49	3227	3	carter
caster	8	52	3257	3	caster
castor	8	44	1853	3	castor
cater	7	48	4072	3	ca_ter
cattie	8	52	2102	3	cattie
cattier	9	33	1707	3	cattier
crafter	12	41	1133	3	crafter
craftier	13	7	619	3	craftier
daffier	14	5	783	3	daffier
daft	8	55	3725	3	daft__
daftly	13	3	544	3	daftly
darter	7	53	2036	3	darter
dater	6	53	3231	3	da_ter
dautie	7	29	1470	3	dautie
dawtie	10	30	1109	3	dawtie
defter	10	42	1592	3	defter
drafter	11	44	943	3	drafter
draftier	12	8	526	3	draftier
easter	6	50	2798	3	easter
eater	5	46	3984	3	ea_ter
factor	11	9	1146	3	factor
fair	7	63	3252	3	__fair
fakir	12	51	1149	3	fa_kir
falter	9	45	1905	3	falter
faqir	17	54	864	3	fa_qir
faquir	18	3	431	3	faquir
faster	9	46	2577	3	faster
fatter	9	45	2321	3	fatter
fattier	10	35	1346	3	fattier
fir	6	67	4490	3	__f_ir
flir	7	64	2220	3	__flir
gaffer	13	43	1013	3	gaffer
gaiter	7	38	1950	3	gaiter
gambir	11	50	977	3	gambir
garter	7	44	2051	3	garter
gaster	7	50	2735	3	gaster
gater	6	45	3365	3	ga_ter
gator	6	44	1604	3	ga_tor
grafter	11	42	1115	3	grafter
haffit	15	3	853	3	haffit
hafiz	20	6	1121	3	haf_iz
haft	10	59	4184	3	haft__
haftara	13	13	609	3	haftara
hafted	13	47	1383	3	hafted
hafters	13	46	1433	3	hafters
hafting	14	40	1417	3	hafting
hafts	11	62	1946	3	haft_s
hair	7	63	3014	3	ha__ir
halter	9	44	2088	3	halter
haptic	13	5	1189	3	haptic
hastier	10	39	1662	3	hastier
hater	8	50	3475	3	ha_ter
hatter	9	47	2487	3	hatter
hefter	12	43	1392	3	hefter
heftier	13	3	720	3	heftier
kaffirs	17	32	555	3	kaffirs
kafirs	13	30	698	3	kaf_irs
kaftan	13	18	583	3	kaftan
kantar	10	3	1116	3	kantar
kefir	12	45	791	3	kef_ir
lactic	10	7	1349	3	lactic
lair	4	59	3415	3	la__ir
laster	6	48	3063	3	laster
later	5	48	4392	3	la_ter
lati	4	64	3827	3	la_ti_
latter	6	50	2789	3	latter
lattin	6	43	1622	3	lattin
lefter	9	36	1343	3	lefter
lifter	9	38	1481	3	lifter
lofter	9	46	1472	3	lofter
loftier	10	3	776	3	loftier
maar	6	60	2506	3	ma__ar
macer	9	121	2694	3	ma_cer
madder	10	35	1559	3	madder
madeira	10	4	511	3	madeira
madtom	11	3	802	3	madtom
maestri	9	4	548	3	maestri
maffias	15	32	728	3	maffias
maffick	21	4	352	3	maffick
mafias	11	39	1357	3	mafias
magi	7	63	2953	3	ma_gi_
magic	10	58	1866	3	ma_gic
magpie	11	3	909	3	magpie
mahzor	20	3	511	3	mahzor
maid	7	55	3767	3	ma__id
mail	6	55	4345	3	ma__il
mailer	8	47	2418	3	mailer
maim	8	58	3149	3	ma__im
maimer	10	45	1459	3	maimer
main	6	53	4552	3	ma__in
mairs	7	62	2830	3	ma__irs
major	14	52	1292	3	ma_jor
makar	11	56	1497	3	ma_kar
maker	11	41	2781	3	ma_ker
malar	7	64	2444	3	ma_lar
malic	9	45	2566	3	ma_lic
malkin	12	29	1315	3	malkin
malmier	11	36	1195	3	malmier
maloti	8	3	1321	3	maloti_
malt	6	62	5481	3	malt__
malted	9	48	1986	3	malted
maltha	11	3	751	3	maltha
malting	10	32	1908	3	malting
maltol	8	3	1084	3	maltol
malts	7	63	3175	3	malt_s
malty	10	67	2170	3	malt_y
mamie	9	58	2600	3	ma_mie
mammer	9	42	1886	3	mammer
mammie	9	43	1378	3	mammie
mamzer	19	45	983	3	mamzer
manger	9	43	2501	3	manger
mangier	10	41	1406	3	mangier
mania	7	56	3415	3	ma_nia
manic	9	46	2944	3	ma_nic
manito	8	5	1869	3	manito
manitu	8	3	1582	3	manitu
manlier	9	24	1403	3	manlier
manner	8	40	2051	3	manner
manor	7	80	2393	3	ma_nor
manta	7	56	2991	3	mant_a
mantas	8	57	2536	3	mantas
mantel	8	43	1797	3	mantel
mantes	8	44	3078	3	mantes
mantids	10	31	1362	3	mantids
mantle	8	44	2092	3	mantle
mantra	8	41	1609	3	mantra
mantric	11	3	1135	3	mantric
mantua	8	44	1202	3	mantua
mapper	12	45	1609	3	mapper
maqui	16	24	995	3	maqui_
maquis	17	24	948	3	maquis
mar	5	79	6595	3	ma___r
margin	9	40	1686	3	margin
maria	7	50	3289	3	ma_ria
marker	12	44	2039	3	marker
marlier	9	26	1479	3	marlier
marlin	8	42	2092	3	marlin
marrer	8	37	1667	3	marrer
marrier	9	38	1753	3	marrier
mart	6	68	6598	3	mart__
marted	9	44	2521	3	marted
marten	8	45	1826	3	marten
martial	9	24	1541	3	martial
martian	9	35	1468	3	martian
marting	10	33	2502	3	marting
martini	9	36	1388	3	martini
martins	9	33	2207	3	martins
marts	7	74	4223	3	mart_s
martyrs	12	3	489	3	martyrs
martyry	15	3	337	3	martyry
maser	7	50	2997	3	ma_ser
masher	11	41	2320	3	masher
mashie	11	3	1593	3	mashie
masjid	16	18	732	3	masjid
masker	12	44	1610	3	masker
massier	9	36	1522	3	massier
massif	11	4	1253	3	massif
mast	6	59	5996	3	mast__
masted	9	40	2580	3	masted
masters	9	46	2892	3	masters
mastery	12	42	1432	3	mastery
mastics	11	26	1478	3	mastics
mastiff	15	3	816	3	mastiff
masting	10	43	2582	3	masting
mastoid	10	7	1123	3	mastoid
masts	7	70	3576	3	mast_s
mat	5	80	8394	3	ma_t__
match	12	56	2110	3	ma_tch
mate	6	51	5422	3	ma_t_e
mated	8	55	3778	3	ma_ted
maters	8	50	3239	3	ma_ters
mates	7	52	5136	3	ma_tes
matey	10	70	2266	3	ma_tey
math	9	54	3745	3	ma_t_h
maths	10	56	2402	3	ma_ths
mating	9	48	3291	3	ma_ting
matins	8	45	2778	3	ma_tins
matrix	15	3	985	3	matrix
mats	6	54	6029	3	ma_t_s
matt	6	57	5266	3	ma_t_t
matte	7	56	2684	3	ma_tte
matted	9	45	2141	3	matted
matters	9	44	2175	3	matters
mattery	12	38	1071	3	mattery
mattes	8	56	2453	3	mattes
matting	10	36	2014	3	matting
mattins	9	33	1614	3	mattins
mattoid	10	7	928	3	mattoid
matts	7	68	2918	3	ma_tts
mature	8	3	1347	3	ma_ture
matza	16	3	1181	3	ma_tza
matzo	16	3	1289	3	ma_tzo
mauger	9	38	1348	3	mauger
mauler	8	44	1671	3	mauler
maut	6	54	4845	3	maut__
mauts	7	59	2719	3	maut_s
mavie	10	47	2256	3	ma_vie
mavin	10	57	2295	3	ma_vin
mavis	10	56	2272	3	ma_vis
maxi	13	70	2356	3	ma_xi_
maxim	16	52	1600	3	ma_xim
maxis	14	57	2156	3	ma_xis
maybird	15	4	399	3	maybird
mayor	10	66	1662	3	ma_yor
mayvin	14	3	652	3	mayvin
mazer	16	57	2242	3	ma_zer
mazier	17	50	1306	3	mazier
meatier	9	32	1461	3	meatier
meeter	8	36	1650	3	meeter
melter	8	35	2011	3	melter
memoir	10	3	721	3	memoir
menhir	11	3	678	3	menhir
mentor	8	4	1436	3	mentor
meter	7	51	3032	3	m_eter
metier	8	35	1769	3	m_etier
metis	7	50	2590	3	m_etis
midair	9	3	799	3	midair
miffier	15	3	702	3	miffier
milter	8	49	2123	3	milter
miltier	9	32	1496	3	miltier
minter	8	44	2510	3	minter
mintier	9	36	1599	3	mintier
miotic	10	37	1575	3	miotic
mir	5	70	4678	3	m___ir
mister	8	47	2856	3	mister
mistier	9	34	1871	3	mistier
miter	7	57	3479	3	m_iter
mitier	8	36	2067	3	m_itier
mitis	7	54	2599	3	m_itis
mohair	11	3	520	3	mohair
molter	8	41	1942	3	molter
mooter	8	39	2109	3	mooter
mortar	8	38	1204	3	mortar
motif	10	5	1968	3	m_otif
motor	7	53	1729	3	m_otor
muffin	14	29	887	3	muffin
muntin	8	29	1518	3	muntin
muster	8	47	2452	3	muster
mustier	9	40	1796	3	mustier
muter	7	45	2554	3	m_uter
mutter	8	44	1888	3	mutter
myotic	13	31	1231	3	myotic
mystic	13	27	1164	3	mystic
nadir	6	10	1297	3	na_dir
nastic	8	29	1597	3	nastic
nastier	7	41	1529	3	nastier
natter	6	44	2074	3	natter
nattier	7	36	1462	3	nattier
niftier	10	32	871	3	niftier
oater	5	54	3373	3	oa_ter
ofter	8	41	1687	3	_ofter
pair	6	60	3151	3	pa__ir
palter	8	44	2326	3	palter
pantie	8	43	2647	3	pantie
partier	9	35	2071	3	partier
paster	8	57	3437	3	paster
pastie	8	55	2552	3	pastie
pastier	9	43	2038	3	pastier
pastil	8	50	1832	3	pastil
pastis	8	49	2432	3	pastis
pastor	8	48	1748	3	pastor
pater	7	47	4073	3	pa_ter
patin	7	68	3285	3	pa_tin
patio	7	44	2636	3	pa_tio
patter	8	46	2826	3	patter
pattie	8	40	2096	3	pattie
raffia	12	28	770	3	raffia
raft	7	62	4591	3	raft__
rafted	10	47	1470	3	rafted
rafters	10	37	1563	3	rafters
rafting	11	38	1575	3	rafting
rafts	8	78	2063	3	raft_s
ramtil	8	3	1103	3	ramtil
ranter	6	38	2682	3	ranter
raptor	8	39	1282	3	raptor
raster	6	47	3144	3	raster
rater	5	49	4328	3	ra_ter
ratio	5	52	2758	3	ra_tio
ratter	6	43	2631	3	ratter
rattier	7	40	1559	3	rattier
sabir	7	59	1700	3	sa_bir
safari	9	11	1022	3	safari
safer	8	47	2181	3	saf_er
salter	6	43	2508	3	salter
saltie	6	34	2243	3	saltie
saltier	7	43	1863	3	saltier
saltire	7	31	1304	3	saltire
santirs	7	3	1296	3	santirs
santur	6	3	1127	3	santur
sartor	6	3	1388	3	sartor
sati	4	55	3933	3	sa_ti_
satin	5	59	3522	3	sa_tin
satire	6	32	1800	3	sa_tire
satis	5	56	3368	3	sa_tis
satyr	8	4	848	3	sa_tyr
sautoir	7	3	518	3	sautoir
sifter	9	45	1623	3	sifter
smalti	8	41	1119	3	smalti_
smarter	9	41	1313	3	smarter
smartie	9	3	1017	3	smartie
smatter	9	36	1333	3	smatter
softer	9	40	1531	3	softer
softie	9	33	1248	3	softie
stir	4	57	2325	3	__stir
tactic	10	6	1275	3	tactic
taffia	12	28	690	3	taffia
tafia	8	42	1549	3	taf_ia
tapir	7	59	1706	3	ta_pir
tartar	6	32	1476	3	tartar
tarter	6	40	2356	3	tarter
tartier	7	41	2326	3	tartier
taster	6	49	3057	3	taster
tastier	7	118	1709	3	tastier
tatar	5	61	2206	3	ta_tar
tater	5	41	3861	3	ta_ter
tatter	6	40	2457	3	tatter
tattie	6	48	1751	3	tattie
tattier	7	42	1624	3	tattier
tauter	6	43	1802	3	tauter
tufter	9	31	993	3	tufter
tuftier	10	9	660	3	tuftier
unfair	9	3	623	3	unfair
upstir	8	3	538	3	upstir
vair	7	56	2414	3	va__ir
vaster	9	45	2102	3	vaster
vastier	10	36	1320	3	vastier
vatic	10	3	1642	3	va_tic
wafer	11	44	1765	3	waf_er
waffie	15	33	856	3	waffie
waft	10	61	3900	3	waft__
wafted	13	40	1214	3	wafted
wafters	13	41	1281	3	wafters
wafting	14	39	1166	3	wafting
wafts	11	69	2055	3	waft_s
wafture	13	3	485	3	wafture
wair	7	58	3005	3	wa__ir
waiter	9	43	2125	3	waiter
wanter	9	44	2305	3	wanter
wartier	10	34	1391	3	wartier
waster	9	52	2894	3	waster
water	8	47	3332	3	wa_ter
watter	9	32	2198	3	watter
wiftier	13	29	773	3	wiftier
yatter	9	41	1621	3	yatter
yautia	9	3	725	3	yautia
zaffar	21	38	504	3	zaffar
zaffer	21	39	715	3	zaffer
zaffirs	22	37	566	3	zaffirs
zoftig	19	3	297	3	zoftig

Search took 6 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	112716	0.376	475242.0
2	DLD Change Limit	112716	422	5.106	22075.2
3	Display Results	422	422	0.126	3349.2
	(SQL Overall)	178691	422	5.608	31863.6