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

164 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
manillas10261116(None) 
manilas93915871mani_las
manilla93012471manilla_
manilles102312591manilles
mantillas1147041mantillas
maxillas17227701maxillas
vanillas11228121vanillas
ancillas1048032_ancillas
axillas14278962_axillas
barillas10310192barillas
canellas10310562canellas
latillas847362latillas
maills84215282ma_ill_s
mandalas1139432mandalas
mandolas1139132mandolas
manias84029032mani__as
manila84518302mani_la_
manille92613272manill_e
maniocas12298462maniocas
maniples12269422maniples
mantilla1048162mantilla_
matildas1145022matildas
maxilla16248192maxilla_
maxillae17256722maxillae
megillas1145892megillas
vanilla10238742vanilla_
amanitas1048523amani_tas
ancilla948603_ancilla_
ancillae1047653_ancillae
anilins7416793_anilins
anils56326723_ani_l_s
animals94111703_animals
animas84418723_ani_mas
anlas55626933_an__las
armillas1046663armillas
axilla13289573_axilla_
axillae14248233_axillae
axillar14247563_axillar
axillars15235983_axillars
bacillar1276533bacillar
bacillus1245153bacillus
barilla9310323barilla_
cabrillas1345603cabrillas
callas84526753ca__llas
camarillas1473423camarillas
canailles1148263canailles
candelas1139533candelas
canella9310793canella_
cannulas1037583cannulas
canolas9313993can_olas
cantalas104013523cantalas
canulas9312853can_ulas
cavallas1366843cavallas
cedillas1145733cedillas
failles102914123fa_illes
favellas1446163favellas
gorillas946373gorillas
lamellas1098153lamellas
lanitals837723lanitals
lapillus1043933lapillus
latilla737953latilla_
maculas113114013ma_culas
mafias113913573mafi__as
magilps1234083magi_lps
magnolias1244713magnolias
mailbag1243923ma_ilbag
mailbags1343903ma_ilbags
mailers94420333ma_ilers
mailes84329113ma_i_les
maill74420783ma_ill__
mailless10248583ma_illess
maillot9312173ma_illot
maillots1037453ma_illots
mailman1137733ma_ilman
mails76037773ma_i_l_s
malls76233433ma__ll_s
mammilla1143933mammilla_
mammillae1243043mammillae
manacles1239523manacles
mananas93414733man_anas
manas76240423man___as
manciples1564793manciples
mandala10310203mandala_
mandibles1445543mandibles
mandiocas1443943mandiocas
mandola1039023mandola_
mandrills1245453mandrill_s
maneless102812343maneless
mangas94122923man__gas
mangels103614493mangel_s
manglers113311903manglers
mangles104021463man_gles
mangolds1235193mangolds
manholes13311183manholes
mania75634143mani__a_
maniac103917973mani__ac
maniacal1246723maniacal
maniacs114313063mani_acs
manics103919933mani__cs
manifolds1583673manifolds
manihots13126443manihots
manikins14189723manikins
manioca11358943manioca_
maniocs113611443mani_ocs
maniple11249653manipl_e
manipular1344223manipular
manipulars1453133manipulars
manitos9314053mani_tos
manitous1039173manitous
manitus9310923mani_tus
manless93012933man_less
manlily1238743manlil_y
mannas85019803man__nas
mantas85725363man__tas
mantels94515043mantel_s
mantissas1143873mantissas
mantles94820703man_tles
mantlets104611203mantlets
mantras93815863man_tras
mantuas93410993man_tuas
manuals9311213manual_s
maquilas1944033maquilas
marimbas1444363marimbas
marinas93519373mari_nas
marsalas1038253marsalas
masalas9312053ma_salas
matilda1044983matilda_
maxillary2143443maxillary
maximals19325223maximals
medullas1144513medullas
megilla1036273megilla_
megillah1443233megillah
megillahs1542233megillahs
menials94015683menial_s
milles84526563m__illes
mills75435053m__ill_s
milpas101710273m__ilpas
minilab11126003mini_lab
minilabs12124573minilabs
minimals12327423minimals
moviolas1344513moviolas
mullas84215933m__ullas
nills54926673__nill_s
paellas9411413pa_ellas
panicles121010103panicles
papilla11127913papilla_
papillae12137013papillae
papillar1296713papillar
patellas1039103patellas
perillas10310813perillas
ramtillas1174193ramtillas
ranulas7311773ran_ulas
salsillas943853salsillas
sanicles10149943sanicles
scillas9310463_scillas
squillas1745323squillas
tailles72516463ta_illes
vanillic1344263vanillic
vanillin1145903vanillin
vanillins1245543vanillins
variolas1168533variolas
villas96117263__villas
wallas95719393wa__llas
zorillas1745483zorillas

Search took 10 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.1561145455.1
2DLD Change Limit1461621648.86016496.8
3Display Results1641640.0762157.9
 (SQL Overall)1786911649.09219653.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.