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

70 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
protoplasts156605(None) 
protoplasms1764871protoplasms
protoplast1467781protoplast_
protoplanets1663662protoplanets
protoplasm1665322protoplas_m
chromoplasts2183243chromoplasts
cytoplasts1755323_cytoplasts
otoplasty1454183__otoplasty
photophases2157943photophases
photoplays2054723photopla_ys
protoplanet1566583protoplanet
protoplasmic2063593protoplasmic
tonoplasts1255193_tonoplasts
amyloplasts1852844amyloplasts
chloroplasts1963384chloroplasts
chromoplast2084494chromoplast_
cytoplasms1954514_cytoplasms
cytoplast1646664_cytoplast_
deutoplasms1652754deutoplasms
ectoblasts1454034_ectoblasts
ectoplasms1654434_ectoplasms
entoblasts1254754_entoblasts
iconoclasts1552664iconoclasts
keratoplasty2161974keratoplasty
kinetoplasts1861744kinetoplasts
leucoplasts1552764leucoplasts
odontoblasts1561794odontoblasts
otoplasties1353554__otoplasties
periplasts1475154p_eriplasts
photoflash2153534photoflas_h
photoflashes2353074photoflashes
photolyses1846654photo_lyses
photolysis1846704photo_lysis
photomasks2153744photo_masks
photophase2057434photophas_e
photopias16410144photopia__s
photoplay1954754photopla__y
photostats1547064photosta_ts
phragmoplasts2371054phragmoplasts
piroplasms1654424p_iroplasms
prologists13311174prolo_gists
propellants15153574propellants
prophases16411064pr__ophases
proplastid1556754pr__oplastid
proplastids1654334pr__oplastids
propolises1448854propo_lises
prosodists1345944proso_dists
protases102115034prot___ases
protasis102411974prot___asis
proteases112110834prot__eases
protectants1554364protectants
proteinases1344524proteinases
proteolyses1653664proteolyses
proteolysis1653774proteolysis
protestants1354554protestants
protests10310494prot___ests
protists10313364prot___ists
protonate11412574proto_na_te
protonates12411694proto_nates
protophloems2162024protophloems
protopods1446994protop__ods
protostars1246854protosta_rs
protozoans2155534protozoa_ns
protracts1347024prot__racts
provosts1336084provo___sts
spheroplasts19152274spheroplasts
statoblasts1353164statoblasts
tonoplast1146914_tonoplast_
topmasts1244974___topmasts
trophoblasts1962844trophoblasts

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.420425454.8
2DLD Change Limit148819708.92316678.1
3Display Results70700.0332121.2
 (SQL Overall)178691709.37619058.3
 
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.