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

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

65 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
metaphrases185394(None) 
metaphases1745051metaph_ases
metaphrase1753531metaphrase_
metaphase1644952metaph_ase_
antiphrases1654743antiphrases
metaplasms1654263metap_lasms
metastases1244543meta_stases
metatheses1544473metath_eses
metathoraces1973193metathoraces
metathoraxes2462683metathoraxes
misphrases1745083m_isphrases
paraphrases18153803paraphrases
periphrases1853583periphrases
rephrases1447413re__phrases
anaphases1446524_anaph_ases
antiphrasis1655384antiphrasis
apyrases1337244___apyrases
catachreses1872514catachreses
cataphoreses1952104cataphoreses
catchphrases24111254catchphrases
diaphorases1773354_diaphorases
emphases1568354_e_mph_ases
euphrasies1543844_e_uphrasies
evaporates1545464_evaporates
madrases112610004m__a_drases
megaparsec1751744megapar_sec
megaparsecs1851214megapar_secs
megaphones1844684megaph_ones
melaphyres2052874melaph_yres
metageneses14125194metageneses
metalheads1652794metalhea_ds
metalises11315074meta__lises
metalwares1543654meta_lwares
metameres1347454metamer__es
metamerisms1453904metamerisms
metanalyses1653294metanalyses
metaphors1645684metaph__ors
metaphysic2253974metaph_ysic
metaphysics2353114metaphysics
metaplasia1454384metap_lasia
metaplasias1553704metap_lasias
metaplasm1544794metap_las_m
metastasis1254244meta_stasis
metatarsals1351704metatarsals
metatarsus1252324metatar_sus
metathesis1544154metath_esis
meterages1248184met__erages
metestruses1352374metestruses
methanes133812164met__h_anes
methylases1844264met_hylases
misphrase1644574m_isphrase_
misphrased1843864m_isphrased
nephroses1446304ne__phroses
paraphrase1773534paraphrase_
paraphrased1972494paraphrased
paraphraser1862214paraphraser
paraphrasers1971464paraphrasers
periphrasis1853164periphrasis
phrases12711464____phrases
reappraises1553094re_appraises
reemphases1743794reemph_ases
rephrase1346734re__phrase_
rephrased1555284re__phrased
taphouses1446554__taphouses
telophases1545914teloph_ases

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit148819658.97016590.7
3Display Results65650.0302166.7
 (SQL Overall)178691659.17019486.5
 
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.