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

113 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
categorizations2710388(None) 
categorization26104251categorization_
allegorizations25112903allegorizations
catechizations3053533cate_chizations
cauterizations25197153caute__rizations
laterizations22410073late__rizations
allegorization24103114allegorization_
arborizations2447424_a_rborizations
atomizations2348474_at__omizations
authorizations2655094_authorizations
bacterizations2766664bacte__rizations
canonizations2447244ca__nonizations
carbonizations2774954ca_rbonizations
carburizations2754124ca_rburizations
cartelizations2556554carte__lizations
catechization2953994cate_chization_
categorizing2553454categoriz__i_ng
catheterization2962404catheterization_
cauterization24187754caute__rization_
colorizations241410354c__olorizations
creolizations2457884c_re_olizations
factorizations2855764fa_ctorizations
lateralizations2487004lateralizations
laterization21410684late__rization_
memorizations2649534__memorizations
motorizations2449124mot__orizations
pasteurizations2674004paste_urizations
patronizations2576194pat_ronizations
temporizations2785754__temporizations
terrorizations2356174__terrorizations
theorizations2576164__theorizations
valorizations2597794va__lorizations
vaporizations2776964va__porizations
actualizations25126965act_ualizations
aldolizations2346345_a_ldolizations
amortizations2456465_a__mortizations
anodizations2276925_a__nodizations
arborization2347885_a_rborization_
atomization2249245_at__omization_
authorization2555855_authorization_
bacterization26107215bacte__rization_
barbarizations27115445ba_rbarizations
canalizations24410435ca__nalizations
canonization2347925ca__nonization_
capitalizations2856055capitalizations
carbonization2675495ca_rbonization_
carburization2654585ca_rburization_
cartelization2456995carte__lization_
categorising1652575categori__si_ng
categorizes2354195categoriz____es
catenations1348365cate____nations
chlorinations1855535c__hlorinations
cicatrizations2794915c_icatrizations
colonizations24229425c__olonizations
colorization231711195c__olorization_
conveyorization3281845conveyorization_
creolization2348815c_re_olization_
curarizations2447475c__urarizations
decolorizations27136105decolorizations
deionizations2349215__deionizations
demonizations25410245__demonizations
deodorizations2556325_deodorizations
dimerizations2548545dime__rizations
envenomizations29161555envenomizations
erotizations21411005___erotizations
eternizations2258075_ete_rnizations
etherizations2557235_et_herizations
extemporization3562435extemporization_
exteriorization3173075exteriorization_
factorization2756285fa_ctorization_
fiberizations27136365fibe__rizations
fraternizations27153755frate_rnizations
ghettoizations2751965ghetto_izations
glamorizations2664585_glamorizations
harmonizations28124835ha_rmonizations
illegalizations2564135illegalizations
integrations13129475integ_r__ations
interiorization2464785interiorization_
itemizations2347845_ite__mizations
lateralization2367465lateralization_
latinizations22159015lat__inizations
legalizations23410675__legalizations
linearizations2355925line_arizations
literalizations2476995literalizations
luteinizations2355065lute_inizations
martyrizations2854475ma_rtyrizations
memorization2549925__memorization_
motorization2349705mot__orization_
naturalizations2455765naturalizations
negotiations1345155__negoti_ations
notarizations2248805not__arizations
pasteurization2584445paste_urization_
patronization2456755pat_ronization_
peregrinations17114685pereg_rinations
racemizations2665475race__mizations
randomizations2653685ra_ndomizations
ratiocinations1674145rat_iocinations
renegotiations15113375renegoti_ations
revalorizations2754555revalorizations
sclerotizations26223065sclerotizations
sterilizations2357985_sterilizations
suberizations2468775sube__rizations
temporization2675995__temporization_
tenderizations2455695__tenderizations
terrorization2256665__terrorization_
tetanizations2249915__tetanizations
theorization2456765__theorization_
valorization2478415va__lorization_
vaporization2697535va__porization_
velarizations2549275__velarizations
vulgarizations2754565_vulgarizations
weatherizations3054075weat_herizations
winterizations26157505winte__rizations

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.330541487.9
2DLD Change Limit658741134.48314694.2
3Display Results1131130.0961177.1
 (SQL Overall)1786911134.90936400.7
 
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.