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

207 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
manilla9301247(None) 
manila84518301mani_la
manillas102611161manillas
manille92613271manille
mantilla1048161mantilla
maxilla16248191maxilla
vanilla10238741vanilla
ancilla948602_ancilla
axilla13289572_axilla
barilla9310322barilla
canella9310792canella
latilla737952latilla
maill74420792ma_ill_
maills84215282ma_ills
mammilla1143932mammilla
mandala10310212mandala
mandola1039022mandola
mania75634152mani__a
manilas93915872manilas
manilles102312602manilles
manioca11358942manioca
maniple11249652maniple
manlily1238742manlily
mantillas1147042mantillas
matilda1044982matilda
maxillae17256722maxillae
maxillas17227702maxillas
megilla1036272megilla
papilla11127912papilla
vanillas11228122vanillas
abolla8410193_abolla
amanita9310453amani_ta
amnia75918643amni__a
ampulla1164303ampulla
anally9513503_anally
ancillae1047653_ancillae
ancillas1048043_ancillas
anil46437433_ani_l_
anile54634463_ani_le
anilin6417793_anilin
anils56326723_ani_ls
anima74620073_ani_ma
animal85016253_animal
armilla936993armilla
axillae14248233_axillae
axillar14247563_axillar
axillas14278963_axillas
bacillar1276533bacillar
bacilli1146393bacilli
banally1249223banally
barillas10310193barillas
cabrilla1245833cabrilla
calla74827073ca__lla
camarilla1374043camarilla
canaille1048413canaille
candela1089743candela
canellas10310563canellas
cannula937433cannula
canola8313623can_ola
cantala94114673cantala
canula8312963can_ula
cavalla1257883cavalla
cedilla1036343cedilla
faille93414743fa_ille
favella1336173favella
ganglia946613ganglia
gorilla836973gorilla
haniwa1236743hani_wa
labella988943labella
lamella988613lamella
lanital7310913lanital
lapilli945643lapilli
latillas847363latillas
macula103013673ma_cula
mafia104418033mafi__a
magical1239783magical
magilp1137613magi_lp
magilps1234083magilps
magnolia1144793magnolia
mail65543453ma_i_l_
mailbag1243923ma_ilbag
maile75232223ma_i_le
mailed95326753ma_iled
mailer84724183ma_iler
mailes84329113ma_iles
maillot9312173ma_illot
mailman1137733ma_ilman
mails76037783ma_i_ls
mainly11411493ma_inly
mall64639373ma__ll_
malls76233433ma__lls
mammillae1243043mammillae
mana65341963man___a
manacle11310283manacle
manana84816073man_ana
manciple1445093manciple
mandalas1139443mandalas
mandible1337543mandible
mandioca1354113mandioca
mandolas1139133mandolas
mandrill1146613mandrill_
mandrills1245453mandrills
manful11610213manful_
manfully1645653manfully
manga85026213man__ga
mangel94017543mangel_
mangels103614493mangels
mangily1339753mangily
mangle93921333man_gle
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mangold1137213mangold
manhole12311343manhole
maniac103917973mani_ac
maniacal1246723maniacal
maniacs114313063maniacs
manias84029033mani_as
manic94629443mani__c
manically16311703manically
manics103919933mani_cs
manifold1484943manifold
manihot121112053manihot
manikin132110243manikin
manioc103914823mani_oc
maniocas12298473maniocas
maniocs113611443maniocs
maniples12269423maniples
manipular1344223manipular
manito8518693mani_to
manitos9314053manitos
manitou938463manitou
manitu8315823mani_tu
manitus9310923manitus
manlier92414023manlier
manlike133012783manlike
manly105022953man__ly
manna75522543man__na
manta75629913man__ta
mantel84317973mantel_
mantels94515043mantels
mantissa1044573mantissa
mantle84420923man_tle
mantled104113393mantled
mantles94820703mantles
mantlet93620993mantlet
mantra84116093man_tra
mantua84412023man_tua
manual8313463manual_
manually1347043manually
manuals9311223manuals
maquila1844703maquila
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
marital92314183marital
marsala939583marsala
masala8311813ma_sala
matildas1145023matildas
matinal9312603matinal
maxillary2143443maxillary
maxima17568633maxi_ma
maximal18347093maximal
mazily20610393mazi_ly
medulla1044713medulla
megillah1443233megillah
megillas1145893megillas
menial84223033menial_
menially131111093menially
menials94015693menials
micella11106823micella
milia72719573m__ilia
mill66541483m__ill_
mille75029133m__ille
mills75435053m__ills
milpa92111403m__ilpa
minilab11126003minilab
minima105512653mini_ma
minimal114010603minimal
mouille937843mouille
moviola1244823moviola
mulla74317113m__ulla
nill45634303__nill_
nills54926673__nills
paella8410913pa_ella
panicle11129983panicle
papillae12137023papillae
papillar1296713papillar
patella938953patella
perilla9311233perilla
rachilla1345713rachilla
ramtilla1054733ramtilla
ranula6311813ran_ula
salsilla844023salsilla
sanicle91210263sanicle
scilla8310943_scilla
sensilla845623sensilla
squilla1635533squilla
taille63116923ta_ille
vanillic1344263vanillic
vanillin1145913vanillin
variola1068893variola
vexilla1744663vexilla
villa85321233__villa
walla85321033wa__lla
zanily18310183zani_ly
zorilla1646023zorilla

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 Limit1340272077.29618369.9
3Display Results2072070.0802587.5
 (SQL Overall)1786912077.78222962.1
 
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.