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

297 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
mopoke143663(None) 
mopokes1536691mopokes
cowpoke1835102cowpoke
moke106234222m__oke
moose76327192mo_ose
mope86838042mop__e
morose85116242morose
poke105335362__poke
spoke114818662_spoke
appose10411993appose
awoke124912003_awoke
bespoke15468113bespoke
bloke114316633_bloke
book106836333bo_ok_
booked135319503bo_oked
booker124719193bo_oker
bookie123516003bo_okie
books115729713bo_oks
booze164718913bo_oze
broke116019783_broke
capote10315733capote
choke145118023_choke
coke107038383__coke
colone85425003colone
comake144413423comake
comose105016843comose
compone136517193compone
compose135716663compose
compote135616463compote
convoke16207173convoke
cooee74531023co_oee
cook107236933co_ok_
cooked135921363co_oked
cooker124722453co_oker
cookey155414333co_okey
cookie123716043co_okie
cooks115429143co_oks
cooky145321363co_oky
cope86847383cop__e
copout10418773copout
copse95623923cop_se
cowpokes1944573cowpokes
coyote11411783coyote
depone93616553depone
depose94215763depose
dipole91112853dipole
dope76038893dop__e
epode85114093_epode
evoke12478853_evoke
expose1549523expose
gook96429603go_ok_
gooks105422883go_oks
gooky135818033go_oky
goose65925903go_ose
gopik1257533gopik_
hoke115935933__hoke
hook116133283ho_ok_
hooka125513903ho_oka
hooked145320553ho_oked
hooker134820173ho_oker
hookey164713933ho_okey
hooks125027123ho_oks
hooky155220263ho_oky
hoopoe11911233hoopoe
hope96639673hop__e
hopple132910483hopple
impone103011863impone
impose103113053impose
invoke1336213invoke
ionone6313443ionone
jocose1537103jocose
joke155926163__joke
kapok10448783kapok_
kapoks11347263kapoks
kook75822603ko_ok_
kookie9389833ko_okie
kooks85217263ko_oks
kooky114412873ko_oky
kopek1037813kopek_
kopeks1134603kopeks
kopje1835273kop_je
koppie14277873koppie
looie55624243lo_oie
look87333473lo_ok_
looked114717073lo_oked
looker104816953lo_oker
looks95124863lo_oks
loose56627683lo_ose
lope65941923lop__e
mahoe10315573maho_e
make105537883m__ake
maple95521143map_le
maplike15299273maplike
maypole1446383maypole
metope10611123metope
mike105535293m__ike
minke115421763m_inke
misspoke1645413misspoke
misyoke1635823misyoke
mobile103613543mobile
mock126429443mo_ck_
mocked154716613mo_cked
mocker143315443mo_cker
mocks135023823mo_cks
mode75840303m__ode
module93011033module
moggie103210103moggie
moidore1056153moidore
moire71017323mo_ire
mojo136917223mojo__
mojoes15399523mojoes
mojos145314463mojo_s
mokes114631033m__okes
mole66251833m__ole
moline84422033moline
mollie83517103mollie
moloch1356483moloch
mome85239353m__ome
monde85723143mo_nde
mongoe94214983mongoe
monie75631653mo_nie
moniker1338673moniker
monk105928513mo_nk_
monkey153710593mo_nkey
monks116123393mo_nks
mono66036713mono__
monocle1139663monocle
monody1238243monody
monokine1448483monokine
monomer11311893monomer
monopode1347643monopode
monopole1249283monopole
monos75930863mono_s
monte75829773mo_nte
moo58460513mo_o__
mooch125313613mo_och
mood76332063mo_o_d
moods85224623mo_ods
moody115017493mo_ody
mooed85123983mo_oed
mool67533863mo_o_l
moola75117033mo_ola
mooley11311633mo_oley
mools76027173mo_ols
moon67140813mo_o_n
mooned94216643mo_oned
mooner85317833mo_oner
moons75331003mo_ons
moony104818273mo_ony
moor66628553mo_o_r
moored93814173mo_ored
moors74923143mo_ors
moory105115793mo_ory
moos66051303mo_o_s
moot67653623mo_o_t
mooted94120373mo_oted
mooter83921093mo_oter
moots75831663mo_ots
mop76950823mop___
moped105424733mop_ed
mopeds11499663mopeds
moper94925923mop_er
mopers104220373mopers
mopery135210973mopery
mopes95134983mop_es
mopey124821823mop_ey
mopier103914783mopier
moping114017103moping
mopish134311593mopish
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
mops85940133mop__s
mopy115721973mop__y
morae75831193mo_rae
morale85220553morale
more67154523m__ore
morgue938113morgue
moron76925423moro_n
morons84919543morons
morse76032703mo_rse
mosk105622443mo_sk_
mosks116117003mo_sks
mosque17287163mosque
moste75925083mo_ste
mote67048083m__ote
motile83818343motile
motive113112143motive
motor75317293moto_r
motored1039933motored
motors84616593motors
motte75526973mo_tte
mottle84116053mottle
moue65835573m__oue
mouse77133003mo_use
mousse84813033mousse
move96630723m__ove
movie105319133mo_vie
moxie144018123mo_xie
mozo157719743mozo__
mozos165516333mozo_s
mucose10149313mucose
muspike1536043muspike
myope124010973m_yope
myosote1245853myosote
myotome1445483myotome
nodose738883nodose
nook85728493no_ok_
nookie103712433no_okie
nooks95420393no_oks
nooky124814813no_oky
noose55624063no_ose
nope65934193nop__e
oboe66822943_obo_e
obole75917143_obole
oke75839483___oke
oospore939013oospore
ooze136420603_o_oze
ope56845243_op__e
opine77422463_opine
oppose1039193oppose
ozone14310613_ozone
peke105926203__peke
pike106335213__pike
poked125425393__poked
poker115122883__poker
pokes116133013__pokes
pokey145318973__pokey
poky135922153__poky
pole65951303__pole
pome85636693__pome
pone65747533__pone
poove104514303po_ove
pope85535613__pope
popover1495843popover
popple92710983popple
popsie103013053popsie
pore66451263__pore
porose84818743porose
pose66441733__pose
posole8314223posole
pozole1758913pozole
propone112716303propone
propose112714843propose
provoke1676123provoke
puke105025463__puke
repose84121413repose
respoke134311283respoke
revoke135216243revoke
rewoke1339521213rewoke
rook85532033ro_ok_
rooked114918143ro_oked
rookie103613263ro_okie
rooks95325043ro_oks
rooky126117623ro_oky
roose56127093ro_ose
rope65542913rop__e
sapote8314353sapote
slowpoke1742353slowpoke
smoke115015823_smoke
soke85436263__soke
sook84933393so_ok_
sooks94425453so_oks
sopite84917713sopite
sopor74016493sopo_r
sopors85215193sopors
spake114322743_spake
spike114922843_spike
spode84617703_spode
spoked134413893_spoked
spoken124610003_spoken
spokes124417213_spokes
spook115416043spook_
spooked144510473spooked
spooks124312933spooks
spooky15418093spooky
spore75428593_spore
stoke94922513_stoke
stroke105116173stroke
toke86738493__toke
took86531073to_ok_
tope65946383top__e
topee76029953top_ee
tophe106718973top_he
topo66932403topo__
topoi76018353topo_i
topos75726393topo_s
topple104411323topple
torose64317693torose
troke94821053_troke
unspoke1336573unspoke
unyoke1367293unyoke
woke115527963__woke
yapok14468153yapok_
yapoks15346783yapoks
yoke115626393__yoke
zooks184716943zo_oks

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.1561145455.1
2DLD Change Limit1127162976.17318259.5
3Display Results2972970.0763907.9
 (SQL Overall)1786912976.40527898.7
 
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.