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

103 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
megilla103627(None) 
megillah1443231megillah
megillas1145891megillas
cedilla1036342cedilla
manilla93012472manilla
maxilla16248192maxilla
medulla1044712medulla
megillahs1542232megillahs
megilp1135832megi_lp
megilph1542262megilph
megilps1233562megilps
perilla9311232perilla
vexilla1744662vexilla
ancilla948603ancilla
armilla936993armilla
axilla13289573_axilla
barilla9310323barilla
begall92610723begall_
begalls10319163begalls
cedillas1145743cedillas
cella75420313ce__lla
evilly1236593_evilly
fella84918653fe__lla
gill56336183__gill_
gills64728193__gills
gilly94321633__gilly
gorilla836973gorilla
guerilla943793guerilla
hegira1036523hegi_ra
hemiola12107003hemiola
latilla737953latilla
legally1138133legally
legible1035833legible
legibly1344623legibly
magical1239783magical
magilp1137613magi_lp
magilps1234083magilps
maill74420793m_aill_
maills84215283m_aills
mammilla1143933mammilla
manila84518303mani_la
manillas102611163manillas
manille92613273manille
mantilla1048163mantilla
matilda1044983matilda
maxillae17256723maxillae
maxillas17227703maxillas
media84721713medi__a
medial93819863medial_
medially14129323medially
medials103914743medials
medical12312513medical
medina94114093medi_na
medullae1143203medullae
medullar1143463medullar
medullas1144513medullas
mega77620873meg___a
megara9310093meg_ara
megilphs1641613megilphs
meikle1236653me_ikle
melilot9311083melilot
melisma1146473melisma
mell64935613me__ll_
mells75031333me__lls
menial84223033menial_
menially131111093menially
menials94015693menials
mesally12119793mesally
mesial84818083mesial_
mesially13119083mesially
metical11315363metical
micella11106823micella
milia72719573m__ilia
mill66541483m__ill_
mille75029133m__ille
mills75435053m__ills
milpa92111403m__ilpa
mouille937843mouille
moviola1244823moviola
mulla74317113m__ulla
nigella844523nigella
papilla11127913papilla
perillas10310823perillas
rebill84713253rebill_
rebills93510623rebills
refill94514053refill_
refills103711423refills
regalia839223regalia
regally1159873regally
regild8149773regi_ld
regilds996673regilds
regilt71217493regi_lt
regina75317143regi_na
reginal84814293reginal
scilla8310943_scilla
sedilia847243sedilia
sensilla845623sensilla
squilla1635533squilla
vanilla10238743vanilla
vexillar1843463vexillar
villa85321233__villa
weigela1143073weigela
zorilla1646023zorilla

Search took 7 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 Limit1340271035.90622693.4
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.35828104.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.