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

285 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
magilp113761(None) 
magilps1234081magilps
megilp1135831megilp
agile65122262_agile
cagily12411562cagily
magi76329522magi__
magian9312832magian
magic105818652magi_c
magics115311612magics
mail65543442ma_il_
maile75232222ma_ile
maill74420792ma_ill
mails76037782ma_ils
mangily1339752mangily
manila84518302manila
mazily20610392mazily
megilph1542262megilph
megilps1233562megilps
vagile10310542vagile
agin56132713_agi_n
aging77026353_aging
agio57828453_agi_o
agios65919863_agios
agism84614063_agism
agist66325583_agist
agita6315423_agita
agly86821803_ag_ly
ail37171043_a_il_
ails45654713_a_ils
alp56641133_a__lp
anil46437433_anil_
anile54634463_anile
anils56326723_anils
argil65116883argil_
argils75213623argils
aril45843023_aril_
arils58732203_arils
atilt54828473_atilt
axil116424453_axil_
axile126020513_axile
axils127217503_axils
bagel85116793bagel_
bagels95712313bagels
baggily1436043baggily
bail65042803ba_il_
bails75933523ba_ils
basil75122273basil_
basils85717473basils
cagier93715933cagier
caging105321023caging
cavil103816493cavil_
cavils114014393cavils
daggle93711903daggle
daily95922333da_ily
eagle64219483eag_le
easily9313023easily
edgily1136063edgily
email74715103ema_il_
emails84412343ema_ils
engild8107613engild
facile112514883facile
fagin9216573fagi_n
fagins10513863fagins
fail74840243fa_il_
fails85631483fa_ils
family143311703family
fragile1147843fragile
gaggle93412623gaggle
gaging94718403gaging
gaily95020973ga_ily
gamily123712183gamily
gild65526513__gild
gill56336183__gill
gilt56348543__gilt
gimp96124043__gimp
gip67645363__gi_p
gulp75521363__gulp
habile11515213habile
haggle113511983haggle
hail74839063ha_il_
hails85231643ha_ils
hazily2179063hazily
imagine1037883imagine
imaging1138083imaging
imagism1285083imagism
imagist1077333imagist
jail115529093ja_il_
jails125422943ja_ils
kail85131493ka_il_
kails95525213ka_ils
labile8315223labile
lacily11612763lacily
lazily1859713lazily
logily1039833logily
macing114221553macing
mackle143716433mackle
macle96127003ma_cle
macula103013673macula
macule104115273macule
madcap1336333madcap
madly115218133ma_dly
mafia104418033mafi_a
mafias113913573mafias
mafic125615463mafi_c
mag67956473mag___
magalog1144903magalog
mage75739123mag__e
mages85036023mag_es
maggot10311703maggot
magians10310753magians
magical1239783magical
maglev1237023maglev
magma104513573mag_ma
magmas115512503magmas
magnet9320663magnet
magnify1634533magnify
magnum1136733magnum
magot8326393mag_ot
magots9312363magots
magpie1139093magpie
magpies12310363magpies
mags75444523mag__s
maguey1236833maguey
magus85318753mag_us
maid75537643ma_i_d
maids86327143ma_ids
maigre9309163maigre
mailed95326753ma_iled
mailer84724183ma_iler
mailes84329113ma_iles
maills84215283maills
maim85831483ma_i_m
maims96321793ma_ims
main65345513ma_i_n
mainly11411493mainly
mains75635103ma_ins
mair66133773ma_i_r
mairs76228303ma_irs
maist75535683ma_ist
maize164618563ma_ize
makeup1434863makeup
making134823843making
male66052293ma__le
malic94525653mali_c
malice104818483malice
malign939853malign
maline84529083maline
mall64639363ma__ll
malls76233433ma_lls
malm85129973ma__lm
malt66254803ma__lt
mamie95826003mami_e
mamies104626243mamies
mangel94017533mangel_
mangels103614493mangels
mangier104114063mangier
mangle93921323mangle
mangold1137203mangold
mania75634143mani_a
maniac103917973maniac
manias84029033manias
manic94629433mani_c
manics103919933manics
manilas93915873manilas
manilla93012473manilla
manille92613273manille
manioc103914823manioc
maniple11249653maniple
manito8518693manito
manitu8315823manitu
manlily1238743manlily
manly105022943ma_nly
mantle84420923mantle
map77255113ma___p
maple95521143ma_ple
maquila1844703maquila
marble104219103marble
marbly134111933marbly
margin94016843margi_n
margins103815193margins
maria75032883mari_a
marina84623413marina
marine84230403marine
marish114319053marish
markup1436903markup
marl66341613ma_rl_
marlin84220903marlin
marls75535163ma_rls
marly106925613ma_rly
masala8311813masala
matier84321523matier
matilda1044983matilda
matin75132853mati_n
mating94832913mating
matins84527783matins
maul64830713ma_ul_
mauls76524953ma_uls
mavie104722563mavi_e
mavies114923193mavies
mavin105722953mavi_n
mavins115119183mavins
mavis105622723mavi_s
mawing124020803mawing
maxi137023553maxi__
maxilla16248193maxilla
maxim165216003maxi_m
maxima17568633maxima
maxims17399673maxims
maxing164817073maxing
maxis145721563maxi_s
maxixe1435223maxixe
mayfly1734403mayfly
mayhap1635233mayhap
maying124421153maying
maypop1565143maypop
mazier175013063mazier
mazing184418973mazing
meatily12311093meatily
megilla1036273megilla
megilphs1641613megilphs
miggle104012113miggle
mil55752113m__il_
mild75330853m__ild
mile66352573m__ile
milk105028473m__ilk
mill66541483m__ill
milo65536103m__ilo
milpa92111403m__ilpa
mils66045333m__ils
milt65455813m__ilt
mobile103613543mobile
mogul8310213mogul_
moguls948553moguls
moil65534093m_oil_
moils76125753m_oils
motile83818343motile
muggily1435103muggily
nail45838653na_il_
nails55730403na_ils
nargile847653nargile
paging104020403paging
pail66141833pa_il_
pails75833063pa_ils
palp85828573pa__lp
racily11715173racily
raggle83712883raggle
ragi56032283ragi__
raging85126433raging
ragis66325603ragi_s
ragtop936683ragtop
rail46147763ra_il_
rails55937403ra_ils
regild8149773regild
regilt71217493regilt
sagely102811383sagely
sagier73717163sagier
sail45447163sa_il_
sails55738103sa_ils
salp64534093sa__lp
sigil63515503sigil_
sigils73912363sigils
stagily1139053stagily
tail45443653ta_il_
tails55634193ta_ils
unagile838283unagile
vagal94613633vagal_
vagi86719363vagi__
vagina102710933vagina
vail75432553va_il_
vails85825933va_ils
vakil1259793vakil_
vakils1337593vakils
vigil94313003vigil_
vigils104210193vigils
waggle113612303waggle
waggly14347293waggly
waging114318383waging
wail75238823wa_il_
wails86631483wa_ils
warily122915093warily
wavily15219483wavily
waxily19218413waxily
yagi86922243yagi__
yagis95416573yagi_s
zanily18310183zanily

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.1261418182.5
2DLD Change Limit1127162856.70316815.8
3Display Results2852850.0933064.5
 (SQL Overall)1786912856.92225814.9
 
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.