Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

Here are the results of your fuzzy-string dictionary search for “mannite” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

294 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
mannite931290(None) 
mannites10312611mannites
cannie83819362canni_e
dunnite857332dunnite
gahnite1135972gahnite
kainite1149542kainite
magnate10512702magnate
mandate10315572mandate
manganite1247782manganite
manito8518692ma_nito
manitu8315822ma_nitu
manlike133012782manlike
manning103616382manning
mannish121710702mannish
mannitic1248012mannitic
mannitol1044042mannitol
mannose939242mannose
manwise1239182manwise
marlite92917082marlite
marmite112413992marmite
masonite1049682masonite
nannie63713222nanni_e
stannite847582stannite
tannate71813522tannate
umangite1144822umangite
aconite9315473aconite
adnate72913483_adnate
agnate73314883_agnate
agnize16329563_agnize
albite8313313_albite
almandite1245093almandite
alunite7311633alunite
amandine1148553amandine
amanita9310453amanita
amazonite2044213amazonite
amenity1238333amenity
aminity12310513aminity
ammonite1249143ammonite
amniote936963amniote
amosite9313163amosite
anile54634463_a_nile
anime75423203_a_nime
anise55129713_a_nise
annates72415423_annates
annexe1337813_annexe
annuity1045543_annuity
ansate64517863_ansate
ante46538903_a_n_te
aplite8316393_aplite
arenite71017713arenite
augite7312613_augite
auntie64317703_auntie
axite125218253_a_xite
bandit93821133bandit_
bandito103710043bandito
bandits103814793bandits
bankit123617043bankit_
bankits133410153bankits
banknote1444833banknote
bannet84925333bannet_
bannets94013843bannets
banning103818233banning
bannister1155373bannister
barite84224813ba_rite
bauxite1635573bauxite
bonnie85314853bonni_e
bornite9311183bornite
braunite1047253braunite
calcite11413783calcite
canine83826703ca_nine
caninity1338063caninity
cannier94014163cannier
cannily1239263cannily
canning103620133canning
cannister1155723cannister
cannot83616773cannot_
canonise10511093canonise
canonize1959833canonize
carnie84421093carni_e
connate9315753connate
connive1238993connive
connote9311613connote
crinite9513633crinite
cyanite122710763cyanite
dacite91115883da_cite
dunite7315013_dunite
dunnites947173dunnites
ebonite9310293ebonite
emanate9312473ema_nate
endite73817593_endite
fanlike142610503fanlike
fannies103415643fannies
fanning113615073fanning
fanwise1336633fanwise
fanzine1937123fanzine
finite9316823_finite
gahnites1235703gahnites
galenite91210063galenite
gannet74321853gannet_
gannets83811443gannets
gannister1054173gannister
granite82017083granite
grannie8310353granni_e
gunite7414403_gunite
halite93624233ha_lite
hankie133915713hanki_e
haplite12310703haplite
ichnite1245983ichnite
ignite71410583_ignite
inanity1039503inanity
incite83618733_incite
indite73520323_indite
innate63917313_innate
invite93715033_invite
jadeite1546403jadeite
kainit10414483kainit_
kainites1238793kainites
kainits1137763kainits
kernite1159473kernite
kunzite2053503kunzite
kyanite14237313kyanite
lanate6421263la_nate
lenite6719983_lenite
lignite81310303lignite
machete14310883machete
machine14313493machine
magnates11511613magnates
magnesite12969313magnesite
magnet9320663magnet_
magnetite127311213magnetite
magneto1046743magneto
magnets10311143magnets
magnify1634533magnify
magnitude1343363magnitude
magpie1139093magpi_e
maile75232223ma__ile
mainline1039863mainline
maize164618563ma__ize
malaise9312673malaise
malate84624563ma_late
maleate94117543maleate
malice104818483ma_lice
maline84529093ma_line
mamie95826003ma_mi_e
mammate104411273mammate
mammie94313783mammi_e
manacle11310283manacle
manage93818903ma_nage
manat76039993ma_nat_
manatee9317663manatee
manats84623463ma_nats
manche133515103ma_nche
manchet143317783manchet
manciple1445093manciple
mandated12310293mandated
mandates11314093mandates
mandible1337543mandible
mane65052033ma_n__e
manege94113203ma_nege
manganate1246403manganate
manganites1347033manganites
mange84930203ma_n_ge
mangier104114063mangier
mangily1339753mangily
mangle93921333ma_ngle
manhole12311343manhole
mania75634153ma_ni_a
maniac103917973ma_niac
manias84029033ma_nias
manic94629443ma_ni_c
manics103919933ma_nics
manila84518303ma_nila
manille92613273manille
manioc103914823ma_nioc
maniple11249653maniple
manitos9314053ma_nitos
manitou938463ma_nitou
manitus9310923ma_nitus
mankind1437773mankind
manlier92414023manlier
manlily1238743manlily
manmade1237963manmade
manna75522543mann__a
mannan85413623mann_an
mannans93611523mannans
mannas85019803mann_as
manned94418643mann_ed
manner84020513mann_er
mannered11249653mannered
manners93417833manners
mannikin14215503mannikin
mannitols1143433mannitols
mannoses1039083mannoses
manque17259513ma_nque
manrope1138033manrope
manse75528233ma_n_se
mansion9611543mansion
manta75629913ma_n_ta
mantel84317973ma_n_tel
mantes84430783ma_n_tes
mantic104120903manti_c
mantid93820383manti_d
mantids103113623mantids
mantis83926033manti_s
mantises10317923mantises
mantle84420923ma_ntle
mantlet93620993mantlet
manumit1149573manumit_
manumits1246003manumits
manure8313653ma_nure
manzanita2043013manzanita
maplike15299273maplike
marinate103017783marinate
marine84230413ma_rine
marline93320973marline
marlites103415273marlites
marmites122212793marmites
mashie11315933mashi_e
masonites1149183masonites
massive12289773massive
mate65154223ma___te
matinee92415613matinee
matte75626843ma__tte
mavie104722563ma_vi_e
maximite1955853maximite
maxixe1435223ma_xixe
meanie83718393meani_e
meantime1245983meantime
meinie82614523meini_e
melanite10512033melanite
melinite10411753melinite
minnies93617363minnies
minute83414293m_inute
miscite11314383miscite
mite66249423m___ite
monazite1957083monazite
monie75631653m_oni_e
monte75829773m_on_te
monzonite2044833monzonite
mullite9313013mullite
munnion935863munnion
mylonite1346823mylonite
nannies73015203nannies
nite45943593___nite
pandit93820753pandit_
pandits103914213pandits
panne76623653pann__e
pannier93613353pannier
panning104019393panning
panpipe1034833panpipe
pantie84326473panti_e
pantile93918483pantile
partite9317133partite
penlite9313243penlite
pennate93314033pennate
pennine93712953pennine
pinite8321243_pinite
pinnate93613743pinnate
ranpike1335933ranpike
ratite65022423ra_tite
reunite7312713reunite
samite83020603sa_mite
sanity9316203sa_nity
saponite10410533saponite
sennit63117923sennit_
sennits73811283sennits
sienite7312713sienite
smaltite1046903smaltite
stannites947023stannites
syenite1039773syenite
taconite1049313taconite
taeniae739083taeniae
tannage8209583tannage
tannates81911953tannates
tannic82811483tanni_c
tannin62613933tanni_n
tanning83618253tanning
tannins72813223tannins
tannish101610583tannish
tanzanite1844533tanzanite
taxite13511303ta_xite
tiemannite1251783tiemannite
umangites1244483umangites
unakite1138743unakite
unite54828383__unite
uraninite946743uraninite
uranite72515693uranite
vanity12311943va_nity
vanning113912463vanning
vauntie1036633vauntie
vawntie1343943vawntie
wannabe1234533wannabe
wanning113816213wanning
zincite1837233zincite

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340272947.12618808.2
3Display Results2942940.1102672.7
 (SQL Overall)1786912947.63923391.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.