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

137 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
maxilla1624819(None) 
axilla13289571_axilla
manilla93012471manilla
maxillae17256721maxillae
maxillas17227701maxillas
axillae14248232_axillae
axillar14247562_axillar
axillas14278962_axillas
barilla9310322barilla
latilla737952latilla
maill74420792ma_ill_
maills84215282ma_ills
mammilla1143932mammilla
manila84518302mani_la
manillas102611162manillas
manille92613272manille
mantilla1048162mantilla
matilda1044982matilda
maxillary2143442maxillary
maxima17568632maxi_ma
maximal18347092maximal
megilla1036272megilla
papilla11127912papilla
vanilla10238742vanilla
vexilla1744662vexilla
abolla8410193_abolla
ampulla1164303ampulla
ancilla948603ancilla
armilla936993armilla
axial124515193_axial_
axially1737233_axially
axil116424453_axi_l_
axile126020513_axi_le
axillars15235993_axillars
axillary18235103_axillary
axils127217503_axi_ls
bacillar1276533bacillar
bacilli1146393bacilli
barillas10310193barillas
cabrilla1245833cabrilla
calla74827073ca__lla
camarilla1374043camarilla
canella9310793canella
cavalla1257883cavalla
cedilla1036343cedilla
faille93414743fa_ille
favella1336173favella
gorilla836973gorilla
labella988943labella
lamella988613lamella
lapilli945643lapilli
latillas847363latillas
macula103013673ma_cula
mafia104418033mafi__a
magical1239783magical
magilp1137613magi_lp
magilps1234083magilps
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
mandala10310213mandala
mandola1039023mandola
mania75634153mani__a
manilas93915873manilas
manilles102312603manilles
manioca11358943manioca
maniple11249653maniple
manlily1238743manlily
mantillas1147043mantillas
maquila1844703maquila
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
marital92314183marital
marsala939583marsala
masala8311813ma_sala
matildas1145023matildas
matinal9312603matinal
maxi137023563maxi___
maxicoat1945033maxicoat
maxim165216003maxi__m
maximally2344393maximally
maximals19325223maximals
maximin1835263maximin
maxims17399673maxi_ms
maximum1743573maximum
maxing164817073maxi_ng
maxis145721563maxi__s
maxixe1435223maxi_xe
maxixes1535253maxixes
maxwell1942513maxwell
maxwells2042653maxwells
mazily20610393mazi_ly
medulla1044713medulla
megillah1443233megillah
megillas1145893megillas
micella11106823micella
milia72719573m__ilia
mill66541483m__ill_
mille75029133m__ille
mills75435053m__ills
milpa92111403m__ilpa
mixible18195093mixible
mouille937843mouille
moviola1244823moviola
mulla74317113m__ulla
paella8410913pa_ella
papillae12137023papillae
papillar1296713papillar
patella938953patella
perilla9311233perilla
premaxilla2151753premaxilla
rachilla1345713rachilla
ramtilla1054733ramtilla
salsilla844023salsilla
scilla8310943_scilla
squilla1635533squilla
taille63116923ta_ille
vanillas11228123vanillas
variola1068893variola
vexillar1843463vexillar
villa85321233__villa
walla85321033wa__lla
waxbill1943133waxbill_
waxbills2042783waxbills
waxily19218413waxi_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.436409841.7
2DLD Change Limit1340271376.94019312.2
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.42224075.9
 
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.