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

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

139 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
classifications2283081classifications_
classification21113212classification__
clarifications2155263cla_rifications_
basifications20137064_ba_sifications_
calcifications2045414c_alcifications_
caprifications2385564c_aprifications_
clarification2045764cla_rification__
classificatory247754classificat_o_ry
coalifications2155704coa_lifications_
falsifications2244974_falsifications_
gasifications19116844_ga_sifications_
ossifications18176144__ossifications_
assimilations1555205__assimilations_
basification19127325_ba_sification__
beatifications21157465bea_tifications_
beautifications22154685beautifications_
calcification1945825c_alcification__
caprification2256055c_aprification__
certifications2147795c_ertifications_
citifications2048545c__itifications_
claudications1852885cla__udications_
coalification2046135coa_lification__
codifications21127625c__odifications_
cornifications2145955c_ornifications_
dandifications2145435_dandifications_
densifications2046985_densifications_
emulsifications2283135emulsifications_
falsification2145245_falsification__
gasification1867105_ga_sification__
glorifications2074585gl_orifications_
gratifications2045985gra_tifications_
justifications2645555_justifications_
lignifications20135115_lignifications_
lithifications22134795_lithifications_
magnifications2245115_magnifications_
mystifications2445645_mystifications_
nazifications2745525_na_zifications_
ossification17116545__ossification__
pacifications2267355_pa_cifications_
plasticizations2853535plasticizations_
qualifications2844585qua_lifications_
quantifications29114405quantifications_
ramifications2087535_ra_mifications_
ratifications1899785_ra_tifications_
scarifications2155765sca_rifications_
versifications22166915_versifications_
acetifications2146056_acetifications_
acidifications2254636_acidifications_
ammonifications2453046ammonifications_
amplifications2384756_amplifications_
assignations1344166__assi_gnations_
assimilation1455526__assimilation__
assimilationism1971566__assimilationism
assimilationist1761796__assimilationist
associations1445756__associ_ations_
beatification20138076bea_tification__
beautification21144886beautification__
cassations1276876c_ass____ations_
castigations1547206c_a_s_tigations_
certification2048606c_ertification__
citification1949156c__itification__
claudication1753326cla__udication__
codification20108076c__odification__
cornification2046696c_ornification__
dandification2045906_dandification__
deifications18410656___deifications_
denazifications30164086denazifications_
densification1947336_densification__
detoxifications2884256detoxifications_
dissimilations1755866_dissimilations_
edifications1848696___edifications_
emulsification2193446emulsification__
esterifications20134816esterifications_
fortifications2286216_fortifications_
fossilizations2654686_fossilizations_
fructifications25113356fructifications_
gentrifications2175046gentrifications_
glorification1984896gl_orification__
gratification1946686gra_tification__
humidifications2652816humidifications_
humifications2345856__humifications_
identifications2154496identifications_
jollifications26144596_jollifications_
justification2546096_justification__
laciniations1445916_la_cini_ations_
laicizations2347416_la__icizations_
latensification2071926_latensification__
latinizations22159016_la_tinizations_
lignification19125706_lignification__
lithification21105166_lithification__
magnification2145766_magnification__
mastications1649416_ma_s_tications_
modifications21106986__modifications_
mollifications21145206_mollifications_
mortifications2186506_mortifications_
mummifications2254016_mummifications_
mystification2346196_mystification__
nazification2646046_na_zification__
nidifications1946946__nidifications_
nitrifications1986636_nitrifications_
notifications1848236__notifications_
nullifications1954306_nullifications_
pacification2168056_pa_cification__
passivations1764436_pass__ivations_
petrifications2148026_petrifications_
plasticization2764006plasticization__
pontifications2187916_pontifications_
prettifications22135186prettifications_
purifications2047466__purifications_
qualification2745036qua_lification__
quantification28124936quantification__
ramification1998216_ra_mification__
ratification17810666_ra_tification__
recodifications23165456recodifications_
rectifications2148916_rectifications_
reifications17411826___reifications_
reunifications19136916_reunifications_
revivifications2694056revivifications_
rigidifications2282886rigidifications_
sanctifications2254136sanctifications_
saponifications22133326saponifications_
scarification2056406sca_rification__
significations20125676_significations_
silicifications2253076silicifications_
simplifications2463196simplifications_
solidifications2153576solidifications_
specifications2345356_specifications_
stratifications2054236stratifications_
stultifications2083536stultifications_
typifications2344636__typifications_
uglifications1945196__uglifications_
unifications1748046___unifications_
verifications21159976__verifications_
versification21157496_versification__
vilifications2166746__vilifications_
vinifications2177696__vinifications_
vitrifications2275966_vitrifications_
vivifications2486126__vivifications_
zombifications3263766_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.1101624463.6
2DLD Change Limit658741394.61014289.4
3Display Results1391390.1101263.6
 (SQL Overall)1786911394.83036996.1
 
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.