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

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

150 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
classification2111321(None) 
classifications2283081classifications
clarification2045762cla_rification
basification19127323_ba_sification
calcification1945823c_alcification
caprification2256053c_aprification
clarifications2155263cla_rifications
classificatory247753classificatory
coalification2046133coa_lification
falsification2145243_falsification
gasification1867103_ga_sification
ossification17116543__ossification
assimilation1455524__assimilation
basifications20137064_ba_sifications
beatification20138074bea_tification
beautification21144884beautification
calcifications2045414c_alcifications
caprifications2385564c_aprifications
certification2048604c_ertification
citification1949154c__itification
claudication1753324cla__udication
coalifications2155704coa_lifications
codification20108074c__odification
cornification2046694c_ornification
dandification2045904_dandification
densification1947334_densification
emulsification2193444emulsification
falsifications2244974_falsifications
gasifications19116844_ga_sifications
glorification1984894gl_orification
gratification1946684gra_tification
justification2546094_justification
latensification2071924_latensification
lignification19125704_lignification
lithification21105164_lithification
magnification2145764_magnification
mystification2346194_mystification
nazification2646044_na_zification
ossifications18176144__ossifications
pacification2168054_pa_cification
plasticization2764004plasticization
qualification2745034qua_lification
quantification28124934quantification
ramification1998214_ra_mification
ratification17810664_ra_tification
scarification2056404sca_rification
versification21157494_versification
acetification2046725_acetification
acidification2154885_acidification
ammonification2353045ammonification
amplification2275185_amplification
assignation1244375__assi_gnation
assimilations1555205__assimilations
association1346155__associ_ation
beatifications21157465bea_tifications
beautifications22154685beautifications
cassation1197915c_ass____ation
castigation1447975c_a_s_tigation
certifications2147795c_ertifications
citifications2048545c__itifications
classicality1952905class__icality
classicistic1562145classici_sti_c
classifiable1961705classifi_a_ble
claudications1852885cla__udications
codifications21127625c__odifications
commodification2791875commodification
cornifications2145955c_ornifications
dandifications2145435_dandifications
deacidification2472695deacidification
decalcification2262805decalcification
deification17411665___deification
demystification26102695demystification
denazification29154435denazification
densifications2046985_densifications
detoxification2754415detoxification
dissimilation1656525_dissimilation
diversification24102785diversification
edification1749355___edification
electrification2263415electrification
emulsifications2283135emulsifications
esterification1995335esterification
fortification2196925_fortification
fossilization2565145_fossilization
fructification2483675fructification
gentrification2065635gentrification
glorifications2074585gl_orifications
gratifications2045985gra_tifications
humidification2552905humidification
humification2246105__humification
identification2054995identification
intensification2092765intensification
jollification25134845_jollification
justifications2645555_justifications
laciniation1346635_la_cini_ation
laicization2247905_la__icization
latinization21139525_la_tinization
lignifications20135115_lignifications
lithifications22134795_lithifications
magnifications2245115_magnifications
mastication15610295_ma_s_tication
modification20107205__modification
mollification20135555_mollification
mortification2087295_mortification
mummification2154315_mummification
mystifications2445645_mystifications
nazifications2745525_na_zifications
nidification1847455__nidification
nitrification1877065_nitrification
notification1749065__notification
nullification1854695_nullification
pacifications2267355_pa_cifications
passivation16104745_pass__ivation
personification2272385personification
petrification2048815_petrification
plasticizations2853535plasticizations
pontification2089015_pontification
prettification21115715prettification
preunification2154305preunification
purification1948175__purification
qualifications2844585qua_lifications
quantifications29114405quantifications
ramifications2087535_ra_mifications
ratifications1899785_ra_tifications
recodification22125665recodification
rectification2049515_rectification
reification16412905___reification
reunification18147455_reunification
revivification2564225revivification
rigidification2173145rigidification
sanctification2154705sanctification
saponification21103535saponification
scarifications2155765sca_rifications
signification1986285_signification
silicification2153165silicification
simplification2353385simplification
solidification2053555solidification
specification2245765_specification
stratification1954675stratification
stultification1963905stultification
syllabification2561545syllabification
typification2244865__typification
uglification1845495__uglification
unification1648735___unification
verification201810645__verification
versifications22166915_versifications
vilification2077125__vilification
vinification2068235__vinification
vitrification2166465_vitrification
vivification2366345__vivification
zombification3154065_zombification

Search took 8 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.516346300.4
2DLD Change Limit950241506.61014375.8
3Display Results1501500.1061415.1
 (SQL Overall)1786911507.23224708.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.