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

95 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
acylations154760(None) 
acylation1448651acylation_
ablations11311512a_blations
acetylations1743542acetylations
actuations1239292actuations
acylating1547572acylati_ng
adulations11310122adulations
alations82518892a__lations
alkylations1843352alkylations
maculations1569622maculations
scalations1239782scalations
ablation10312433a_blation_
ablutions1146603a_blutions
abolitions1246653abolitions
acclamations18164043acclamations
acclimations18146293acclimations
accretions1444923accretions
accusations1546003accusations
acetylation1643783acetylation_
acidulations15104813acidulations
actions94218513ac___tions
activations1669263activations
actuation11310333actuation_
acylates1339743acylat__es
acyloins1345903acyl_oi_ns
adnations1039753a_dnations
adorations11310233adorations
adulation10311013adulation_
aerations9317903a_erations
agitations11310063agitations
agnations10310033a_gnations
alation72920553a__lation_
alkylation1743823alkylation_
ambulations1547113ambulations
angulations1268053angulations
animations12312193animations
annulations1167833annulations
arcuations1249343arcuations
aviations12311553a_viations
avocations15168683avocations
butylations1643223butylations
calculations1647073calculations
cancelations1657093cancelations
carnations12311353carnations
caseations1258303caseations
cassations1276873cassations
cations94524143_c__ations
caudations13108223caudations
causations1268143causations
chelations1539073chelations
ciliations121111003_ciliations
citations11312503_citations
clarions10310493_c_larions
collations12312853collations
conations111318903_conations
creations112614543_creations
dealations11311373dealations
deflations1439713deflations
delations102616593_delations
dilations102614453_dilations
ejaculations2195213ejaculations
elations83719123__elations
emulations12310943emulations
epilations12311713epilations
escalations1347663escalations
fellations1338063fellations
gelations102513093_gelations
gyrations1336923_gyrations
halations12312393_halations
illations9311393_illations
inflations13310323inflations
isolations10310693isolations
jactations1936893jac_tations
lacerations1348333lacerations
lactations1239423lac_tations
lallations1038743lallations
macerations1548473macerations
maculation14510983maculation_
oblations1139373_oblations
osculations1348373osculations
ovulations1337973ovulations
peculations15310283peculations
reflations13311233reflations
relations92418333_relations
sacculations1646663sacculations
scalation11311073scalation_
solations9814623_solations
sublations12410113sublations
tabulations1346853tabulations
ululations1037143ululations
vacations141910553vac__ations
vacillations1744883vacillations
vacuolations1743783vacuolations
vallations1339093vallations
violations1337963violations

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 Filter1786911406030.440406115.9
2DLD Change Limit140603955.95023630.8
3Display Results95950.0631507.9
 (SQL Overall)178691956.45327691.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.