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

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

46 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
alchemic174525(None) 
alchemical1954422alchemical
alchemies1654832alchemies
alchemist1645922alchemist
alchemize2553302alchemize
alchemy1743112alchem_y
anthemic15410322anthemic
chemic153012092__chemic
ischemic1744672ischemic
sachemic1746082sachemic
academic1544723academic
acetic10314503a_c_etic
achromic1747613a_chromic
acmic11312333a_c__mic
aetheric13410163aetheric
alcaic1039983alc__aic
alchemistic2053503alchemistic
alchemists1744543alchemists
alchemized2752813alchemized
alchemizes2653213alchemizes
alchymies1942883alchymies
alchymy2041843alchym_y
alcoholic1663713alcoholic
alembic1354773al__embic
allelic9118173al_lelic
aloetic9313183al_oetic
alopecic1444323alopecic
anaemic1149903a_naemic
anemic102713693a__nemic
anoxemic1945593anoxemic
anthemia1349193anthemia
aphetic142912853a_phetic
archaic1438823arch_aic
ascetic11310063asc_etic
aspheric1547983aspheric
asthenic1378633asthenic
azotemic2194863azotemic
biochemic2044633biochemic
cachexic2153543cachexic
chemics16349583__chemics
chymic18317883__chymic
hemic125718623___hemic
ischemia1544073ischemia
lexemic1844283_lexemic
lithemic1545593lithemic
racemic1336983rac_emic

Search took 7 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 Filter1786911461620.486367677.0
2DLD Change Limit146162466.42022766.7
3Display Results46460.0162875.0
 (SQL Overall)178691466.92225814.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.