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

39 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
dichromatism226376(None) 
dichromatisms2362621dichromatisms
achromatism2055332_achromatism
dichromates1956072dichromates_
dichromatic2165742dichromati_c
dichromats1855072dichromat_s_
trichromatism2262752trichromatism
achromatisms2153953_achromatisms
bichromates2054693bichromates_
dichroism1744283dichro___ism
dichromat1756453dichromat___
dichromate1856033dichromat__e
dicrotism1446073dic_ro__tism
trichromatisms2362053trichromatisms
achromatic1949024_achromati_c
achromatize2755434_achromatize
achromats1647634_achromat_s_
bichromate1954614bichromat__e
bichromated2153504bichromat_ed
chromates16313114__chromates_
chromatic18412344__chromati_c
chromaticism2354124__chromaticism
chromatics1948684__chromatics
chromatid17410914__chromati_d
chromatids1847174__chromatids
chromatin16410754__chromati_n
chromatins1749124__chromatins
dichroisms1854234dichro___isms
dichroites1645144dichro_ites_
dichromic1945044dichrom__i_c
dicrotisms1545154dic_ro__tisms
diplomatist1654114di_plomatist
euchromatic2054834euchromati_c
euchromatin1853744euchromati_n
euchromatins1963024euchromatins
monochromatism2272224monochromatism
schematism1944714_sch_ematism
trichromatic2184274trichromati_c
trichromats1884314trichromat_s_

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 Filter1786911247900.390458182.1
2DLD Change Limit124790399.14013653.2
3Display Results39390.0162437.5
 (SQL Overall)178691399.54618718.9
 
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.