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

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
desulfurization2861821desulfurization_
desulfurizing2761644desulfuriz__i_ng
decarburization2962295decarburization_
decolorization26136405decol_orization_
decolorizations27136095decol_orizations
depolarization26136475depol_arization_
depolarizations27146325depol_arizations
desalinization2455615desal_inization_
desalinizations2555385desal_inizations
regularization2455155regul_arization_
regularizations2564885regul_arizations
secularization2565635secul_arization_
secularizations2675375secul_arizations
dechlorination2053416dechl_orination_
dechlorinations2153106dechl_orinations
decolonization26146026decol_onization_
decolonizations27145966decol_onizations
deglamorization2882326deglamorization_
dehumanization2954506dehu_manization_
dehumanizations3054376dehu_manizations
deodorization2456456de__odorization_
deodorizations2556296de__odorizations
deputization2447216de___putization_
deputizations2546736de___putizations
desacralization2754166desacralization_
desalination13411126desal___ination_
desalinations14410176desal___inations
desensitization25152946desensitization_
desexualization3263436desexualization_
destabilization2763326destabilization_
desulfuring1651936desulfur____i_ng
desulfurize2452036desulfuriz_____e
desulfurized2661736desulfuriz____ed
desulfurizes2551856desulfuriz____es
dieselization2356046diesel___ization_
dieselizations2455896diesel___izations
nebulization2347196nebul___ization_
nebulizations2446676nebul___izations
pasteurization2584416pas_teurization_
pasteurizations2673986pas_teurizations
popularization2754276popul_arization_
popularizations2853986popul_arizations
pressurization2593126pres__surization_
pressurizations2692716pres__surizations
pulverization2754706__pulverization_
pulverizations28104486__pulverizations
reauthorization2762316reauthorization_
repolarization25116286repol_arization_
repolarizations26136166repol_arizations
revalorization2664836reval_orization_
revalorizations2754556reval_orizations
solarization211810156__sol_arization_
solarizations22219256__sol_arizations
suberization2359226__su_berization_
suberizations2468756__su_berizations
sulfurating1594576__sulfur__ati_ng
sulfurizing2453376__sulfuriz__i_ng
summarization2655276__summarization_
summarizations2754826__summarizations
vascularization2972166vascul_arization_
velarization2449896ve__l_arization_
velarizations2549266ve__l_arizations
vulgarization2654816__vulgarization_
vulgarizations2754556__vulgarizations

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 Filter178691658740.1261418182.5
2DLD Change Limit65874646.28010489.5
3Display Results64640.0461391.3
 (SQL Overall)178691646.45227695.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.