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

56 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
monochromatisms2371691monochromatisms_
monochromatism2272222monochromatism__
monochromatic2463054monochromati___c
monochromators2371614monochromat_ors_
monochromats2163164monochromat___s_
monochromists2262974monochrom__ists_
achromatisms2153945___achromatisms_
dichromatisms2362615__dichromatisms_
monochromat2064205monochromat_____
monochromator2261855monochromat___or
monochromist2163935monochrom__i__st
trichromatisms2362055_trichromatisms_
achromatism2055326___achromatism__
dichromatism2263766__dichromatism__
hemochromatoses2771286hemochromatoses_
hemochromatosis2781316hemochromatosis_
monochromes2054236monochrom____es_
monochromic2253826monochrom__i___c
photochromisms2872926photochrom__isms_
trichromatism2262756_trichromatism__
achromatizes2854697___achromatizes_
anachronisms1953077_anachro__nisms_
apochromatic2353537_apochromati___c
chromaticism2354127____chromaticism
chromaticisms2463447____chromaticisms_
chromatics1948687____chromati_cs_
chromatids1847177____chromati_ds_
chromatins1749127____chromati_ns_
concretisms1764437con_c_r__etisms_
conservatisms2083537con_ser_vatisms_
euchromatins1963027__euchromati_ns_
isochronisms1962857_isochro__nisms_
manorialisms1664487mano__r_ialisms_
melodramatises19253017melo_dramatises_
melodramatists19232377melo_dramatists_
metachromatic2462797metachromati___c
metasomatisms1661797m__etasomatisms_
monachisms1944107monach_____isms_
monochasia1753957monoch___a__s_ia
monochasium2062117monoch___asium__
monochrome1954207monochro_____m_e
monocracies1755727monoc_r__aci_es_
monocratic1647327monoc_r__ati___c
monocrats1348537monoc_r__at___s_
monodramatic1963127mono_dramati___c
monomorphisms2163197mono__morphisms_
monorchidisms2361657mono__rchidisms_
monotheisms1853507monoth____eisms_
nonaromatics1654227__nonaromati_cs_
panchromatic2354657pan_chromati___c
photochromism2763667photochrom__ism__
pleochroisms2162027pleochro___isms_
pococurantisms22101257pococur_antisms_
polychromatic2762947polychromati___c
schematisms2053997___sch_ematisms_
synchronisms2284257syn_chro__nisms_

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.393454684.5
2DLD Change Limit95024568.00011878.0
3Display Results56560.0461217.4
 (SQL Overall)178691568.43921174.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.