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

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

46 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
phosphorylating2972181phosphorylating_
phosphorylation2882363phosphorylati_on
phosphorylative3172243phosphorylati_ve
phosphorylate26153204phosphorylat___e
phosphorylated28132684phosphorylat__ed
phosphorylates27143064phosphorylat__es
phosphocreatine2781835phosphocreatin_e
phosphorescing2781905phosphor_escing_
phosphorolytic2972165phosphorolyti__c
phosphorylase26132975phosphoryla___se
phosphorylases27132705phosphoryla__ses
dephosphorylate2981626dephosphorylat___e
phosphoritic2463976phosphor__iti__c
phosphorolysis2772116phosphorolysi__s
phosphoryl2353786phosphoryl______
phosphoryls2453276phosphoryl_____s
sporulating1445116___sp_orulating_
camphorating2252567_camphor__ating_
hydroxylating3163247_h_ydroxylating_
phenolating1745257ph__eno__lating_
phosphatic2256737phosph____ati__c
phosphatide2264477phosph____ati_de
phosphatides2353777phosph____atides
phosphatidic2572027phosph____atidic
phosphatidyl2661777phosph____atidyl
phosphatization3462377phosphatizati_on
phosphatize3054497phosph____ati_ze
phosphatized3263567phosph____atized
phosphatizes3154097phosph____atizes
phosphatizing3372727phosph__atizing_
phosphaturia2291927phosph____aturia
phospholipid2262377phospho__l__ipid
phospholipids2371787phospho__lipi_ds
phosphoprotein23172307phosphoprotein__
phosphoproteins24192127phosphoprotein_s
phosphorescence2981507phosphor_escence
phosphorescent2671927phosphor_escen_t
phosphori1966297phosphor____i___
phosphoric2266447phosphor____i__c
phosphorite2155387phosphor____i_te
phosphorites2254697phosphor____ites
phosphorolyses2772057phosphorol__yses
photostating18135847pho__to_stating_
populating1547667p_o_p___ulating_
postulating1447507p_os___tulating_
prostrating1449397pros__tr__ating_

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 Filter178691950240.360496363.9
2DLD Change Limit95024467.95311948.2
3Display Results46460.0461000.0
 (SQL Overall)178691468.35921377.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.