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

88 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
latensification207192(None) 
intensification2092762intensification
densification1947333__densification
acetification2046724_ace_tification
basification19127324ba___sification
classification21113214cla__ssification
dandification2045904da__ndification
densifications2046984__densifications
diversification24102784diversification
esterification1995334este_rification
falsification2145244fa__lsification
gasification1867104ga___sification
identification2054994_identification
lignification19125704l_ign_ification
lithification21105164lit__hification
magnification2145764ma_gn_ification
ratification17810664rat___ification
saponification21103534sapon_ification
versification21157494__versification
acetifications2146055_ace_tifications
acidification2154885_a_cidification
ammonification2353045_ammonification
amplification2275185_a_mplification
basifications20137065ba___sifications
beatification20138075__beatification
calcification1945825ca__lcification
caprification2256055ca__prification
certification2048605__certification
citification1949155cit___ification
clarification2045765cla___rification
classifications2283085cla__ssifications
cornification2046695_corn_ification
dandifications2145435da__ndifications
decertification2364325decertification
deification17411665__de__ification
denazification29154435__denazification
desensitization25152955desensitization
desertification2154125desertification
detoxification2754415det_oxification
edification1749355___e_dification
emulsification2193445_emulsification
esterifications20134815este_rifications
falsifications2244975fa__lsifications
frenchification2872025_frenchification
gasifications19116845ga___sifications
gentrification2065635__gentrification
gratification1946685grat___ification
identifications2154495_identifications
indemnification2372005indemnification
lateralization2367465late_ralization
laterization21410685late___rization
latinization21139525lat___inization
lignifications20135115l_ign_ifications
lithifications22134795lit__hifications
luteinization2255305lute__inization
magnifications2245115ma_gn_ifications
nazification2646045na___zification
nitrification1877065nit__rification
notification1749065not___ification
objectification3181875objectification
ossification17116545___ossification
pacification2168055pa___cification
petrification2048815__petrification
pontification2089015__pontification
prenotification2253605_prenotification
prettification21115715_prettification
preunification2154305_preunification
quantification28124935_quantification
ramification1998215ra___mification
ratifications1899785rat___ifications
recertification2263985recertification
rectification2049515__rectification
reification16412905__re__ification
reunification18147455__reunification
sanctification2154705sa_nctification
saponifications22133325sapon_ifications
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 5 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.326548131.9
2DLD Change Limit65874884.17315785.8
3Display Results88880.0631396.8
 (SQL Overall)178691884.56239169.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.