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

140 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
mandolas113913(None) 
mandalas1139441mandalas
mandola1039021mandola_
bandoras1138742bandoras
candelas1139532candelas
canolas9313992can_olas
gondolas1046192gondolas
mandala10310212mandala_
mandiocas1443942mandiocas
mandolin1148582mandolin
mandolins1248432mandolins
mangolds1235192mangolds
manholes13311182manholes
manilas93915872man_ilas
manillas102611162manillas
maniocas12298472maniocas
pandoras11310052pandoras
aldolase944773_aldolase
aldols7109713_aldol_s
amidols10457563amidol_s
angoras8811363_angoras
anlas55626933_an__las
annonas738793_annonas
anoas57226493_an_o_as
anoles64827433_an_oles
areolas71013863_areolas
bandanas11178573bandanas
bandas95120543band__as
bandogs1138363bando_gs
bandora1038813bandora_
bandores11311603bandores
candela1089743candela_
candidas12338643candidas
candles104422343cand_les
candors104216763cando_rs
candours11408643candours
canellas10310563canellas
cannolis1037863cannolis
cannulas1037583cannulas
canola8313623can_ola_
cantalas104013523cantalas
canulas9312853can_ulas
canzonas1935383canzonas
condoles113015803condoles
dandles94218533dand_les
dongolas1045343dongolas
fandoms13229473fando_ms
fanfolds15104073fanfolds
girandolas1252243girandolas
gondola946663gondola_
granolas938053gran_olas
handclap1643653handclap
handclaps1743493handclaps
handclasp1742863handclasp
handholds1745003handholds
handles114020653hand_les
handoffs1844733handoffs
handouts1238233handouts
indoles83716363_indoles
indols74714203_indol_s
maculas113114023ma_culas
madonnas1143843ma_donnas
madras94316433ma_d_ras
madronas11288493madronas
magnolias1244723magnolias
maltols939403maltol_s
manacles1239523manacles
mananas93414733man_anas
manas76240433man___as
mandalic1347803mandalic
mandamus1345523mandamus
mandates11314093mandates
mandibles1445543mandibles
mandioca1354113mandioca_
mandoline1248413mandoline
mandolines1347103mandolines
mandrels1137313mandrels
mandrills1245453mandrills
mandrils1138493mandrils
mangas94122923man__gas
mangels103614493mangel_s
mangles104021463man_gles
mangoes104316133mango_es
mangold1137213mangol_d
mangos94319333mango__s
manhole12311343manhol_e
manhoods1447243manhoods
manias84029033man__ias
manifolds1583673manifolds
manila84518303man_ila_
manilla93012473manilla_
manilles102312603manilles
manioca11358943manioca_
maniocs113611443manio_cs
maniples12269423maniples
mannas85019803man__nas
mannoses1039083mannoses
manors84420883man_o_rs
manos74933623man_o__s
manropes1237913manropes
mantas85725363man__tas
mantels94515043mantel_s
mantillas1147043mantillas
mantles94820703man_tles
mantras93815863man_tras
mantuas93410993man_tuas
manuals9311213manual_s
maquilas1944033maquilas
marsalas1038253marsalas
masalas9312053ma_salas
maxillas17227703maxillas
maypoles1545993maypoles
menfolks1742903menfolks
molas75132093m___olas
mondos95217333mondo__s
mongols103310823mongol_s
moolas83615593m__oolas
moviolas1344513moviolas
nandinas936573nandinas
noncolas1048613noncolas
pandas95521963pand__as
pandoors11258983pandoors
pandora1039543pandora_
pandores11312453pandores
pandours11317993pandours
panduras1136953panduras
payolas12148973pa_yolas
radulas839583ra_dulas
randoms102112433rando_ms
ranulas7311773ran_ulas
sandals82715203sandal_s
sandblast1255653sandblast
sandglass1143723sandglass
sandlots938293sandlots
santols73513323santol_s
tandoors9258053tandoors
vandals113211663vandal_s
vandas103915993vand__as
vanillas11228123vanillas
variolas1168533variolas

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.423422437.4
2DLD Change Limit1461621407.26620115.9
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.73523101.6
 
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.