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

167 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
mandola103902(None) 
mandala10310211mandala
mandolas1139131mandolas
bandora1038812bandora
candela1089742candela
canola8313622can_ola
gondola946662gondola
mandalas1139442mandalas
mandioca1354112mandioca
mandolin1148582mandolin
mangold1137212mangold
manhole12311342manhole
manila84518302man_ila
manilla93012472manilla
manioca11358942manioca
pandora1039542pandora
aldol61212333_aldol_
aldols7109713_aldols
amidol9489573amidol_
amidols10457563amidols
angora71111573_angora
annona648873_annona
anoa45634473_an_o_a
anodal72512123_anodal
anole55330383_an_ole
areola6813673_areola
banda85223103band__a
bandana10179463bandana
bandog1038723bando_g
bandogs1138363bandogs
bandoras1138743bandoras
bandore10611633bandore
candelas1139533candelas
candida114110253candida
candle94321483cand_le
candor94516423cando_r
candors104216763candors
candour104210243candour
canella9310793canella
cannoli937263cannoli
cannula937433cannula
canolas9313993can_olas
cantala94114673cantala
canula8312963can_ula
canzona1836073canzona
condole102914953condole
dandily12279633dandily
dandle84218093dand_le
dongola945473dongola
eidola737683_eidola
fandom122110893fando_m
fandoms13229473fandoms
fanfold1485373fanfold
girandola1152543girandola
gondolas1046193gondolas
granola837913gran_ola
handclap1643653handclap
handhold1645633handhold
handily143610873handily
handle104219293hand_le
handoff1756483handoff
handout11314103handout
indol63714873_indol_
indole74516053_indole
indols74714203_indols
macula103013673ma_cula
madly115218133ma_d_ly
madonna1044403ma_donna
madrona10288703madrona
magnolia1144793magnolia
maltol8310843maltol_
maltols939403maltols
mana65341963man___a
manacle11310283manacle
manana84816073man_ana
mandalic1347803mandalic
mandate10315573mandate
mandible1337543mandible
mandiocas1443943mandiocas
mandoline1248413mandoline
mandolins1248433mandolins
mandrel1038683mandrel
mandrels1137313mandrels
mandril1049353mandril
mandrill1146613mandrill
mandrils1138493mandrils
manful11610213manful_
manga85026203man__ga
mangel94017533mangel_
mangels103614493mangels
mangily1339753mangily
mangle93921323man_gle
mango85724323mango__
mangoes104316133mangoes
mangolds1235193mangolds
mangos94319333mango_s
manholes13311183manholes
manhood1338993manhood
mania75634153man__ia
manifold1484943manifold
manilas93915873man_ilas
manillas102611163manillas
manille92613273manille
manioc103914823manio_c
maniocas12298473maniocas
maniocs113611443maniocs
maniple11249653maniple
manlily1238743manlily
manly105022953man__ly
manna75522543man__na
mannose939243mannose
mano66536813man_o__
manor78023933man_o_r
manors84420883man_ors
manos74933623man_o_s
manrope1138033manrope
manta75629913man__ta
mantel84317973mantel_
mantels94515043mantels
mantilla1048163mantilla
mantle84420923man_tle
mantra84116093man_tra
mantua84412023man_tua
manual8313463manual_
manuals9311213manuals
manyfold1792743manyfold
maquila1844703maquila
marsala939583marsala
masala8311813ma_sala
mausolea1043073mausolea
maxilla16248193maxilla
maypole1446383maypole
menfolk1643883menfolk
mola66035633m___ola
mondo85721233mondo__
mondos95217333mondo_s
mongol94912533mongol_
mongols103310823mongols
moola75117033m__oola
moviola1244823moviola
nandina838913nandina
noncola948293noncola
panda85022613pand__a
pandoor10358583pandoor
pandoras11310053pandoras
pandore10411853pandore
pandour10408213pandour
pandura1037143pandura
payola11208113pa_yola
radula749313ra_dula
random92513553rando_m
randomly1443793randomly
randoms102112433randoms
ranula6311813ran_ula
sandal73317283sandal_
sandals82715203sandals
sandfly1435643sandfly
sandlot8311693sandlot
santol64515243santol_
santols73513323santols
tandoor8278563tandoor
vanda94515923vand__a
vandal103713833vandal_
vandals113211663vandals
vanilla10238743vanilla
variola1068893variola
wandle105316663wand_le

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.500357382.0
2DLD Change Limit1340271677.01619103.1
3Display Results1671670.0602783.3
 (SQL Overall)1786911677.57623586.5
 
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.