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

76 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
chromospheres256293(None) 
chromosphere2463201chromosphere_
chromophores2454232chromo_phores
chromospheric2762642chromospheric
chromomeres20104293chromo__meres
chromophore2354153chromo_phore_
photospheres2255803ph_otospheres
thermospheres2363353thermospheres
tropospheres1953453_tropospheres
atmospheres1853094__atmospheres
chromatophores2672004chromatophores
chromomere1984354chromo__mere_
chromophobe2553364chromo_phobe_
chromophoric2663374chromo_phoric
chromosomes2054264chromos__omes
heliospheres2052794_heliospheres
hemispheres2153364_h_emispheres
hydrospheres2453394_hydrospheres
ionospheres1654024__ionospheres
noospheres1545144__no_ospheres
oospheres1456634___o_ospheres
ozonospheres2662274_ozonospheres
photosphere2155924ph_otosphere_
rhizospheres2962414rh_izospheres
stratospheres1862374stratospheres
thermosphere2263534thermosphere_
troposphere1853594_troposphere_
atmosphere1752895__atmosphere_
atmosphered1952465__atmosphered
biospheres1765145___biospheres
carpophores2054125car_po_phores
carpospores1763125car_posp_ores
chirographers2494695chirographer_s
chloroprenes1973235chloro_prenes
chompers17369595ch_om__p_er_s
choosers134810875ch_o_os__er_s
chorographers24106125chorographer_s
chromatophore2572135chromatophore_
chromocenters2261915chromocenter_s
chromogens1844635chromo__ge_ns
chromomeric2254295chromo__meric
chromophil2254485chromo_ph__il
chromoplasts2183235chromo_plasts
chromosome1954295chromos__ome_
chronologers1852485chronologer_s
chronometers1954035chronometer_s
chrysophytes2892735chryso_phytes
clomiphenes2051845c_lom_iphenes
comperes143217975c__om__p_eres
crosspieces1752445c_ro_sspieces
ecospheres1795135___ecospheres
exospheres2294425___exospheres
heliosphere1952935_heliosphere_
hemisphere2053515_h_emisphere_
homophiles2048225_h_omo_philes
homophobes2246565_h_omo_phobes
homophones2048385_h_omo_phones
homosexes2144985_h_omos__exes
homospories1855215_h_omospories
hydrosphere2353405_hydrosphere_
ionosphere1553975__ionosphere_
lithospheres2072845_lithospheres
mesospheres1853695__mesospheres
microspheres2154925_microspheres
noosphere1444775__no_osphere_
oosphere1355995___o_osphere_
ozonosphere2562155_ozonosphere_
phosphenes2076555ph___osphenes
phosphores2078425ph___osphores
photophores2159105ph_oto_phores
photospheric2455135ph_otospheric
pyromorphites2562765pyromorphites
rhizosphere2862435rh_izosphere_
stratosphere1762405stratosphere_
thermospheric2562965thermospheric
tropospheric2162965_tropospheric

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.1401276364.3
2DLD Change Limit124790769.36013332.3
3Display Results76760.0461652.2
 (SQL Overall)178691769.54618718.9
 
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.