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

378 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
magpie113909(None) 
magpies12310361magpies
aggie73415012_aggie
baggie102912192baggie
bagpipe1453112bagpipe
mage75739122mag__e
magi76329522mag_i_
magic105818652mag_ic
mamie95826002ma_mie
mammie94313782mammie
maple95521142ma_ple
mashie11315932mashie
mavie104722562ma_vie
moggie103210102moggie
nappie104112262nappie
tawpie11339142tawpie
aerie54634603_aerie
again65218113_again
agapae9388043_agapae
agape85614843_agape
agate66525143_agate
agave95314033_agave
agaze156113663_agaze
age47154333_ag__e
agee56241493_ag_ee
agene65621583_agene
aggies83515513_aggies
agile65122263_agile
agin56132713_ag_in
agio57828453_ag_io
aglee65728493_aglee
agnize16329563_agnize
agone65924553_agone
agree65226033_agree
agria65517143_agria
ague55725923_ag_ue
alkie95520033_alkie
alpine84417373_alpine
amie66339843_a_mie
ample94720303_ample
ape57251183_a_p_e
apple94517673_apple
apse67725383_a_pse
aspic95114733_aspic
aspire8612123_aspire
aspis74618143_aspis
baddie104114033baddie
baggier113611643baggier
baggies113814853baggies
baglike14338943baglike
bagnio937523bagnio
bagpiped1642063bagpiped
bagpiper1542393bagpiper
bagpipes1543403bagpipes
bagwig1343083bagwig
bailie83818363bailie
barbie105018353barbie
barmie103816393barmie
bawtie113812143bawtie
biggie103810933biggie
bogie89524103bog_ie
buppie12288733buppie
cabbie122913343cabbie
caddie104316443caddie
cage75339063cag__e
cagier93715933cag_ier
cammie124615293cammie
campi116217783campi_
campier133313273campier
cannie83819363cannie
cape87242783ca_p_e
capiz18514563ca_piz
carnie84421093carnie
carpi94319393carpi_
cattie85221013cattie
cavie104621593ca_vie
chappie16298653chappie
cowpie133511513cowpie
crappie13298983crappie
daggle93711903daggle
dapple1138853dapple
darkie113714013darkie
dassie74615573dassie
dautie72914693dautie
dawtie103011093dawtie
doggie93910893doggie
dogie75222793dog_ie
eagle64219483eag_le
eagre64315323eag_re
faerie93514683faerie
faggier12309843faggier
fagin9216573fag_in
falsie93513853falsie
farcie114816473farcie
fogie96719003fog_ie
gage65936103gag__e
gaggle93412623gaggle
gape75134513ga_p_e
gappier12369843gappier
garpike1435093garpike
gawsie1038463gawsie
gie47149543__g_ie
hackie154615623hackie
haggis11209513haggis
haggle113511983haggle
hagride1237553hagride
hankie133915713hankie
happier143312033happier
harpies123818313harpies
harpin113614383harpin
hatpin112610603hatpin
hawkie163810093hawkie
hempie132410563hempie
hippie132811243hippie
hoagie102310003hoag_ie
hogtie102711763hogtie
image81411283imag__e
imagine1037873imagine
jaggier16339183jaggier
jaggies163311083jaggies
jape134923423ja_p_e
kelpie12308613kelpie
kewpie15465413kewpie
koppie14277873koppie
laddie83713173laddie
lagune7158633lagune
lambie103213663lambie
lapin75222923la_pin
lapis76223153la_pis
lapse74917683la_pse
lassie64917743lassie
loggie84011993loggie
luggie8318903luggie
mabe85733343ma__be
macchie1647193macchie
mace87345783ma__ce
mache125925303ma_che
machine14313493machine
mackle143716433mackle
macle96127003ma_cle
macule104115273macule
madame1139853madame
made75440233ma__de
madre85720173ma_dre
mae57659103ma___e
maffia14327203maffia
mafia104418033ma_fia
mafic125615463ma_fic
maftir1136493maftir
mag67956473mag___
magazine2046553magazine
mages85036023mag_es
maggot10311703maggot
magian9312833magian
magics115311613magics
magilp1137613magilp
maglev1237023maglev
magma104513573mag_ma
magmas115512503magmas
magnate10512703magnate
magnet9320663magnet
magnify1634533magnify
magnum1136733magnum
magot8326393mag_ot
magots9312363magots
mags75444523mag__s
maguey1236833maguey
magus85318753mag_us
mahoe10315573ma_hoe
maid75537633ma__id
maigre9309163maigre
mail65543433ma__il
maile75232213ma_ile
maim85831473ma__im
main65345503ma__in
mair66133763ma__ir
maize164618553ma_ize
make105537883ma__ke
malaise9312673malaise
malate84624553malate
male66052293ma__le
malgre9299303malgre
malic94525653ma_lic
malice104818483malice
maline84529083maline
malkin122913143malkin
mallee84525593mallee
mallei84414633mallei
malmier113611953malmier
maltier93015483maltier
mamies104626243ma_mies
mammae94613213mammae
mammee94417853mammee
mammies104314763mammies
manage93818903manage
manche133515103manche
mane65052013ma__ne
manege94113203manege
mange84930183ma_nge
mangier104114063mangier
mangle93921323mangle
mania75634143ma_nia
manic94629433ma_nic
maniple11249653maniple
manlier92414023manlier
manlike133012783manlike
mannite9312903mannite
manque17259513manque
manse75528223ma_nse
mantic104120903mantic
mantid93820373mantid
mantis83926033mantis
mantle84420923mantle
manure8313653manure
manwise1239183manwise
map77255113ma_p__
maples104819423ma_ples
maplike15299273maplike
mapped134015883mapped
mapper124516093mapper
mapping143413993mapping
maps86141043ma_p_s
maqui16249953maqui_
maquis17249483maquis
marble104219103marble
mare64759323ma__re
marge85328333ma_rge
margin94016843margin
maria75032883ma_ria
marine84230403marine
marlier92614773marlier
marlin84220903marlin
marline93320953marline
marlite92917073marlite
marmite112413993marmite
marque172410503marque
married104715303married
marrier93817523marrier
marries93825283marries
marse76231153ma_rse
martin84122523martin
mashies12318253mashies
masjid16187313masjid
masque17249383masque
masse75125293ma_sse
massier93615223massier
massif11412533massif
massive12289773massive
mastic103119173mastic
mastix152310503mastix
mate65154213ma__te
matier84321523ma_tier
matin75132853ma_tin
matrix1539833matrix
matte75626843ma_tte
mattin84416633mattin
mature8313463mature
maugre9308973maugre
mauve104013273ma_uve
mavies114923193ma_vies
mavin105722953ma_vin
mavis105622723ma_vis
maxi137023553ma_xi_
maxim165216003ma_xim
maxis145721563ma_xis
maxixe1435223maxixe
maybe12311123ma_ybe
maypole1446383maypole
maypop1565143maypop
mayvin1436523mayvin
maze155434973ma__ze
mazier175013063ma_zier
meagre9349323meag_re
mealie82519803mealie
meanie83718393meanie
megrim1178043megrim
meinie82614523meinie
miggle104012113miggle
mislie83219153mislie
moggies113111723moggies
mollie83517103mollie
monie75631653m_onie
mope86838043m_op_e
mopier103914783m_opier
movie105319133m_ovie
moxie144018123m_oxie
muggee103612833muggee
muggier11288943muggier
muskie123412533muskie
muspike1536043muspike
myope124010973myop_e
myopia13318433myopia
myopic15308463myopic
myopies14309713myopies
naggier9309153naggier
nannie63713223nannie
nape65230803na_p_e
nappe96114993na_ppe
nappier114411173nappier
nappies114613393nappies
page76036103pag__e
palpi95414553palpi_
panpipe1034833panpipe
pantie84326473pantie
pappi84810893pappi_
pappier103511593pappier
pappies103214823pappies
pardie96021443pardie
pastie85525523pastie
pattie84020963pattie
pie55457403___pie
piggie103210773piggie
potpie103412423potpie
rage55742353rag__e
ragee65432663rag_ee
raggee84217603raggee
raggies93214733raggies
raggle83712883raggle
ragi56032283rag_i_
ragis66325603rag_is
ragtime1036163ragtime
ramie75027823ra_mie
rampike1536603rampike
ranpike1335933ranpike
rape65041633ra_p_e
raphe104916423ra_phe
rapid86422033ra_pid
rapier84019993ra_pier
rapine85023083ra_pine
rappee103618673rappee
raspier93110633raspier
sage55044593sag__e
saggier92912063saggier
sagier73717163sag_ier
salpae84614273salpae
salpid9510873salpid
saltie63422423saltie
sample104215013sample
sapid84720933sa_pid
sappier113613113sappier
sharpie1238383sharpie
smartie9310163smartie
staggie9138463staggie
swaggie12135783swaggie
taglike12278913taglike
tagline82412453tagline
talkie103914443talkie
tammie104212683tammie
tape64538143ta_p_e
tapir75917063ta_pir
tapis75028863ta_pis
tassie66017023tassie
tattie64817513tattie
taupe7314163taup_e
tawie84819813ta_wie
tawpies12309873tawpies
vagi86719363vag_i_
vagile10310543vagile
vague96513113vag_ue
vampier14308233vampier
vampire14296673vampire
vapid115614283va_pid
veggie1136303veggie
vegie94614513veg_ie
vogie95116663vog_ie
waddie114013323waddie
waffie15338563waffie
wage84834083wag__e
waggle113612303waggle
wallie93216803wallie
waspier12259053waspier
weepie11258793weepie
yabbie13308653yabbie
yagi86922243yag_i_
yagis95416573yag_is
yippie13277843yippie
yuppie13297133yuppie
zappier20458373zappier

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 Limit1127163786.43617513.4
3Display Results3783780.1263000.0
 (SQL Overall)1786913786.68826718.2
 
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.