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

304 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
mannites1031261(None) 
mannite9312901mannite_
annates72415422_annates
dunnites947172dunnites
fannies103415642fanni_es
gahnites1235702gahnites
kainites1238792kainites
magnates11511612magnates
mandates11314092mandates
manganites1347032manganites
manitos9314052ma_nitos
manitus9310922ma_nitus
mannitic1248012mannitic
mannitol1044042mannitol
mannitols1143432mannitols
mannoses1039082mannoses
mantes84430782ma_n_tes
mantises10317922mantises
marlites103415262marlites
marmites122212792marmites
masonites1149172masonites
minnies93617362minni_es
nannies73015202nanni_es
stannites947022stannites
tannates81911952tannates
umangites1244482umangites
aconites10314353aconites
agnates82813193_agnates
agnizes17328843_agnizes
albites9313203_albites
almandites1343953almandites
alunites8310703alunites
amanitas1048533amanitas
amazonites2143613amazonites
amenities11310433amenities
aminities11312913aminities
ammonites1348143ammonites
amniotes1036603amniotes
amosites10311233amosites
animes84719593_a_nimes
anises64826693_a_nises
annexes1437203_annexes
annuities947463_annuities
antes56334323_a_n_tes
aplites9314933_aplites
arenites8917103arenites
ascites9312603_ascites
augites8312183_augites
aunties73920073_aunties
axites134913833_a_xites
bandies104124863bandi_es
banditos11347633banditos
bandits103814793bandit_s
bankits133410153bankit_s
banknotes1544313banknotes
bannets94013843bannet_s
bannister1155373bannister
bannisters1244323bannisters
banties94324763banti_es
barites94322333ba_rites
bauxites1735153bauxites
bennies93917313benni_es
bornites10310983bornites
braunites1146723braunites
bunnies94415003bunni_es
calcites12313003calcites
candies104125613candi_es
canines93724033ca_nines
caninities12410493caninities
canities101519263ca_nities
cannie83819363canni_e_
cannier94014163canni_er
canniest10313363canni_est
canniness1138643canniness
cannings113710333cannings
cannister1155723cannister
cannisters1245013cannisters
canonises11410803canonises
canonizes2049593canonizes
carnies94123963carni_es
connives1339723connives
connotes10311453connotes
crannies10313013cranni_es
crinites10612763crinites
cyanites132610163cyanites
dacites101114593da_cites
dainties9312403dainties
dandies94121443dandi_es
dunites8313593_dunites
dunnite857333dunnite_
ebonites1039233ebonites
emanates10311333ema_nates
endites83717063_endites
fancies124018783fanci_es
fanzines2036913fanzines
finites10315923_finites
funnies104113603funni_es
gahnite1135973gahnite_
galenites10129183galenites
gannets83811443gannet_s
gannister1054173gannister
gannisters1153843gannisters
granites92116363granites
grannies9312613granni_es
gunites8313123_gunites
gunnies83413123gunni_es
halites103221193ha_lites
hankies143617763hanki_es
haplites1339993haplites
hinnies103615103hinni_es
ichnites1345743ichnites
ignites81310583_ignites
inanities9312443inanities
incites93218483_incites
indites83618983_indites
invites103915813_invites
jadeites1645823jadeites
jennies143511623jenni_es
kainite1149543kainite_
kainits1137763kainit_s
kernites1269113kernites
kunzites2143243kunzites
kyanites15216683kyanites
lenites7818443_lenites
lignites9129613lignites
machetes1539633machetes
machines15312893machines
maenades1137473maenades
magnate10512703magnate_
magnesites131898333magnesites
magnetites138910903magnetites
magnetos1146263magnetos
magnets10311143magnet_s
magnifies1547283magnifies
magnitudes1443333magnitudes
magpies12310363magpi_es
mailes84329113ma__iles
mainlines1138513mainlines
maizes175115733ma__izes
malaises10312333malaises
malates93522603ma_lates
maleates103316343maleates
malices114316623ma_lices
malines93625603ma_lines
mamies104626243ma_mi_es
mammies104314763mammi_es
mammitis1145593mammitis
manacles1239523manacles
manages103418963ma_nages
manatee9317663ma_natee
manatees10310423manatees
manats84623463ma_nat_s
manches143818623ma_nches
manchets15269573manchets
manciples1564793manciples
mandate10315573mandate_
mandated12310293mandated
mandibles1445543mandibles
maneges103612143ma_neges
manes76648963ma_n__es
manganates1345953manganates
manganite1247783manganite_
manges94628943ma_n_ges
mangier104114063mangi_er
mangiest112815903mangi_est
manginess122010413manginess
mangles104021463ma_ngles
mangoes104316133ma_ngoes
manholes13311183manholes
maniacs114313063ma_niacs
manias84029033ma_ni_as
manics103919933ma_ni_cs
manifest1339503ma_nifest
manilas93915873ma_nilas
manilles102312603manilles
maniocs113611443ma_niocs
maniples12269423maniples
manito8518693ma_nit_o
manitou938463ma_nitou
manitous1039173ma_nitous
manitu8315823ma_nit_u
manlier92414023manli_er
manliest102314943manli_est
manlike133012783manlike_
manliness111310123manliness
mannans93611523mann_ans
mannas85019803mann__as
manned94418643mann__ed
manner84020513mann__er
mannered11249653mannered
manners93417833mann_ers
mannikin14215503mannikin
mannikins15215093mannikins
manning103616383manni_ng
mannish121710693manni_sh
mannose939243mannose_
manropes1237913manropes
manses84225513ma_n_ses
mansions1069793mansions
mantas85725363ma_n_tas
mantel84317973ma_n_tel
mantels94515043ma_n_tels
mantids103113623manti_ds
mantis83926033ma_n_tis
mantles94820703ma_ntles
mantlets104611203mantlets
manumits1246003manumit_s
manures9313353ma_nures
manwise1239183manwise_
manzanitas2152353manzanitas
marinates112516383marinates
marines93928013ma_rines
marlines103818713marlines
marlite92917073marlite_
marmite112413993marmite_
marries93825283marri_es
mashies12318253mashi_es
masonite1049683masonite_
mastitis1039103mastitis
mastixes1738253mastixes
mates75251363ma___tes
matinees102110423matinees
matrices12312083matrices
matrixes1738063matrixes
mattes85624533ma__ttes
maundies1137853maundies
mavies114923193ma_vi_es
mavises122812993ma_vises
maximites2045313maximites
maxixes1535253ma_xixes
meanies93620743meani_es
meantimes1345883meantimes
meinies92516073meini_es
melanites11410723melanites
melinites11310403melinites
meninges1137433meninges
minutes93513443m_inutes
miscites12313783miscites
mites75141803m___ites
monazites2046433monazites
monies83233163m_oni_es
montes84226933m_on_tes
monzonites2144303monzonites
mullites10411643mullites
munnions1035273munnions
mylonites1446443mylonites
nancies93516843nanci_es
nannie63713223nanni_e_
ninnies73713613ninni_es
nites55736343___nites
pandies104224503pandi_es
pandits103914213pandit_s
panmixes1934913panmixes
pannes85522853pann__es
pannier93613353panni_er
panniers10488853panniers
panpipes1135173panpipes
pansies94521983pansi_es
panties94230933panti_es
pantiles103617153pantiles
penlites10312273penlites
pennies94218813penni_es
pennines103112043pennines
pinites9319533_pinites
pinnies93318443pinni_es
randies84225663randi_es
ranpikes1435643ranpikes
ratites74920683ra_tites
reunites8312473reunites
samites93118713sa_mites
sanies63031953sa_ni_es
sanities81219773sa_nities
saponites1139943saponites
sennits73811283sennit_s
shannies113411253shanni_es
sienites8311913sienites
smaltites1145743smaltites
sonnies7315223sonni_es
stannite847583stannite_
syenites1138943syenites
taconites1148473taconites
tannages9228963tannages
tannate71813523tannate_
tannings9268633tannings
tannins72813223tanni_ns
tansies74521243tansi_es
tanzanites1944003tanzanites
tawnies102812503tawni_es
taxites1449673ta_xites
tennies73017973tenni_es
tennises82810133tennises
tiemannites1351653tiemannites
tinnitus843783tinnitus
trannies8415013tranni_es
tunnies73614263tunni_es
umangite1144823umangite_
unakites1237543unakites
unites65024853__unites
uraninites1045623uraninites
uranites82514643uranites
vanities111414493va_nities
wannabes1344473wannabes
zanies153219673za_ni_es
zincites1946633zincites

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461623047.45319611.2
3Display Results3043040.1262412.7
 (SQL Overall)1786913047.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.