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

43 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
agrochemicals2310283(None) 
agrichemicals2382031agrichemicals
agrochemical2283891agrochemical_
agrichemical22102782agrichemical_
biochemicals2363223_biochemicals
geochemical2154523_geochemical_
neurochemicals2372833neurochemicals
petrochemicals2572733petrochemicals
alchemical1954424a__lchemical_
biochemical2254354_biochemical_
biogeochemicals2781804biogeochemicals
chemicals1845604____chemicals
cytochemical2364144cytochemical_
geochemically2654844_geochemically
neurochemical2264084neurochemical_
nonchemicals21103624_nonchemicals
petrochemical2463914petrochemical_
radiochemical2362774radiochemical_
aeromedical1653375aero_medical_
aeronomical1555335aero_nomical_
agronomically2184705agro_nomically
alchemically2454785a__lchemically
anticlericals1763155anticlericals
archaical1645905a_r_ch_aical_
archrivals1852365a_r_ch_rivals
arsenicals1252975a_r__senicals
biochemically2754385_biochemically
biogeochemical2672225biogeochemical_
chemical1748395____chemical_
cosmochemical2362765cosmochemical_
geochemists1954295_geochemi_sts
graphemically2653755_graphemically
graphemics2052585_graphemic__s
gremials1136135_gr___emi_als
histochemical2563125histochemical_
nonchemical2075615_nonchemical_
photochemical27124985photochemical_
phytochemical30164255phytochemical_
prophetical2055845_prophetical_
psychochemicals3182445psychochemicals
radiochemically2872355radiochemically
stereochemical2372515stereochemical_
thermochemical2873085thermochemical_

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.423422437.4
2DLD Change Limit124790439.17313604.1
3Display Results43430.0133307.7
 (SQL Overall)178691439.60918596.2
 
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.