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

275 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
manatee931766(None) 
manatees10310421manatees
emanate9312472emanat_e
emanated1139162emanated
emanates10311332emanates
lanate6421262lanat_e
lanated8313202lanated
magnate10512702magnat_e
magnates11511602magnates
malate84624552malat_e
malates93522602malates
manacle11310282manacle
manage93818902mana_ge
managed113212602managed
manager103413582manager
manages103418962manages
manat76039982manat__
manats84623462manat_s
mandate10315572mandat_e
mandated12310282mandated
mandates11314092mandates
mantel84317972man_tel
mantes84430782man_tes
mantle84420922man_tle
mentee84121292men_tee
abate76627843_abat_e
abated95918453_abated
abater85518123_abater
abates85825033_abates
adnate72913483adnat_e
agate66525143_agat_e
agates76121333_agates
agnate73314873agnat_e
agnates82813183agnates
alate55340323_alat_e
alated75625143_alated
alates64833963_alates
amputee1148863amputee
anadem939183_anadem
ananke1038283_ananke
anatase738943_anatase
anatto6139913_anatto
annates72415423annates
ansate64517863_ansat_e
ansated84214003_ansated
antae56828293_an_tae
ante46538903_an_t_e
anted66328243_an_ted
anteed75616113_an_teed
antes56334323_an_tes
antre55224523_an_tre
banshee121212453banshee
banter84825333ban_ter
binate8419773binat_e
canaled103615553canaled
canape10913513cana_pe
canapes111213083canapes
canted94825783can_ted
canteen9411083can_teen
canter85230113can_ter
cantle84522153can_tle
carate84734003carat_e
carates95630603carates
coatee84327213_coatee
cyanate12259703cyanat_e
cyanates13238423cyanates
donate73619503donat_e
donated93513863donated
donates83217223donates
emanative1447313emanative
emanator1047293emanator
enate54428143_enat_e
enates64026423_enates
fanatic12610693fanatic
galatea839943galatea
ganache1346203ganache
goatee73219533_goatee
grantee83217133gran_tee
hamate113319823hamat_e
hamates122917673hamates
hanaper1237133hanaper
hanted104124313han_ted
hantle94318203han_tle
imamate1138093imamat_e
imamates1237653imamates
innate63917313innat_e
kantele1138253kan_tele
karate105320923karat_e
karates115617473karates
khanate1437073khanat_e
khanates1535733khanates
legatee82814633legatee
lunate6316043lunat_e
lunated8310823lunated
macaber1336163macaber
macabre1335223macabre
macaque2044053macaque
machete14310883machete
machree1438513machree
madame1139853mada_me
madames12310063madames
maenades1137473maenades
mahatma1443783mahatma
makable15510203makable
malaise9312673malaise
maleate94117543maleat_e
maleates103316343maleates
mallee84525593ma_llee
maltase938903maltase
malted94819853ma_lted
mammate104411273mammat_e
mammee94417853ma_mmee
mana65341943mana___
manacled1336453manacled
manacles1239523manacles
managers112911003managers
manakin131810643manakin
manana84816073mana_na
mananas93414733mananas
manas76240423mana__s
manatoid1148813manatoid
manche133515103man_che
manches143818623manches
manchet143317773manchet
mandator1148173mandator
mandrel1038683mandrel
mane65052013man___e
maned86634093man__ed
manege94113203man_ege
maneges103612143maneges
manes76648953man__es
mangabey1643463mangabey
manganese1244803manganese
mange84930183man__ge
mangel94017533man_gel
manger94325003man_ger
manges94628943man_ges
mangey123614523man_gey
mangier104114063mangier
mangle93921323man_gle
mangled113615253mangled
mangler103215643mangler
mangles104021463mangles
mangoes104316133mangoes
manhole12311343manhole
manille92613273manille
maniple11249653maniple
manito8518693manit_o
manitos9314053manitos
manitou938463manitou
manitu8315823manit_u
manitus9310923manitus
manlier92414023manlier
manlike133012783manlike
manmade1237963manmade
manned94418643man_ned
manner84020513man_ner
mannite9312903mannite
mannites10312613mannites
mannose939243mannose
manque17259513man_que
manrope1138033manrope
manse75528223man__se
manses84225513man_ses
manta75629903man_t_a
mantas85725363man_tas
manteau937863man_teau
mantelet10613823man_telet
mantels94515043man_tels
mantic104120903man_tic
mantid93820373man_tid
mantis83926033man_tis
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
mantra84116093man_tra
mantua84412023man_tua
manure8313653man_ure
manured1039473manured
manurer938583manurer
manures9313353manures
manwise1239183manwise
marinate103017783marinat_e
marinated122513173marinated
marinates112516383marinates
marquee18218583marquee
marted94425213ma_rted
marten84518263ma_rten
masted94025803ma_sted
master84831343ma_ster
mate65154213m__at_e
mated85537783m__ated
mater74438863m__ater
mates75251363m__ates
matey107022663m__atey
matinee92415613matinee
matte75626843m__atte
matted94521413ma_tted
matter84325343ma_tter
mattes85624533ma_ttes
meated94222403m_eated
menace103216943mena_ce
menaced122710093menaced
menacer112610883menacer
menaces112715523menaces
menage93216543mena_ge
menages103615393menages
mentees93214503men_tees
mestee84523883m_estee
metate82720533metat_e
metates92720003metates
minable112315073minable
minae75627723mina__e
minaret9520683minaret
minster93914323minster
mintage101110123mintage
minted94220583min_ted
minter84425103min_ter
minute83414293minut_e
minuted10329503minuted
minuter93510403minuter
minutes93513433minutes
misate81222693misat_e
moated94819003m_oated
monades103713823monades
monster93214593monster
montage101211713montage
montane91313623montane
monte75829773mon_t_e
montes84226933mon_tes
munster93710523munster
mustee83922103m_ustee
mutate83017483mutat_e
mutated102712253mutated
mutates92215793mutates
nates55238333__nates
ornate6315133ornat_e
palate84226783palat_e
palates93624933palates
panacea1137783panacea
panache1458423panache
panatela1044913panatela
panted95024823pan_ted
pantie84326473pan_tie
pattee84323383pa_ttee
penates93321593penates
planate9314573planat_e
qanat144426843qanat__
qanats154112813qanat_s
ramate83921683ramat_e
ranee55438103ran__ee
ranted74324703ran_ted
ranter63826823ran_ter
ratafee1047513ratafee
sanative11310473sanative
sangaree949333sangaree
savate9313783savat_e
savates10312953savates
senate63725143senat_e
senates73322583senates
snathe94415113_snathe
tanager83010943tanager
tannate71813523tannat_e
tannates81911953tannates
vacate11314553vacat_e
vacated1349353vacated
vacates12312833vacates
vantage11109893vantage
wannabee1343993wannabee
wantage11119623wantage
wanted104319723wan_ted
wanter94423053wan_ter
zapateo1844593zapateo
zonate154114923zonat_e
zonated173310533zonated

Search took 7 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.1561145455.1
2DLD Change Limit1340272756.67320085.0
3Display Results2752750.1102500.0
 (SQL Overall)1786912756.93925751.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.