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

201 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
mandala1031021(None) 
mandalas1139441mandalas
mandola1039021mandola
bandana10179462bandana
candela1089742candela
cantala94114672cantala
manana84816072man_ana
mandalic1347802mandalic
mandate10315572mandate
mandolas1139132mandolas
manila84518302man_ila
manilla93012472manilla
manual8313462manual_
manuals9311222manuals
marsala939582marsala
masala8311822ma_sala
sandal73317282sandal_
sandals82715202sandals
vandal103713832vandal_
vandals113211662vandals
amygdala1551663amygdala
anal48037523_an_al_
annal56520763_annal_
annals66415923_annals
anodal72512123_anodal_
argala74712673_argala
banal75925993ban_al_
banana83213413ban_ana
banda85223113band__a
bandage11311023bandage
bandaid11310483bandaid
bandanas11178573bandanas
bandanna11174073bandanna
bandas95120543banda_s
bandora1038813bandora
cabala103516913ca_bala
cabbala1367183cabbala
canal75428043can_al_
canals84421673can_als
candelas1139533candelas
candida114110253candida
candle94321483cand_le
canella9310793canella
cannula937443cannula
canola8313623can_ola
cantal84122033cantal_
cantalas104013523cantalas
cantals93919573cantals
cantata93811813cantata
canula8312973can_ula
caudal91611483caudal_
daedal849083daedal_
dandily12279633dandily
dandle84218093dand_le
falbala1235873falbala
gondola946663gondola
habdalah1742623habdalah
hadal95518123ha_dal_
halala94715093ha_lala
handax1749583handa_x
handball1487033handball
handclap1643653handclap
handily143610873handily
handle104219293hand_le
havdalah1842153havdalah
hawala12368913ha_wala
indaba935633_indaba
kabala124011553ka_bala
kabbala1584613kabbala
kamala12339973ka_mala
kanaka9357523kan_aka
landau7310613landa_u
landaus8310343landaus
landfall1244203landfall
lantana739613lantana
macula103013673ma_cula
madam10316223ma_da_m
madame1139853ma_dame
madams11310943ma_dams
madly115218133ma_d_ly
madrasa10387883madrasa
magdalen1243533magdalen
magmata1237463magmata
mammal95112763mammal_
mammals10389273mammals
mana65341963man___a
manacle11310283manacle
manage93818903man_age
mananas93414733man_anas
manas76240433man_a_s
manat76039993man_a_t
manats84623463man_ats
mandamus1345523mandamus
mandarin11411023mandarin
mandatary1543243mandatary
mandated12310293mandated
mandates11314093mandates
mandator1148183mandator
mandible1337543mandible
mandioca1354113mandioca
mandolin1148583mandolin
mandrake1546003mandrake
mandrel1038683mandrel
mandrels1137313mandrels
mandril1049353mandril
mandrill1146613mandrill
mandrils1138493mandrils
manful11610213manful_
manga85026213man__ga
mangaby1535353mangaby
mangas94122933manga_s
mangel94017543mangel_
mangels103614493mangels
mangily1339753mangily
mangle93921333man_gle
mangold1137213mangold
manhole12311343manhole
mania75634153man__ia
maniac103917973mania_c
maniacal1246723maniacal
maniacs114313063maniacs
manias84029033mania_s
manilas93915873manilas
manillas102611163manillas
manille92613273manille
manioca11358943manioca
maniple11249653maniple
manlily1238743manlily
manly105022953man__ly
manmade1237963manmade
manna75522543man__na
mannan85413623manna_n
mannans93611523mannans
mannas85019803manna_s
manpack1746063manpack
mansard1049313mansard
manta75629913man__ta
mantas85725363manta_s
mantel84317973mantel_
mantels94515043mantels
mantilla1048163mantilla
mantle84420923man_tle
mantra84116093man_tra
mantua84412023man_tua
manually1347043manually
manuary1237773manuary
manward1349093manward
maquila1844703maquila
maraca10314153ma_raca
marsalas1038263marsalas
masalas9312073ma_salas
mascara1138023mascara
mastaba1146223mastaba
maxilla16248193maxilla
mayday1535883mayda_y
maydays1634493maydays
medaka1336343m_edaka
medal86221333m_edal_
medals94218063m_edals
mendable131510583mendable
menial84223033menial_
menials94015693menials
mensal84615663mensal_
mental84521603mental_
modal85919243m_odal_
modals93914463m_odals
monadal1047893monadal_
mundane1038073mundane
nala46930393__n_ala
nandina838913nandina
nyala836823__nyala
panada94113053pan_ada
panama104213353pan_ama
panda85022613pand__a
pandani1039903pandani
pandas95521963panda_s
pandora1039543pandora
pandura1037143pandura
qabala17399193qa_bala
radula749313ra_dula
randan7315253randa_n
randans8313213randans
ranula6311813ran_ula
sandable111612823sandable
sandaled1039243sandaled
sandarac1145833sandarac
sandfly1435643sandfly
sardana838643sardana
scandal1038673scandal_
scandals1136993scandals
sendal73314993sendal_
sendals81912273sendals
tambala1138023tambala
tampala1136613tampala
tantara72410823tantara
vanda94515923vand__a
vandalic1446113vandalic
vandas103915993vanda_s
vanilla10238753vanilla
wandle105316663wand_le
zanana153810363zan_ana

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.406440125.6
2DLD Change Limit1340272016.86019537.5
3Display Results2012010.0762644.7
 (SQL Overall)1786912017.34224338.2
 
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.