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

102 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
morphin143900(None) 
morphia1447481morphia
morphic1648691morphic
morphine1548701morphine
morphing1637551morphing
morphins1538651morphins
dolphin1345532dolphin
morph121712512morph__
morphed1537132morphed
morphias1546842morphias
morphines1648232morphines
morphings1744682morphings
morphinic1844682morphinic
morpho13158442morph_o
morphos14159082morphos
morphs13149432morph_s
orphan1137732_orphan
orphic1368322_orphic
orpin73415532_orp_in
amorphism1845573amorphism
arshin9312173_arshin
cochin131313203co_chin
complin13312073complin
cortin82423153cor_tin
dauphin1344383dauphin
dimorphic1945193dimorphic
dolphins1445653dolphins
dormin9312313dor_min
dynorphin1853013dynorphin
endorphin1555153endorphin
gorhen1038893gor_hen
harpin113614383harp_in
hordein1138753hordein
marchen143312073marchen
marching164312193marching
margin94016843mar_gin
marlin84220903mar_lin
martin84122523mar_tin
merlin83916683mer_lin
mirin75023153mir__in
mooching16259063mooching
moorhen1236023moorhen
moping114017103mo_p_ing
mopping143411473mo_pping
moraine9314573mor_aine
morbid112511463mor_bid
moreen8313343mor_een
morgan9311373mor_gan
morgen9312203mor_gen
morion86217733mor_ion
morn66237563mor___n
morning103215043mor_ning
moron76925423mor__on
moronic11311863moronic
morphactin1952083morphactin
morpheme1744053morpheme
morphemic2044283morphemic
morphinism1953403morphinism
morphogen1753793morphogen
morphosis1646443morphosis
morrion959003morrion
morris83814733mor_ris
mortmain1244573mortmain
moshing134214883mo_shing
mouching163110583mouching
moulin8313283mo_ulin
mouthing142810243mouthing
murein8311763mur_ein
murphies1536453murphies
murphy1654343murph_y
murrain937763murrain
murrhine1344313murrhine
myrrhic1743763myrrhic
northing12199063northing
opsin7613473_o_psin
orcein838183_orcein
orchid1289573_orchid
orchil1158653_orchil
orchis11710773_orchis
orcin72716573_or_cin
ordain7810403_ordain
origin7311033_origin
orphans1237773_orphans
orphism1446183_orphism
orpine83914483_orp_ine
orpins83614163_orp_ins
phosphin1865543phosphin
poplin10413483po_plin
porphyrin19134953porphyrin
seraphin1345953seraphin
sorption1037513sorption
syrphian1643453syrphian
syrphid1646103syrphid
tophi105215303to_phi_
torching142510083torching
torchon1237363torchon
torpid9310913torp_id
trophic14311033trophic
tropin83316753trop_in
urchin1138743_urchin
worship1547833worship
worthing15178053worthing

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271025.98622390.1
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.17228951.9
 
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.