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

182 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
magilps123408(None) 
magilp1137611magilp_
megilps1233561megilps
magians10310752magians
magics115311612magi_cs
mailes84329112ma_iles
maills84215282ma_ills
mails76037782ma_il_s
manilas93915872manilas
megilp1135832megilp_
megilph1542262megilph
megilphs1641612megilphs
agile65122263_agil_e
agings86312673_agings
agios65919863_agi_os
agisms9399393_agisms
agists75713173_agists
agitas7310593_agitas
ails45654713_a_il_s
alps65529243_a__lps
anils56326723_anil_s
argils75213623argil_s
arils58732203_aril_s
axils127217503_axil_s
bagels95712313bagel_s
bails75933523ba_il_s
basils85717473basil_s
cagily12411563cagil_y
cavils114014393cavil_s
daggles103611913daggles
eagles73819163eag_les
emails84412343ema_il_s
engilds974863engilds
fagins10513863fagi_ns
fails85631483fa_il_s
gaggles103512593gaggles
gilds75417523__gilds
gills64728193__gills
gilts64924263__gilts
gimps105915203__gimps
gips75632923__gi_ps
gulps84715073__gulps
haggles123312483haggles
hails85231643ha_il_s
imagines1137463imagines
imagings1234553imagings
imagisms1344903imagisms
imagists1175113imagists
jails125422943ja_il_s
kails95525213ka_il_s
mackles154415753mackles
macles107023223ma_cles
maculas113114023maculas
macules114015133macules
madcaps1435243madcaps
mafias113913573mafi_as
magalog1144913magalog
magalogs1245253magalogs
mages85036023mag__es
maggots1136563maggots
magi76329533magi___
magian9312833magi_an
magic105818653magi__c
magical1239783magical
maglev1237023mag_lev
maglevs1334693maglevs
magmas115512503mag_mas
magnets10311143magnets
magnums1234683magnums
magots9312363mag_ots
magpies12310363magpies
mags75444533mag___s
magueys1333943magueys
magus85318753mag__us
maids86327143ma_i_ds
mail65543453ma_il__
maile75232223ma_il_e
mailed95326753ma_iled
mailer84724183ma_iler
mailers94420333ma_ilers
maill74420793ma_il_l
maims96321793ma_i_ms
mains75635113ma_i_ns
mairs76228303ma_i_rs
maists85817573ma_ists
maizes175115733ma_izes
makeups1533603makeups
makings145413163makings
males75049793ma__les
malices114316623malices
maligns1038133maligns
malines93625603malines
malls76233433ma__lls
malms95021553ma__lms
malts76331753ma__lts
mamies104626243mami_es
mangels103614493mangel_s
mangily1339753mangil_y
mangles104021463mangles
mangolds1235193mangolds
maniacs114313063maniacs
manias84029033mani_as
manics103919933mani_cs
manila84518303manil_a
manilla93012473manilla
manillas102611163manillas
manille92613273manille
manilles102312603manilles
maniocs113611443maniocs
maniple11249653maniple
maniples12269423maniples
manitos9314053manitos
manitus9310923manitus
mantles94820703mantles
maples104819423ma_ples
maps86141053ma___ps
maquilas1944033maquilas
marbles114516653marbles
margins103815193margi_ns
marinas93519383marinas
marines93928013marines
markups1534963markups
marlins93420473marlins
marls75535163ma_rl_s
masalas9312053masalas
matilda1044983matilda
matildas1145023matildas
matings104516213matings
matins84527783mati_ns
mauls76524953ma_ul_s
mavies114923193mavi_es
mavins115119183mavi_ns
mavis105622723mavi__s
mavises122812993mavises
maxilla16248193maxilla
maxillas17227703maxillas
maxims17399673maxi_ms
maxis145721563maxi__s
maxixes1535253maxixes
mayings134410513mayings
maypops16104453maypops
mazily20610393mazil_y
megalops1356123megalops
megilla1036273megilla
megillas1145893megillas
miggles113512033miggles
milds86422053m__ilds
miles74645073m__iles
milks115020583m__ilks
mills75435053m__ills
milos75428013m__ilos
milpa92111403m__ilpa
milpas101710273m__ilpas
mils66045333m__il_s
milts75430713m__ilts
mips85534083m__i_ps
mobiles112813123mobiles
moguls948553mogul_s
moils76125753m_oil_s
motiles93317433motiles
nails55730403na_il_s
nargiles976793nargiles
pagings114411063pagings
pails75833063pa_il_s
palps94719563pa__lps
raggles93813283raggles
ragis66325603ragi__s
ragtops1035453ragtops
rails55937403ra_il_s
regilds996673regilds
sails55738103sa_il_s
salps74423243sa__lps
sigils73912363sigil_s
tails55634193ta_il_s
vagile10310543vagil_e
vaginas11298813vaginas
vails85825933va_il_s
vakils1337593vakil_s
vigils104210193vigil_s
waggles123812003waggles
wails86631483wa_il_s
yagis95416573yagi__s

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.440406115.9
2DLD Change Limit1340271826.39020974.5
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.89325923.5
 
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.