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

192 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
manatees1031042(None) 
manatee9317661manatee_
emanates10311332emanat_es
magnates11511612magnat_es
malates93522612malat_es
manacles1239522manacles
managers112911002managers
manages103418962mana_ges
manats84623462manat__s
mandates11314092mandat_es
mantels94515042man_tels
mantes84430782man_t_es
mantles94820702man_tles
mentees93214502men_tees
abaters95115203_abaters
abates85825033_abat_es
agates76121343_agat_es
agnates82813193agnat_es
alates64833973_alat_es
amputees1245103amputees
anadems1036143_anadems
anankes1138763_anankes
anatase738943_anatase
anatases839793_anatases
anattos7138453_anattos
annates72415423annat_es
anteed75616113_an_teed
antes56334323_an_t_es
antres65021003_an_tres
banshees13127863banshees
banters94623113ban_ters
banties94324763ban_ties
canapes111213083cana_pes
canaries10318943canaries
canities101519263canities
canteen9411083can_teen
canteens1038573can_teens
canters94827733can_ters
cantles94721413can_tles
carates95630613carat_es
coatees93816553_coatees
cyanates13238433cyanat_es
donates83217223donat_es
emanate9312473emanat_e_
emanated1139163emanat_ed
emanators1147033emanators
enates64026433_enat_es
fanatics1367183fanatics
galateas937153galateas
ganaches1437433ganaches
goatees82710443_goatees
grantees92510973gran_tees
hamates122917683hamat_es
hanapers1346963hanapers
hantles104117513han_tles
imamates1237663imamat_es
kanteles1238123kan_teles
karates115617473karat_es
khanates1535733khanat_es
lanate6421263lanat_e_
lanated8313203lanat_ed
legatees9258433legatees
macaques2143953macaques
machetes1539633machetes
machrees1545503machrees
madames12310063mada_mes
maenades1137473maena_des
magnate10512703magnat_e_
mahatmas1543863mahatmas
maladies11311933maladies
malaises10312333malaises
malate84624563malat_e_
maleates103316343maleat_es
mallees93315973ma_llees
maltases1039693maltases
malteds10377603ma_lteds
mammees104411143ma_mmees
manacle11310283manacle_
manacled1336453manacled
manage93818903mana_ge_
managed113212603mana_ged
manager103413583mana_ger
manageress1343573manageress
manakins14209763manakins
mananas93414733mana_nas
manas76240433mana___s
manat76039993manat___
manatoid1148823manatoid
manches143818623man_ches
manchets15269573manchets
mandate10315573mandat_e_
mandated12310293mandat_ed
mandators1247873mandators
mandrels1137313mandrels
maneges103612143man_eges
maneless102812343maneless
manes76648963man___es
mangabeys1742033mangabeys
mangabies1446373mangabies
manganese1244803manganese
manganeses1345023manganeses
mangels103614493man_gels
mangers103521263man_gers
manges94628943man__ges
manglers113311903manglers
mangles104021463man_gles
mangoes104316133man_goes
manholes13311183manholes
manilles102312603manilles
maniples12269423maniples
manitos9314053manit_os
manitous1039173manitous
manitus9310923manit_us
manless93012933man_less
manners93417833man_ners
mannites10312613mannites
mannoses1039083mannoses
manropes1237913manropes
manses84225513man__ses
mantas85725363man_t_as
manteau937863man_teau
manteaus1036383man_teaus
mantel84317973man_t_el
mantelet10613823man_telet
mantelets1176813man_telets
mantids103113623man_tids
mantis83926033man_t_is
mantises10317923mantises
mantle84420923man_tle_
mantled104113393man_tled
mantlet93620993man_tlet
mantlets104611203mantlets
mantras93815863man_tras
mantuas93410993man_tuas
manurers1037593manurers
manures9313353man_ures
marinates112516383marinat_es
marquees19206243marquees
martens93714953ma_rtens
masters94628923ma_sters
maters85032393m__aters
mates75251363m__at_es
mateys115610943m__ateys
matinees102110423matinees
matres84522233m__atres
matters94421753ma_tters
mattes85624533m__attes
menacers12279313menacers
menaces112715523mena_ces
menages103615393mena_ges
mentee84121293men_tee_
mestees94617753m_estees
metates92720013metat_es
minarets1048843minarets
minsters103813923minsters
mintages111110513mintages
minters93822473min_ters
minutes93513443minut_es
monades103713823mona_des
monsters103314553monsters
montages111412183montages
montanes101114523montanes
montes84226933mon_t_es
munsters104010553munsters
mustees94614923m_ustees
mutates92215793mutat_es
nates55238333__nat_es
palates93624943palat_es
panaceas1236763panaceas
panaches15310293panaches
panatela1044913panatela
panatelas1144103panatelas
panties94230933pan_ties
penates93321603penat_es
qanats154112813qanat__s
ranees64623963ran__ees
ranters73323643ran_ters
ratafees1144143ratafees
sangarees1046543sangarees
sanities81219773sanities
savates10312953savat_es
senates73322613senat_es
snathes104816493_snathes
tanagers9259003tanagers
tannates81911953tannat_es
vacates12312833vacat_es
vanities111414493vanities
vantages12119023vantages
wannabees1442213wannabees
wantages12109023wantages
wanters104420093wan_ters
zapateos1943113zapateos

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621927.03020791.2
3Display Results1921920.0802400.0
 (SQL Overall)1786911927.54623680.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.