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
magnates11511612magnates
malate84624562malat_e
malates93522612malates
manacle11310282manacle
manage93818902mana_ge
managed113212602managed
manager103413582manager
manages103418962manages
manat76039992manat__
manats84623462manat_s
mandate10315572mandat_e
mandated12310292mandated
mandates11314092mandates
mantel84317972man_tel
mantes84430782man_tes
mantle84420922man_tle
mentee84121292men_tee
abate76627843_abat_e
abated95918453_abated
abater85518123_abater
abates85825033_abates
adnate72913483adnat_e
agate66525153_agat_e
agates76121343_agates
agnate73314883agnat_e
agnates82813193agnates
alate55340333_alat_e
alated75625153_alated
alates64833973_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
banter84825343ban_ter
binate8419773binat_e
canaled103615563canaled
canape10913523cana_pe
canapes111213083canapes
canted94825783can_ted
canteen9411083can_teen
canter85230113can_ter
cantle84522153can_tle
carate84734003carat_e
carates95630613carates
coatee84327223_coatee
cyanate12259703cyanat_e
cyanates13238433cyanates
donate73619503donat_e
donated93513863donated
donates83217223donates
emanative1447313emanative
emanator1047293emanator
enate54428153_enat_e
enates64026433_enates
fanatic12610703fanatic
galatea839973galatea
ganache1346223ganache
goatee73219533_goatee
grantee83217133gran_tee
hamate113319833hamat_e
hamates122917683hamates
hanaper1237133hanaper
hanted104124313han_ted
hantle94318203han_tle
imamate1138103imamat_e
imamates1237663imamates
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
malted94819863ma_lted
mammate104411273mammat_e
mammee94417853ma_mmee
mana65341963mana___
manacled1336453manacled
manacles1239523manacles
managers112911003managers
manakin131810643manakin
manana84816073mana_na
mananas93414733mananas
manas76240433mana__s
manatoid1148823manatoid
manche133515103man_che
manches143818623manches
manchet143317783manchet
mandator1148183mandator
mandrel1038683mandrel
mane65052033man___e
maned86634103man__ed
manege94113203man_ege
maneges103612143maneges
manes76648963man__es
mangabey1643463mangabey
manganese1244803manganese
mange84930203man__ge
mangel94017543man_gel
manger94325013man_ger
manges94628953man_ges
mangey123614533man_gey
mangier104114063mangier
mangle93921333man_gle
mangled113615263mangled
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
manse75528233man__se
manses84225513man_ses
manta75629913man_t_a
mantas85725363man_tas
manteau937863man_teau
mantelet10613823man_telet
mantels94515043man_tels
mantic104120903man_tic
mantid93820383man_tid
mantis83926033man_tis
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
mantra84116093man_tra
mantua84412023man_tua
manure8313653man_ure
manured1039473manured
manurer938583manurer
manures9313353manures
manwise1239183manwise
marinate103017783marinat_e
marinated122513173marinated
marinates112516393marinates
marquee18218583marquee
marted94425213ma_rted
marten84518263ma_rten
masted94025803ma_sted
master84831343ma_ster
mate65154223m__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
metates92720013metates
minable112315073minable
minae75627723mina__e
minaret9520683minaret
minster93914323minster
mintage101110123mintage
minted94220583min_ted
minter84425103min_ter
minute83414293minut_e
minuted10329503minuted
minuter93510413minuter
minutes93513443minutes
misate81222693misat_e
moated94819003m_oated
monades103713823monades
monster93214603monster
montage101211713montage
montane91313623montane
monte75829773mon_t_e
montes84226933mon_tes
munster93710523munster
mustee83922103m_ustee
mutate83017483mutat_e
mutated102712253mutated
mutates92215793mutates
nates55238333__nates
ornate6315143ornat_e
palate84226793palat_e
palates93624943palates
panacea1137793panacea
panache1458433panache
panatela1044913panatela
panted95024823pan_ted
pantie84326473pan_tie
pattee84323383pa_ttee
penates93321603penates
planate9314573planat_e
qanat144426843qanat__
qanats154112813qanat_s
ramate83921693ramat_e
ranee55438103ran__ee
ranted74324703ran_ted
ranter63826823ran_ter
ratafee1047523ratafee
sanative11310473sanative
sangaree949333sangaree
savate9313783savat_e
savates10312953savates
senate63725173senat_e
senates73322613senates
snathe94415113_snathe
tanager83010953tanager
tannate71813523tannat_e
tannates81911953tannates
vacate11314553vacat_e
vacated1349353vacated
vacates12312833vacates
vantage11109893vantage
wannabee1343993wannabee
wantage11119623wantage
wanted104319723wan_ted
wanter94423053wan_ter
zapateo1844593zapateo
zonate154114923zonat_e
zonated173310533zonated

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.436409841.7
2DLD Change Limit1340272757.15618729.3
3Display Results2752750.1102500.0
 (SQL Overall)1786912757.70223200.6
 
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.