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 “mannose” 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.

226 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
mannose93924(None) 
mannoses1039081mannoses
lanose6313592la_nose
maltose939792maltose
mangoes104316132mangoes
mangos94319342mangos_
manhole12311342manhole
mannas85019802mannas_
mannish121710702mannish
mannite9312902mannite
manos74933622ma_nos_
manrope1138032manrope
manse75528232ma_n_se
manwise1239182manwise
acinose938583acinose
acnode938203_acnode
aldose7311093_aldose
amnios84912523amnios_
amniote936963amniote
amylose1237193amylose
ancone83916953_ancone
anginose945903_anginose
anise55129713_a_nise
annas55824883_annas_
annexe1337813_annexe
annona648873_annona
annoy869713_anno_y
annoyed1185873_annoyed
annoyer1095603_annoyer
annoys967523_annoys
annulose844473_annulose
anode65021043_a_node
anole55330383_a_nole
anyone94612733_anyone
appose10411993_appose
arenose7311383arenose
ariose64818733_ariose
arkose104911343_arkose
arose55832083_a_rose
bancos104713893bancos_
bandore10611633bandore
banjoes16317313banjoes
banjos15378893banjos_
banknote1444833banknote
bannock1545043bannock
banns75321233bann_s_
caboose1138273caboose
callose9313663callose
cannas84518403cannas_
cannie83819363cann_ie
cannoli937263cannoli
cannon84514443canno_n
cannoned11118143cannoned
cannons94412883cannons
cannot83616773canno_t
canoe75627253ca_no_e
canoes84725883ca_noes
canonise10511093canonise
canons85522063canons_
cansos84915383cansos_
cantos84826973cantos_
canzone1858813canzone
caseose939163caseose
conenose1078593conenose
connote9311613connote
crannoge1144263crannoge
danios7314603danios_
diagnose1045123diagnose
fannies103415643fannies
fanons96115213fanons_
fanos85926503fa_nos_
fanwise1336633fanwise
farinose1136463farinose
hanse85722793ha_n_se
hardnose1245723hardnose
hawknose1842323hawknose
hognose11117243hognose
lactose969493lactose
lacunose1083793lacunose
laminose1036913laminose
machos135217493machos_
macons104017243macons_
macros104017013macros_
madhouse1445503madhouse
madness10310073madness
madrone102812663madrone
mafiosi1244803mafiosi
mafioso1244453mafioso
magnate10512703magnate
mahoe10315573ma_ho_e
mahoes11313103ma_hoes
mains75635113main_s_
makos116518363ma_kos_
malaise9312673malaise
malposed1344563malposed
maltase938903maltase
maltoses1039863maltoses
mamboes135011823mamboes
mambos125414493mambos_
manacle11310283manacle
manage93818903ma_nage
manages103418963manages
mananas93414733mananas_
manas76240433ma_nas_
manatee9317663manatee
manats84623463manats_
manche133515103ma_nche
manches143818623manches
mandate10315573mandate
mandola1039023mandola
mane65052033ma_n__e
manege94113203ma_nege
maneges103612143maneges
manes76648963ma_nes_
manganese1244803manganese
mangas94122933mangas_
mange84930203ma_n_ge
manges94628953manges_
mangle93921333ma_ngle
mangles104021463mangles
mango85724333mango__
mangold1137213mangold
mangonel1185763mangonel
mangrove1474403mangrove
manholes13311183manholes
manhood1338993manhood
manias84029033manias_
manics103919933manics_
manille92613273manille
manioc103914823manio_c
manioca11358943manioca
maniocs113611443maniocs
maniple11249653maniple
manitos9314053manitos_
manless93012933manless
manlike133012783manlike
manmade1237963manmade
manna75522543mann__a
mannan85413623mann_an
mannans93611523mannans
manned94418643mann_ed
manner84020513mann_er
mannered11249653mannered
manners93417833manners
manning103616383manning
mannites10312613mannites
mano66536813ma_no__
manor78023933ma_no_r
manors84420883ma_nors
manpower1544703manpower
manque17259513ma_nque
manropes1237913manropes
mans66354553ma_n_s_
manses84225513ma_n_ses
mantas85725363mantas_
mantes84430783mantes_
mantis83926033mantis_
mantises10317923mantises
mantle84420923ma_ntle
mantles94820703mantles
manure8313653ma_nure
manures9313353manures
manus75924933ma_nus_
marmoset12411983marmoset
marse76231153ma__rse
masons83916513masons_
masse75125293ma__sse
matzos1749263matzos_
maunds9519653maunds_
mayos105521933ma_yos_
maypole1446383maypole
meanness1037183meanness
mense75025633m_en_se
minnies93617363minnies
minnow1135583minno_w
minnows1234913minnows
mondos95217333mondos_
mongoe94214983mongo_e
mongoes103415713mongoes
mongoose1175353mongoose
mongos94318623mongos_
monos75930863m_onos_
moose76327193m__oose
morose85116243m_orose
mucose10149313m_ucose
mungoes103510463mungoes
mungoose1153223mungoose
mungos94311373mungos_
nannie63713223nann_ie
nannies73015203nannies
narcose95910393narcose
noose55624063__noose
nose46739363___nose
pandore10411853pandore
panne76623653pann__e
pannes85522853pannes_
pantos85222743pantos_
papoose1147513papoose
pappose1047413pappose
pentose9311593pentose
ramose8314403ra_mose
rennase738713rennase
rhamnose13103463rhamnose
sannop837373sanno_p
sannops936693sannops
santos64421833santos_
spinose937943spinose
starnose8136693starnose
tacnode1045093tacnode
talcose938143talcose
tangos74216323tangos_
tannage8209583tannage
tannate71813523tannate
tannest72617853tannest
tannish101610583tannish
tannoy958363tanno_y
tannoys1055553tannoys
urinose738483urinose
vadose1037963va_dose
vamoose1235863vamoose
vamose1159283va_mose
venenose1144023venenose
venose9310843_venose
wannabe1234533wannabe
wanness102610683wanness
wannest103915003wannest

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.423422437.4
2DLD Change Limit1340272266.98319193.3
3Display Results2262260.0802825.0
 (SQL Overall)1786912267.48623870.0
 
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.