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

217 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
megilp113583(None) 
magilp1137611magilp
megilph1542261megilph
megilps1233561megilps
magilps1234082magilps
megilla1036272megilla
megilphs1641612megilphs
regild8149772regild
regilt71217492regilt
aedile73716653aedile
aegis6316783aegi_s
aerily93017013aerily
agile65122263_agile
argil65116883argil_
argils75213623argils
begall92610723begall
begin85117353begi_n
begins94415303begins
begird1036823begird
begirt9412683begirt
beguile1056933beguile
begulf1238903begulf
bezil163812883bezil_
bezils1711310603bezils
cagily12411563cagily
ceil65725063ce_il_
ceili75814793ce_ili
ceils75019403ce_ils
decile94619213decile
defile105216663defile
deil56231623de_il_
deils65722863de_ils
devil94714733devil_
devils104412813devils
dewily1338343dewily
edgily1136063edgily
edile64819493_edile
eerily92913563eerily
egal55119433_egal_
egis56520653_egi_s
email74715093email_
emails84412333emails
engild8107613engild
evil75318073_evil_
evils84114263_evils
exile126117653_exile
genip84415203geni_p
gild65526513__gild
gill56336183__gill
gilt56348543__gilt
gimp96124043__gimp
gip67645363__gi_p
gulp75521363__gulp
hegira1036523hegira
heil76328933he_il_
heils85222193he_ils
help95328923he__lp
kelp105322803ke__lp
kevil12399863kevil_
kevils13358333kevils
legal65715943legal_
legals73412733legals
legible1035833legible
legibly1344623legibly
legion75712983legion
legist71315253legist
legit61323503legi_t
legits71313003legits
logily1039833logily
magi76329523magi__
magian9312833magian
magic105818653magi_c
magics115311613magics
mail65543433m_ail_
maile75232213m_aile
maill74420783m_aill
mails76037773m_ails
mangily1339753mangily
manila84518303manila
mazily20610393mazily
meal65643173me_al_
mealie82519803mealie
meals75933373me_als
mealy104422183me_aly
meanly115412043meanly
measle83513223measle
measly113610443measly
meatily12311093meatily
medal86221323medal_
medals94218043medals
meddle103312763meddle
medfly1535223medfly
media84721713medi_a
mediad104313713mediad
mediae94217413mediae
medial93819863medial
medials103914733medials
median94117543median
medias93620783medias
medic104619653medi_c
medick154010133medick
medico113711163medico
medics114115353medics
medigap1374623medigap
medii84513493medi_i
medina94114093medina
medium113711623medium
medius93613283medius
meekly1535193meekly
meetly1138673meetly
meg66040953meg___
mega77620873meg__a
megaflop1672263megaflop
megalops1356113megalops
megara9310093megara
megass9219443megass
megillah1443233megillah
megillas1145893megillas
megohm14124193megohm
megrim1178043megrim
megrims1276103megrims
megs75530633meg__s
meikle1236653meikle
meiny104015403me_iny
mel56047483me__l_
meld75830473me__ld
melic94722333meli_c
melilot9311083melilot
mell64935613me__ll
mells75031333me_lls
mels65941533me__ls
melt65752893me__lt
menial84223033menial
menials94015683menials
meninx1538703meninx
merely111312583merely
merging112711753merging
merino8315093merino
merit7339183meri_t
merits8320873merits
merl65830973me_rl_
merle75824373me_rle
merlin83916683merlin
merls77423903me_rls
merrily1238633merrily
mesial84818083mesial
mesian84315503mesian
mesic93617863mesi_c
messily12298813messily
metal75427383metal_
metals84520883metals
metier83517693metier
meting94320593meting
metis75025903meti_s
metol75917813metol_
metols84115773metols
mettle83815723mettle
metump1235713metump
mewing123914203mewing
mewl95618323me_wl_
mewls105813233me_wls
miggle104012113miggle
mil55752103m__il_
mild75330843m__ild
mile66352563m__ile
milk105028463m__ilk
mill66541473m__ill
milo65536093m__ilo
milpa92111403m__ilpa
mils66045323m__ils
milt65455803m__ilt
mobile103613533mobile
mogul8310213mogul_
moguls948553moguls
moil65534083m_oil_
moils76125743m_oils
motile83818343motile
muggily1435103muggily
penile82219603penile
peril75425953peril_
perils84121853perils
rebill84713243rebill
redip87816963redi_p
refile95122373refile
refill94514053refill
refilm114311403refilm
regal65023793regal_
regale74821453regale
regilds996673regilds
regime95313943regime
regina75317143regina
region74614903region
regius7311923regius
regive104814323regive
reguli738143reguli
reoil55321183reoil_
reoils64516873reoils
resile64627673resile
retile65929673retile
revile94921613revile
sedile73517233sedile
senile63420213senile
sexily1638853sexily
sigil63515503sigil_
sigils73912363sigils
vagile10310543vagile
vegie94614513vegi_e
vegies104314273vegies
veil75523593ve_il_
veils84918803ve_ils
verily122616053verily
vexil1538963vexil_
vexils1647173vexils
vigil94313003vigil_
vigils104210193vigils
wergild1234043wergild
yelp95621353ye__lp

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162176.18618221.1
3Display Results2172170.0633444.4
 (SQL Overall)1786912176.38927968.5
 
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.