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

53 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
thermospheric256296(None) 
thermosphere2263532thermospher_e
thermospheres2363352thermospheres
chromospheric2762643chromospheric
hemispheric2352873_he_mispheric
thermophilic2463973thermo_philic
asthenospheric2471464asthe_nospheric
atmospheric2052974__atmospheric
exospheric2453544__e_xospheric
hydrospheric2663024_hydrospheric
mesospheric2053314_me_sospheric
photospheric2455134ph_otospheric
thermoduric1962684thermo__duric
thermometric2154454thermo_metric
thermostatic1954344thermos_tatic
tropospheric2162964t_ropospheric
atmospherics2162195__atmospherics
biospheric1954255___biospheric
chromophoric2663385ch_romophoric
chromosphere2463205chromospher_e
chromospheres2562935chromospheres
heliosphere1952935_heliospher_e
heliospheres2052795_heliospheres
hemisphere2053525_he_mispher_e
hemispheres2153365_he_mispheres
hemispherical2561635_he_mispherical
hemophilic2256555_he_mo_philic
hemosiderin1791995_he_mosiderin
ionospheric1853475__ionospheric
lithospheric2262445_lithospheric
phosphoric2266445ph___osphoric
stratospheric2081925stratospheric
subatmospheric258715subatmospheric
theophanic2054295the__o_phanic
theriomorphic2562685theriomorph__ic
thermochemical2873085thermo_chemical
thermochemist2573705thermo_chemist
thermodynamic2682685thermodynamic
thermoelectric23102475thermoelectric
thermographer2464885thermographer__
thermographers2553685thermographer_s
thermographic2655655thermographic
thermomagnetic2472525thermomagnetic
thermometer1865185thermometer__
thermometers1964915thermometer_s
thermophile2154655thermo_ph_ile
thermophiles2254265thermo_philes
thermoplastic2263995thermoplastic
thermoses1447975thermos__e__s
thermoset1449095thermos__e__t
thermosets1564965thermos__e_ts
thermotactic2163475thermo_tactic
thermotropic2154955thermo_tropic

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.406440125.6
2DLD Change Limit124790539.33013375.1
3Display Results53530.0461152.2
 (SQL Overall)178691539.78218267.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.