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

163 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
mandalas113944(None) 
mandala10310211mandala_
mandolas1139131mandolas
bandanas11178572bandanas
candelas1139532candelas
cantalas104013522cantalas
mananas93414732man_anas
mandalic1347802mandalic
mandamus1345522mandamus
mandates11314092mandates
mandola1039022mandola_
manilas93915872man_ilas
manillas102611162manillas
manuals9311212manual_s
marsalas1038252marsalas
masalas9312052ma_salas
sandals82715202sandal_s
vandals113211662vandal_s
anabas8314083_an_abas
anlas55626933_an__las
annals66415923_annal_s
argalas84011093_argalas
bananas93312223ban_anas
bandages12310633bandages
bandana10179463bandana_
bandannas12163283bandannas
bandas95120543band__as
bandoras1138743bandoras
cabalas113516003ca_balas
cabbalas1467373cabbalas
canals84421663can_al_s
candela1089743candela_
candidas12338643candidas
candles104422343cand_les
canellas10310563canellas
cannulas1037583cannulas
canolas9313993can_olas
cantala94114673cantala_
cantals93919573cantal_s
cantatas103410093cantatas
canulas9312853can_ulas
dandles94218533dand_les
falbalas1345473falbalas
gondolas1046193gondolas
habdalah1742623habdalah
habdalahs1842113habdalahs
halalas104214083ha_lalas
handaxes1938403handaxes
handballs15116183handballs
handclap1643653handclap
handclaps1743493handclaps
handclasp1742863handclasp
handles114020653hand_les
havdalah1842153havdalah
havdalahs1941883havdalahs
hawalas13348353ha_walas
indabas1045853_indabas
kabalas133911063ka_balas
kabbalas1674353kabbalas
kamalas13339123ka_malas
kanakas10327213kan_akas
landaus8310343landa_us
landfalls1343813landfalls
lantanas838263lantanas
maculas113114023ma_culas
madames12310063ma_dames
madams11310943ma_da_ms
madras94316433ma_d_ras
madrasas11317763madrasas
magdalen1243533magdalen
magdalens1342833magdalens
mammals10389273mammal_s
manacles1239523manacles
manages103418963man_ages
manana84816073man_ana_
manas76240433man___as
manats84623463man_a_ts
mandarin11411023mandarin
mandarins12410393mandarins
mandatary1543243mandatary
mandate10315573manda_te
mandated12310293mandated
mandator1148183mandator
mandators1247873mandators
mandibles1445543mandibles
mandiocas1443943mandiocas
mandolin1148583mandolin
mandolins1248433mandolins
mandrakes1646353mandrakes
mandrels1137313mandrels
mandrills1245453mandrills
mandrils1138493mandrils
mangas94122923man__gas
mangels103614493mangel_s
mangles104021463man_gles
mangolds1235193mangolds
manholes13311183manholes
maniacal1246723maniacal
maniacs114313063mania_cs
manias84029033man__ias
manila84518303man_ila_
manilla93012473manilla_
manilles102312603manilles
maniocas12298473maniocas
maniples12269423maniples
mannans93611523manna_ns
mannas85019803man__nas
mansards1148013mansards
mantas85725363man__tas
mantels94515043mantel_s
mantillas1147043mantillas
mantles94820703man_tles
mantras93815863man_tras
mantuas93410993man_tuas
manual8313463manual__
manually1347043manually
manwards1447613manwards
maquilas1944033maquilas
maracas11313773ma_racas
marsala939583marsala_
masala8311813ma_sala_
mascaras1237693mascaras
mastabas1246803mastabas
maxillas17227703maxillas
maydays1634493mayda_ys
medakas1435763m_edakas
medals94218053m_edal_s
menials94015683menial_s
modals93914453m_odal_s
nalas55528363__n_alas
nandinas936573nandinas
nyalas936903__nyalas
panadas103312213pan_adas
panamas113112763pan_amas
pandanus1136433pandanus
pandas95521963pand__as
pandoras11310053pandoras
panduras1136953panduras
qabalas18289503qa_balas
radulas839583ra_dulas
randans8313213randa_ns
ranulas7311773ran_ulas
sandal73317283sandal__
sandaled1039243sandaled
sandarac1145833sandarac
sandaracs1244703sandaracs
sandblast1255653sandblast
sandglass1143723sandglass
sardanas937813sardanas
scandals1136993scandal_s
sendals81912263sendal_s
tambalas1237033tambalas
tampalas1245473tampalas
tantalus836373tantalus
tantaras8269543tantaras
vandal103713833vandal__
vandalic1446113vandalic
vandalise1347673vandalise
vandalish1645993vandalish
vandalism1546873vandalism
vandas103915993vand__as
vanillas11228123vanillas
zananas16319563zan_anas

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.403443402.0
2DLD Change Limit1461621637.26620115.9
3Display Results1631630.0931752.7
 (SQL Overall)1786911637.76223021.3
 
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.