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

78 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
acyclic134557(None) 
cyclic1238031_cyclic
acrylic1496282acrylic
alicyclic1552202alicyclic
amylic13108712amy_lic
bicyclic1643332bicyclic
cyclin1339272_cyclin
dicyclic1543862dicyclic
encyclic1444252encyclic
aboulic1156283aboulic
abulic106411423a_bulic
acacia10311353acac_ia
acclaim1345783ac_claim
acerbic1335643acerbic
acetic10314503ac_etic
acetylic1543573acetylic
acholia1239973acholia
acidic113612133ac_idic
acinic104713543ac_inic
aclinic11188973aclinic
acmatic13311703acmatic
acmic11312333a__cmic
acronic112814693acronic
acrotic112515543acrotic
acrylics1584363acrylics
actinic111810553actinic
acyclovir1951603acyclovir
acyl95314293acy_l__
acyloin1247463acyloin
acyls104211523acy_l_s
alcaic1039983a_lcaic
alkalic13146973alkalic
alkylic16174233alkylic
allelic9118173allelic
allylic12155843allylic
angelic1039623angelic
arctic10313513a_rctic
atactic11410083atactic
atelic8313703a_telic
atypic13337653aty_pic
aulic74420243a__ulic
bacchic1545813bac_chic
beylic1337823bey_lic
calcic9311873calc_ic
coccic8298943_coccic
colic95726173_c_olic
cyanic133110773_cyanic
cycle1239523_cycl_e
cycled1436543_cycled
cycler1335913_cycler
cycles1339303_cycles
cyclical1445653_cyclical
cyclicly1742613_cyclicly
cycling1537213_cycling
cyclins1438303_cyclins
cyclist1438853_cyclist
cyclize2345403_cyclize
cyclo1237703_cycl_o
cycloid1539283_cycloid
cyclonic1446973_cyclonic
cyclos1338073_cyclos
cylix17448623_cy_lix
cymlin1337313_cymlin
cynic124712423_cy_nic
cystic132710653_cystic
dactylic1643673dactylic
ecbolic1345623ecbolic
encyclics1552763encyclics
epicyclic1753373epicyclic
exocyclic2253043exocyclic
glycolic1643963glycolic
idyllic1342973idyllic
isocyclic1552853isocyclic
noncyclic1554073noncyclic
pachalic1757273pachalic
phylic16279553phy_lic
psychic1944833psychic
tricyclic1553153tricyclic

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 Filter1786911340270.406440125.6
2DLD Change Limit134027786.31321230.3
3Display Results78780.0302600.0
 (SQL Overall)178691786.74926476.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.