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

137 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
classifications228308(None) 
classification21113211classification_
clarifications2155262cla_rifications
basifications20137063_ba_sifications
calcifications2045413c_alcifications
caprifications2385563c_aprifications
clarification2045763cla_rification_
classificatory247753classificat_ory
coalifications2155703coa_lifications
falsifications2244973_falsifications
gasifications19116843_ga_sifications
ossifications18176143__ossifications
assimilations1555204__assimilations
basification19127324_ba_sification_
beatifications21157464bea_tifications
beautifications22154684beautifications
calcification1945824c_alcification_
caprification2256054c_aprification_
certifications2147794c_ertifications
citifications2048544c__itifications
claudications1852884cla__udications
coalification2046134coa_lification_
codifications21127624c__odifications
cornifications2145954c_ornifications
dandifications2145434_dandifications
densifications2046984_densifications
emulsifications2283134emulsifications
falsification2145244_falsification_
gasification1867104_ga_sification_
glorifications2074584gl_orifications
gratifications2045984gra_tifications
justifications2645554_justifications
lignifications20135114_lignifications
lithifications22134794_lithifications
magnifications2245114_magnifications
mystifications2445644_mystifications
nazifications2745524_na_zifications
ossification17116544__ossification_
pacifications2267354_pa_cifications
plasticizations2853534plasticizations
qualifications2844584qua_lifications
quantifications29114404quantifications
ramifications2087534_ra_mifications
ratifications1899784_ra_tifications
scarifications2155764sca_rifications
versifications22166914_versifications
acetifications2146055_acetifications
acidifications2254635_acidifications
ammonifications2453045ammonifications
amplifications2384755_amplifications
assignations1344165__assi_gnations
assimilation1455525__assimilation_
associations1445755__associ_ations
beatification20138075bea_tification_
beautification21144885beautification_
cassations1276875c_ass____ations
castigations1547205c_a_s_tigations
certification2048605c_ertification_
citification1949155c__itification_
claudication1753325cla__udication_
codification20108075c__odification_
cornification2046695c_ornification_
dandification2045905_dandification_
deifications18410655___deifications
denazifications30164085denazifications
densification1947335_densification_
detoxifications2884255detoxifications
dissimilations1755865_dissimilations
edifications1848695___edifications
emulsification2193445emulsification_
esterifications20134815esterifications
fortifications2286215_fortifications
fossilizations2654685_fossilizations
fructifications25113355fructifications
gentrifications2175045gentrifications
glorification1984895gl_orification_
gratification1946685gra_tification_
humidifications2652815humidifications
humifications2345855__humifications
identifications2154495identifications
jollifications26144595_jollifications
justification2546095_justification_
laciniations1445915_la_cini_ations
laicizations2347415_la__icizations
latensification2071925_latensification_
latinizations22159015_la_tinizations
lignification19125705_lignification_
lithification21105165_lithification_
magnification2145765_magnification_
mastications1649415_ma_s_tications
modifications21106985__modifications
mollifications21145205_mollifications
mortifications2186505_mortifications
mummifications2254015_mummifications
mystification2346195_mystification_
nazification2646045_na_zification_
nidifications1946945__nidifications
nitrifications1986635_nitrifications
notifications1848235__notifications
nullifications1954305_nullifications
pacification2168055_pa_cification_
passivations1764435_pass__ivations
petrifications2148025_petrifications
plasticization2764005plasticization_
pontifications2187915_pontifications
prettifications22135185prettifications
purifications2047465__purifications
qualification2745035qua_lification_
quantification28124935quantification_
ramification1998215_ra_mification_
ratification17810665_ra_tification_
recodifications23165455recodifications
rectifications2148915_rectifications
reifications17411825___reifications
reunifications19136915_reunifications
revivifications2694055revivifications
rigidifications2282885rigidifications
sanctifications2254135sanctifications
saponifications22133325saponifications
scarification2056405sca_rification_
significations20125675_significations
silicifications2253075silicifications
simplifications2463195simplifications
solidifications2153575solidifications
specifications2345355_specifications
stratifications2054235stratifications
stultifications2083535stultifications
typifications2344635__typifications
uglifications1945195__uglifications
unifications1748045___unifications
verifications21159975__verifications
versification21157495_versification_
vilifications2166745__vilifications
vinifications2177695__vinifications
vitrifications2275965_vitrifications
vivifications2486125__vivifications
zombifications3263765_zombifications

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.310576422.6
2DLD Change Limit658741374.20315673.1
3Display Results1371370.0931473.1
 (SQL Overall)1786911374.60638795.3
 
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.