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

48 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
phosphorescence2981501phosphorescence_
phosphorescent2671923phosphorescen__t
phosphoresce2462714phosphores___ce_
phosphoresced2662104phosphores___ced
phosphoresces2562514phosphores___ces
phosphorescing2781904phosphorescin__g
phosphocreatine2781836phosphocreatin_e_
phosphores2078426phosphores______
phosphoruses2253846phosphorus____es
arborescence1862857___arborescence_
arborescences1962467___arborescences
concrescence1484507_co__ncrescence_
concrescences15104347_co__ncrescences
efflorescence2362077__efflorescence_
efflorescences24101787__efflorescences
florescence1884417____florescence_
florescences1993887____florescences
fluorescence19103517___fluorescence_
fluorescences2083237___fluorescences
inflorescence2062267__inflorescence_
inflorescences2171997__inflorescences
obsolescence1862617__o_bsolescence_
obsolescences1962317__o_bsolescences
opalescence1753757__o_p_alescence_
opalescences1853097__o_p_alescences
phosphene1996247phosph_____en_e_
phosphenes2076557phosph_____en_es
phosphore1967897phosphor______e_
phosphoric2266447phosphor____ic__
phosphorite2155387phosphor____ite_
phosphorites2254697phosphor____ites
phosphoritic2463977phosphor__itic__
phosphorolyses2772057phosphor__olyses
phosphorolytic2972167phosphorolytic__
phosphors1976547phosphor_s______
phosphorus2084827phosphorus______
phosphorylase26132977phosphor__ylase_
phosphorylases27132707phosphor__ylases
phosphorylate26153207phosphor__ylate_
phosphorylated28132687phosphor__ylated
phosphorylates27143067phosphor__ylates
phosphorylative3172247phosphorylative_
preadolescence2192017p_readolescence_
preadolescences2291847p_readolescences
prepubescence23112147p_rep_ubescence_
prepubescences24111867p_rep_ubescences
putrescence17114277____putrescence_
putrescences18113887____putrescences

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 Filter178691950240.373479064.3
2DLD Change Limit95024488.81310782.3
3Display Results48480.0301600.0
 (SQL Overall)178691489.21619389.2
 
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.