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 “morphine” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
morphine154870(None) 
morphin1439001morphin_
morphines1648231morphines
morphing1637551morphing
morphins1538651morphins
moraine9314572mor_aine
morpheme1744052morpheme
morphia1447482morphi_a
morphias1546842morphias
morphic1648692morphi_c
morphings1744682morphings
morphinic1844682morphinic
murrhine1344312murrhine
orpine83914482_orp_ine
amorphism1845573amorphism
apomorphine2053783apomorphine
archine125817053_archine
camphine1738373camphine
compline14313553compline
corvine122113643cor_vine
dauphine1444493dauphine
dolphin1345533dolphin_
dolphins1445653dolphins
earphone1348253earphone
elaphine1346113elaphine
errhine1036593_errhine
machine14313493m_achine
marching164312193marching
marine84230403mar__ine
marline93320953mar_line
moline84422033mo__line
monokine1448483monokine
mooching16259063mooching
moonshine1444563moonshine
moping114017103mo_p_ing
mopping143411473mo_pping
moraines10314363mor_aines
moralise10314913moralise
moralize19313923moralize
morning103215043mor_ning
morph121712513morph___
morphed1537133morph_ed
morphemes1843983morphemes
morphinism1953403morphinism
morpho13158443morph__o
morphogen1753803morphogen
morphos14159083morph_os
morphoses1648123morphoses
morphs13149433morph__s
mortice11711493mor_tice
mortise9713533mor_tise
moshing134214883mo_shing
mouching163110583mouching
mouthing142810243mouthing
murine84220023mur__ine
murphies1536453murphies
murrine9411483mur_rine
nalorphine1553463nalorphine
northing12199063northing
ophite11410563_o_phite
opine77422463_o_p_ine
orphan1137733_orphan_
orphaned1445153_orphaned
orphans1237773_orphans
orphic1368323_orphi_c
orphism1446183_orphism
orpin73415533_orp_in_
orpines94414793_orp_ines
orpins83614163_orp_ins
phosphine19106503phosphine
porcine11312843por_cine
porpoise1248083porpoise
propine113020213prop_ine
sordine82515233sor_dine
soricine10710883soricine
sorptive1346473sorptive
topline92313183to_pline
torching142510083torching
trephine1338933trephine
tropine93116653trop_ine
worthing15178053worthing
zoophile2246453zoophile

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162827.86018595.7
3Display Results82820.0332484.8
 (SQL Overall)178691828.31321495.4
 
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.