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

152 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
morphos1415908(None) 
morpho13158441morpho_
morphs13149431morph_s
amorphous1644652amorphous
morph121712512morph__
morphed1537132morphed
morphia1447482morphia
morphias1546842morphias
morphic1648692morphic
morphin1439002morphin
morphins1538652morphins
morphoses1648122morphoses
morphosis1646442morphosis
morros83714672mor_ros
sorghos11327602sorghos
amorphism1845573amorphism
bimorphs1743473bimorph_s
bohos105618253bo__hos
borshts1266543borshts
cohos105921853co__hos
compos124818803comp_os
conchos144313963conchos
corps95927043corp__s
corpses113913803corpses
corpus106015293corp_us
dimorphous1852663dimorphous
dimorphs1644303dimorph_s
dorados938203dorados
dorpers104113173dorpers
dorps85419223dorp__s
gorps85316993gorp__s
honchos15369573honchos
hoopoos1298543hoopoos
horahs126313873horah_s
kolkhos1364013kolkhos
kophs145010933ko_ph_s
machos135217493m_achos
marches143921173marches
markhor1635463markhor
markhors1745393markhors
marplot1149673marplot
marplots1245633marplots
marshes123615373marshes
merches144013763merches
merinos9311983merinos
mhos95517773m___hos
mirths114912993mirth_s
mochas13310663mo_chas
mojos145314463mo__jos
mondos95217333mo_ndos
mongos94318623mo_ngos
monos75930863mo__nos
months113812933month_s
mooches143714453mooches
moos66051303mo___os
mopeds11499663mo_peds
mopers104220373mo_pers
mopes95134983mo_p_es
moppers133412463moppers
moppets13307163moppets
mops85940133mo_p__s
morales93619403morales
morals85324633mor_als
moras76438783mor__as
morass84614503mor_ass
morays114613883mor_ays
moreens939963moreens
morellos10136953morellos
morels84820013mor_els
mores76249643mor__es
morgans10310123morgans
morgens10310463morgens
morgues1038273morgues
morion86217733mor_ion
morions94014643morions
morns75527443mor__ns
moroccos1443813moroccos
moron76925423mor__on
morons84919543mor_ons
morose85116243mor__ose
morpheme1744053morpheme
morphemes1843983morphemes
morphine1548703morphine
morphines1648233morphines
morphing1637553morphing
morphings1744683morphings
morphogen1753793morphogen
morphogens1852943morphogens
morrion959003morrion
morrions1077673morrions
morris83814733mor_ris
morro73216953mor_ro_
morrow113510093mor_row
morrows12318723morrows
mors65950063mor___s
morsels94112653morsels
mortals93914003mortals
mortars93411523mortars
morts75533563mor__ts
morulas959713morulas
moshes115222873mo_shes
moths106021553mo_th_s
mottos84615243mo_ttos
mouches143815963mouches
mouths115214533mouth_s
mozos165516333mo__zos
murphies1536453murphies
murphy1654343murph_y
murrhas12286173murrhas
myrrhs1443603myrrh_s
mythos14398463m_ythos
nonpros937473nonpros
norths96812323north_s
nymphos1744083nymphos
oomphs1344723oomph_s
orchis11710773_orchis
ordos65216203_or_dos
orphan1137733_orphan
orphans1237773_orphans
orphic1368323_orphic
orphism1446183_orphism
orpins83614163_orpins
ortho8312293_ortho_
orzos143311253_or_zos
ouphes113614633_ouphes
ouphs104311273_ouph_s
ponchos143410703ponchos
porches143815673porches
pornos85015253por_nos
pothos114214693po_thos
qophs19507813qo_ph_s
rhos76319063__r_hos
skyphos1963733skyphos
sophs104916023so_ph_s
sorgho10348713sorgho_
sorgos74514663sor_gos
tophes115218423to_phes
tophs105220053to_ph_s
tophus115210363to_phus
topos75726393to_p_os
torahs95115643torah_s
torches123715433torches
torchon1237363torchon
torchons1337503torchons
toreros7311343toreros
toros54336193tor__os
torpedos1143933torpedos
torpids1037373torpids
torpor839193torp_or
torpors939383torpors
torsos64815733tor_sos
worths127812893worth_s

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271526.96619240.2
3Display Results1521520.0463304.3
 (SQL Overall)1786911527.43524033.8
 
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.