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

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

115 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
magnification214576(None) 
magnifications2245111magnifications
lignification19125702lignification
signification1986282signification
ammonification2353043ammonification
amplification2275183amplification
basification19127323ba_sification
calcification1945823calcification
caprification2256053caprification
cornification2046693cornification
dandification2045903dandification
falsification2145243falsification
gasification1867103ga_sification
lignifications20135113lignifications
magnetization2554833magnetization
magnificat1853333magnificat___
magnificats1952353magnificat__s
modification20107203m_odification
mollification20135553mollification
mortification2087293mortification
mummification2154313mummification
mystification2346193mystification
nazification2646043na_zification
pacification2168053pa_cification
ramification1998213ra_mification
ratification17810663ra_tification
reunification18147453reunification
saponification21103533saponification
significations20125673significations
uglification1845493_uglification
unification1648733__unification
vinification2068233_vinification
acetification2046724acetification
acidification2154884acidification
ammonifications2453044ammonifications
amplifications2384754amplifications
annihilation1594504_annihilation
basifications20137064ba_sifications
beatification20138074beatification
beautification21144884beautification
calcifications2045414calcifications
caprifications2385564caprifications
certification2048604certification
citification1949154_citification
clarification2045764clarification
classification21113214classification
coalification2046134coalification
codification20108074_codification
cornifications2145954cornifications
dandifications2145434dandifications
deification17411664__deification
densification1947334densification
edification1749354__edification
emulsification2193444emulsification
falsifications2244974falsifications
fortification2196924fortification
gasifications19116844ga_sifications
glorification1984894glorification
gratification1946684gratification
humification2246104_humification
identification2054994identification
jollification25134844jollification
justification2546094justification
latensification2071924latensification
lithification21105164lithification
magnetizations2654284magnetizations
magnifical1853104magnifica___l
magnifically2353344magnifica_lly
magnifico1762574magnific___o_
magnificos1862004magnific___os
manifestation1871994ma_nifestation
manipulation1654664ma_nipulation
mastication15610294ma__stication
maximization3255214ma_ximization
minimization25127194m_inimization
modifications21106984m_odifications
mollifications21145204mollifications
mortifications2186504mortifications
mummifications2254014mummifications
mystifications2445644mystifications
nazifications2745524na_zifications
nidification1847454_nidification
nitrification1877064nitrification
notification1749064_notification
nullification1854694nullification
ossification17116544_ossification
pacifications2267354pa_cifications
petrification2048814petrification
pontification2089004pontification
preunification2154304preunification
purification1948174_purification
qualification2745034qualification
quantification28124934quantification
ramifications2087534ra_mifications
ratifications1899784ra_tifications
rectification2049514rectification
reification16412904__reification
reunifications19136914reunifications
rigidification2173144rigidification
sanctification2154704sanctification
sanitization2149154sa_nitization
saponifications22133324saponifications
scarification2056404scarification
significative2261764significative
specification2245764specification
typification2244864_typification
uglifications1945194_uglifications
unifications1748044__unifications
verification201810644_verification
versification21157494versification
vilification2077124_vilification
vinifications2177694_vinifications
vitrification2166464vitrification
vivification2366344_vivification
zombification3154064zombification

Search took 6 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 Limit950241154.75020005.1
3Display Results1151150.0761513.2
 (SQL Overall)1786911155.18634456.4
 
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.