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

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

83 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
intensification209276(None) 
latensification2071922latensification
densification1947333__densification
identification2054993i_dentification
indemnification2372003indemnification
densifications2046984__densifications
diversification24102784diversification
esterification1995334este_rification
identifications2154494i_dentifications
interdigitation1763144interdigitation
intervisitation1862854intervisitation
nitrification1877064nit__rification
versification21157494__versification
acetification2046725_ace_tification
ammonification2353045ammon_ification
basification19127325___basification
beatification20138075__beatification
certification2048605__certification
citification1949155cit___ification
classification21113215_classification
cornification2046695_corn_ification
dandification2045905__dandification
decertification2364325decertification
deification17411665__de__ification
denazification29154435__denazification
desensitization25152955desensitization
desertification2154125desertification
detoxification2754415det_oxification
edification1749355___e_dification
emulsification2193445_emulsification
esterifications20134815este_rifications
falsification2145245__falsification
frenchification2872025_frenchification
gasification1867105___gasification
gentrification2065635__gentrification
inconsideration1871865inconsideration
infantilization2762035infantilization
inteneration1248625inten___eration
interanimation16136015inte_ranimation
interdiction1568145inte__rdic_tion
interiorization2464785interiorization
interlineation1455405interli_neation
intermediation17105215intermedi_ation
internalization2455765internalization
intersection14610185inters__ec_tion
interstation12410415inters___tation
intimidation1547365int___imidation
intoxication21156355int___oxication
investigation1754085inve_s_tigation
lignification19125705_lign_ification
lithification21105165lit__hification
magnification2145765_magn_ification
nazification2646045_n__azification
nidification1847455_n__idification
nitrifications1986635nit__rifications
notification1749065_n__otification
nullification1854695_n_ullification
objectification3181875objectification
ossification17116545___ossification
petrification2048815__petrification
pontification2089015__pontification
prenotification2253605_prenotification
prettification21115715_prettification
preunification2154305_preunification
quantification28124935_quantification
ratification17810665rat___ification
recertification2263985recertification
rectification2049515__rectification
reification16412905__re__ification
reunification18147455__reunification
saponification21103535sapon_ification
sensitisation13153645__sensitisation
sensitization22146725__sensitization
signification1986285_sign_ification
specification2245765_spe_cification
stratification1954675_stratification
stultification1963905_stultification
typification2244865__t_ypification
unification1648735___un_ification
verification201810645__ve_rification
versifications22166915__versifications
vinification2068235__vin_ification
vitrification2166465vit__rification

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.470380193.6
2DLD Change Limit65874836.12310758.5
3Display Results83830.0631317.5
 (SQL Overall)178691836.65626846.6
 
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.