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

85 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
acrylic149628(None) 
acrylics1584361acrylics
acetylic1543572acetylic
acronic112814692acronic
acrotic112515542acrotic
acyclic1345572acyclic
alkylic16174232alkylic
allylic12155842allylic
amylic13108712a_mylic
dactylic1643672dactylic
aboulic1156283aboulic
abulic106411423a_bulic
acerbic1335643acerbic
acetic10314503ac_etic
acholia1239973acholia
achromic1747613achromic
acidic113612133ac_idic
acinic104713543ac_inic
aclinic11188973aclinic
acmatic13311703acmatic
acmic11312333ac__mic
acrasia9310033acrasia
acrasin9311223acrasin
acrid86920103acr__id
acrolect1247423acrolect
acrolein1045853acrolein
acrolith1348453acrolith
acromia1139963acromia
acronymic1885003acronymic
acrostic1239943acrostic
acrylate1347693acrylate
actinic111810553actinic
acyl95314293ac_yl__
acyloin1247463ac_yloin
acyls104211523ac_yl_s
aerobic11310213aerobic
agravic1345893agravic
alkalic13146973alkalic
allelic9118173allelic
angelic1039623angelic
aortic8316613aor_tic
apraxic1846293apraxic
aprotic112715243aprotic
arabic10312733a_rabic
archaic1438823archaic
arctic10313513a_rctic
areic73219393a_r_eic
aryl75922343a_ryl__
aryls87015813a_ryl_s
atelic8313703a_telic
atresic9310003atresic
atretic9313923atretic
atypic13337653a_typic
aulic74420243a__ulic
auric74521743aur__ic
barytic1437823barytic
beylic1337823_beylic
cacodylic1652573cacodylic
carbolic1448323carbolic
carlin84421823car_lin
caroli85918233caroli_
caryatic1548503caryatic
chymic18317883_chymic
colic95726173_c_olic
cresylic1543083_cresylic
cretic102816283_cretic
crisic103611843_crisic
critic103616813_critic
cryonic1437833_cryonic
cryptic1646153_cryptic
cyclic1238033_cyclic
cylix17448623_c_ylix
cynic124712423_c_ynic
dactyli1343603dactyli_
dactylics1742123dactylics
ecbolic1345623ecbolic
ethylic1546323ethylic
frolic1149203_frolic
garlic9310043gar_lic
hexylic2243033hexylic
pachalic1757273pachalic
phylic16279553_phylic
relic74623363__relic
sibylic1444633sibylic
vinylic1543883vinylic

Search took 8 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.410435831.7
2DLD Change Limit134027856.67020094.0
3Display Results85850.0302833.3
 (SQL Overall)178691857.11025132.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.