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

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

61 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
dichromatisms236261(None) 
dichromatism2263761dichromatism_
achromatisms2153942_achromatisms
trichromatisms2362052trichromatisms
achromatism2055323_achromatism_
dichroisms1854223dichro___isms
dichromates1956073dichromat__es
dichromatic2165743dichromati__c
dichromats1855073dichromat___s
dicrotisms1545143dic_ro__tisms
trichromatism2262753trichromatism_
achromatizes2854694_achromatizes
bichromates2054694bichromat__es
chromaticisms2463444__chromaticisms
chromatics1948684__chromati_cs
chromatids1847174__chromati_ds
chromatins1749124__chromati_ns
dichroism1744284dichro___ism_
dichromat1756454dichromat____
dichromate1856034dichromat___e
dicrotism1446064dic_ro__tism_
diplomatists1752034di_plomatists
euchromatins1963024euchromati_ns
monochromatisms2371694monochromatisms
schematisms2053994_sch_ematisms
achromatic1949025_achromati__c
achromatize2755435_achromati_ze
achromatized2953755_achromatized
achromats1647625_achromat___s
acrotisms1347495_ac_ro__tisms
automatisms15155475__automatisms
bichromate1954615bichromat___e
bichromated2153505bichromat__ed
chromates16313115__chromat__es
chromatic18412335__chromati__c
chromaticism2354125__chromaticism
chromatid17410915__chromati__d
chromatin16410755__chromati__n
chromatinic2053625__chromatinic
chromiums1844545__chrom__iums
corporatisms18143965__corporatisms
dichogamies2053025dich_ogami_es
dichotomists2093225dich_otomists
dichroites1645145dichro___ites
dichromic1945045dichrom__i__c
diplomatist1654115di_plomatis_t
dogmatisms1643945d___ogmatisms
dramatises1356765d___ramatises
dramatists1365715d___ramatists
euchromatic2054835euchromati__c
euchromatin1853745euchromati__n
metasomatisms1661795metasomatisms
microprisms1955415mic_ro_prisms
microseisms1753905mic_ro_seisms
monochromatism2272225monochromatism_
pictorialisms1984585pictorialisms
rheumatisms1852885__rheumatisms
schematism1944715_sch_ematism_
suprematisms1853395_suprematisms
trichromatic2184275trichromati__c
trichromats1884315trichromat___s

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 Filter1786911247900.390458182.1
2DLD Change Limit124790617.95315690.9
3Display Results61610.0302033.3
 (SQL Overall)178691618.37321341.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.