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

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

30 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
chromatophores267200(None) 
chromatophore2572131chromatophore_
chromophores2454242chrom__ophores
chromophore2354153chrom__ophore_
chromatolyses2361944chromato_lyses
chromophobe2553364chrom__ophobe_
chromophoric2663384chrom__ophoric
chromospheres2562934chrom_ospheres
photophores2159104ph_o__tophores
pneumatophores2371484pneumatophores
spermatophores23152324spermatophores
carpophores2054125car___pophores
chromates16313115chromat_____es
chromaticities2362845chromaticities
chromatogram2283205chromato__gram
chromatograms2392945chromato_grams
chromatographs27134375chromatographs
chromatolysis2362245chromato_lysis
chromomeres20104295chrom__o_meres
chromosomes2054275chrom__o_somes
chromosphere2463205chrom_osphere_
dermatophytes2462385der_matophytes
gametophores2062495__gametophores
homophobes2246565_h_om__ophobes
homophones2048385_h_om__ophones
photophore2058635ph_o__tophore_
phreatophytes2662075phr_eatophytes
pneumatophore2271405pneumatophore_
spermatophore22152385spermatophore_
trochophores2263085_tro_chophores

Search took 8 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.360496363.9
2DLD Change Limit95024307.12313340.4
3Display Results30300.033909.1
 (SQL Overall)178691307.51623774.7
 
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.