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

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

64 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
caffeinated205204(None) 
decaffeinated2361122decaffeinated
affricated1943853_affricated
caffeine1644513caffein__e_
caffeines1743913caffein__es
carinated123414263ca__rinated
caseinate1148243ca_seinate_
caseinates1247443ca_seinates
catenated1238913ca_te_nated
raffinate1545023raff_inate_
raffinates1644363raff_inates
abominated1545204_abominated
acuminated1545874_acuminated
affected1744794_affe__cted
affianced1843034_aff_ianced
affiliated1744194_affiliated
affined1436414_aff_in__ed
afflicted1843434_affli_cted
affricate1744974_affricate_
affricates1844614_affricates
affrighted2152054_affrighted
affronted1642504_affron_ted
alienated1047744_alie_nated
alternated1145724_alternated
cachinnated1951894cachinnated
caffein1535334caffein____
caffeinic1991384caffein__ic
caffeins1645124caffein___s
calumniated1652874calumniated
capacitated1852454capacitated
capitated14159044ca__pitated
captivated1844764ca_ptivated
carbonated1547244ca_rbonated
carinate103320244ca__rinate_
caseated11310714ca_se__ated
casemated1446954ca_se_mated
castellated1443274castellated
castigated1446324ca_stigated
catenate10312834ca_te_nate_
catenates11311814ca_te_nates
catkinate1545824ca_tkinate_
caveated1439134ca_ve__ated
cavitated15177354ca__vitated
chlorinated1744494chlorinated
coffined1735994coff_in__ed
coordinated1553514coordinated
crenated113013914c__re_nated
criminated1546824c_riminated
culminated1546104c_ulminated
cybernated1842824c_ybernated
effeminate1852974_effeminate_
effeminates1952604_effeminates
fascinated1645874fa_scinated
feinted11379624___fein_ted
laminated122610284la__minated
lancinated1345574la_ncinated
machinated1845664ma_chinated
marginated14187344ma_rginated
marinated122513174ma__rinated
paginated13309464pa__ginated
patinated123911414pa__tinated
vaccinated1855444va_ccinated
vaginated14328154va__ginated
vaticinated1753434vaticinated

Search took 9 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 Filter1786911488190.436409841.7
2DLD Change Limit148819648.45317605.5
3Display Results64640.0331939.4
 (SQL Overall)178691648.92220028.1
 
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.