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

185 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
morpho1315844(None) 
morph121712511morph_
morphos14159081morphos
morphs13149431morphs
morphed1537132morphed
morphia1447482morphia
morphic1648692morphic
morphin1439002morphin
morro73216952mor_ro
murphy1654342murphy
ortho8312292_ortho
sorgho10348712sorgho
amorino9310253amorino
amoroso946093amoroso
amorphous1644653amorphous
bimorph1643623bimorph_
bimorphs1743473bimorphs
boho96923323bo__ho
borsht11813503borsht
coho97524493co__ho
compo115318573comp_o
concho134414263concho
corps95927043corp_s
corpse104013413corpse
corpus106015293corpus
dimorph1543993dimorph_
dimorphs1644303dimorphs
dorado838813dorado
dorp76028053dorp__
dorper94314573dorper
dorps85419223dorp_s
fordo97218653for_do
foredo10510823foredo
forego1038903forego
forgo94418333for_go
forth116222673forth_
forwhy1834423forwhy
gorp75625903gorp__
gorps85316993gorp_s
honcho14389383honcho
hoopoo1198753hoopoo
horah117922053horah_
horahs126313873horahs
koph135816553ko_ph_
kophs145010933ko_phs
macho126120153m_acho
march125622893march_
markhor1635463markhor
marplot1149673marplot
marsh105320853marsh_
marshy14558333marshy
merch125417963merch_
merino8315093merino
mho86624623m___ho
mirth106418893mirth_
mirths114912993mirths
mocha1249923mo_cha
modulo9256983modulo
mojo136917223mo__jo
molto75619603mo_lto
mondo85721233mo_ndo
mongo810122413mo_ngo
mono66036723mo__no
month104818423month_
months113812933months
moo58460513mo___o
mooch125313613mooch_
mop76950823mo_p__
mope86838043mo_p_e
moped105424733mo_ped
moper94925923mo_per
mopes95134983mo_pes
mopey124821823mo_pey
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
mops85940133mo_p_s
mopy115721973mo_p_y
mor56855003mor___
mora66641273mor__a
morae75831193mor_ae
moral75533433mor_al
morale85220553morale
morals85324643morals
moras76438783mor_as
morass84614503morass
moray105423793mor_ay
morays114613883morays
morbid112511463morbid
more67154523mor__e
moreen8313343moreen
morel75729093mor_el
morello9117793morello
morels84820023morels
mores76249643mor_es
morgan9311373morgan
morgen9312203morgen
morgue938113morgue
morion86217733morion
morn66237563mor__n
morns75527443mor_ns
morocco1343523morocco
moron76925423mor_on
morons84919543morons
morose85116243morose
morpheme1744053morpheme
morphias1546843morphias
morphine1548703morphine
morphing1637553morphing
morphins1538653morphins
morphogen1753803morphogen
morphoses1648123morphoses
morphosis1646443morphosis
morrion959003morrion
morris83814733morris
morros83714673morros
morrow113510093morrow
mors65950063mor__s
morse76032703mor_se
morsel85815893morsel
mort66758833mor__t
mortal84616853mortal
mortar83812043mortar
morts75533563mor_ts
morula8710473morula
mosh95227603mo_sh_
mosso74715183mo_sso
moth96731333mo_th_
moths106021553mo_ths
mothy136214553mo_thy
motto76119513mo_tto
mouch124715803mouch_
mouth105420293mouth_
mouths115214533mouths
mouthy14409063mouthy
mozo157719743mo__zo
mucho125013443m_ucho
murrha11366453murrha
myrrh1337093myrrh_
myrrhs1443603myrrhs
north86018273north_
norths96812323norths
nympho1643583nympho
oho66534383_o__ho
oomph1236973oomph_
oomphs1344723oomphs
ordo54622363_or_do
orphan1137733_orphan
orphic1368323_orphic
orpin73415533_orpin
orzo134516783_or_zo
ouph95618373_ouph_
ouphe104413263_ouphe
ouphs104311273_ouphs
poncho133310123poncho
porch125918623porch_
porno75120653por_no
qoph185911943qo_ph_
qophs19507813qo_phs
rho65924833__r_ho
soph97024203so_ph_
sophs104916023so_phs
sophy136611763so_phy
sorghos11327603sorghos
sorgo64719723sor_go
toph96326873to_ph_
tophe106718973to_phe
tophi105215303to_phi
tophs105220053to_phs
topo66932403to_p_o
torah87125273torah_
torahs95115643torahs
torch107420933torch_
torchon1237363torchon
torchy14549533torchy
torero6313203torero
toro48045683tor__o
torpedo1035053torpedo
torpid9310913torpid
torpor839193torpor
torso56922143tor_so
trophy1438283trophy
worth117120523worth_
worths127812893worths
worthy15598803worthy

Search took 8 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.393454684.5
2DLD Change Limit1127161856.93616250.9
3Display Results1851850.0632936.5
 (SQL Overall)1786911857.39224173.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.