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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

109 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
decarboxylation3081861decarboxylation_
decarboxylating3181852decarboxylati_ng
carboxylation2772663__carboxylation_
carboxylations2862333__carboxylations
carbonylation2052574__carbonylation_
carbonylations2162264__carbonylations
carboxylating2862654__carboxylati_ng
decarbonation18143984decarbo__nation_
decarbonations19123154decarbo__nations
decarboxylate28112464decarboxylat___e
decarboxylated30112174decarboxylat__ed
decarboxylates29102304decarboxylat__es
decarbonating1953235decarbo__nati_ng
decarboxylase2892035decarboxyla___se
decarboxylases29111785decarboxyla__ses
decarburization2962295decarburization_
carbonation1545856__carbo__nation_
carbonations1644846__carbo__nations
carbonization2675496__carbonization_
carbonizations2774956__carbonizations
carboxylate2563196__carboxylat___e
carboxylated2752636__carboxylat__ed
carboxylates2653006__carboxylat__es
decollation1448196dec___o_llation_
decollations1547366dec___o_llations
dicarboxylic2961446dicarboxyl__i__c
hydroxylation3063366_hydr_oxylation_
hydroxylations3163126_hydr_oxylations
arborization2347887___arborization_
arborizations2447427___arborizations
carbonating1645867__carbo__nati_ng
carboxylase2552597__carboxyla___se
carboxylases2662387__carboxyla__ses
carboxylic2652717__carboxyl__i__c
carburization2654587__carburization_
carburizations2754127__carburizations
cocarboxylase2981597cocarboxyla___se
cocarboxylases3081437cocarboxyla__ses
dealation10313007de_a_____lation_
dealations11311377de_a_____lations
debarkation1844247debar____kation_
debarkations1943657debar____kations
decalcification2262807decalcification_
decantation1448947deca____ntation_
decantations1547947deca____ntations
decapitation1748687deca___pitation_
decapitations1847667deca___pitations
decarbonate1654447decarbo__nat___e
decarbonated1853447decarbo__nat__ed
decarbonates1753917decarbo__nat__es
decarbonizing2853057decarbo__nizi_ng
decasualization2763507decasualization_
decerebration1884197decer__ebration_
decerebrations1993747decer__ebrations
decertification2364327decertification_
dechlorination2053417dec_hlorination_
dechlorinations2153117dec_hlorinations
declaration1447837declar_____ation_
declarations1546807declar_____ations
decollating1545977dec___o_llati_ng
decolonization26146027dec_olonization_
decolonizations27145967dec_olonizations
decolorization26136417dec_olorization_
decolorizations27136107dec_olorizations
decoration13314427dec___o__ration_
decorations14312887dec___o__rations
decortication1857537decor__tication_
decortications1966777decor__tications
decrepitation1884807dec_r_epitation_
decrepitations1984347dec_r_epitations
decryption1843737dec_r___y_ption_
decryptions1943617dec_r___y_ptions
defibrillation2061907de_fibrillation_
defibrillations2161697de_fibrillations
degranulation1552917de_gr_anulation_
degranulations1652747de_gr_anulations
demarcation1647027demar____cation_
demarcations1746127demar____cations
demodulation1644697de___modulation_
demodulations1754147de___modulations
deoxidation2045957de____oxidation_
deoxidations2145247de____oxidations
depopulation1765067de___population_
depopulations1844497de___populations
deregulation1446087de__r_egulation_
deregulations1545207de__r_egulations
derogation12410397de__r_o__gation_
derogations1349397de__r_o__gations
desolation11311407de___so__lation_
desolations12310597de___so__lations
deterioration14145287deterio__ration_
deteriorations15164697deterio__rations
detoxication2246207de___toxication_
detoxications2355657de___toxications
disarticulation1863577disarticulation_
elaboration1345747_ela_bo__ration_
elaborations1444927_ela_bo__rations
hydroxylating3163247_hydr_oxylati_ng
perambulation1953487peramb__ulation_
perambulations2053077peramb__ulations
percolation1549227pe__rco__lation_
percolations1648057pe__rco__lations
recalculation17114597reca__lculation_
recalculations18104037reca__lculations
recapitulation1862497reca_pitulation_
recapitulations1972397reca_pitulations
recirculation1764907recir__culation_
recirculations1884227recir__culations
scarlatina1294057_scar____lati_na

Search took 10 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 Filter178691950240.360496363.9
2DLD Change Limit950241098.76610840.1
3Display Results1091090.0761434.2
 (SQL Overall)1786911099.20219418.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.