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

44 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
opalescence175375(None) 
opalescences1853091opalescences
coalescence1455092coalescence
opalescent1454742opalescen_t
adolescence1653853adolescence
coalescences1554213coalescences
convalescence19132493convalescence
evanescence1853633evanescence
incalescence15113973incalescence
obsolescence1862613obsolescence
opalesce1243513opales___ce
opalesced1442793opalesce__d
opalescently19161913opalescently
opalesces1343993opalesce__s
opalescing1542523opalescin_g
paleocene1345003_paleocen_e
pearlescence1863193pearlescence
pubescence1854763_pubescence
adolescences1753614adolescences
calescent13118224_calescen_t
candescence1554804candescence
coalescent1496654coalescen_t
concrescence1484504concrescence
convalescences20122264convalescences
evanescences1953234evanescences
excrescence2153734excrescence
florescence1884414florescence
incalescences16113504incalescences
iridescence1693694iridescence
maleficence2052354_maleficence
nascence1256184_na__scence
obsolescences1962314obsolescences
opulence1245154opul___ence
paleogene1245234_paleogen_e
pearlescences1962854pearlescences
prescience16157294_p_rescience
presence122213514_p_res_ence
pubescences1954284_pubescences
putrescence17114274putrescence
quiescence2354434_quiescence
senescence14136074_senescence
tumescence1654564_tumescence
turgescence1653074turgescence
virescence17134864_virescence

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.403443402.0
2DLD Change Limit148819449.28316031.3
3Display Results44440.0301466.7
 (SQL Overall)178691449.71618391.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.